Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Unable to filter resources using Node Custom Properties

Unable to filter resources using Node Custom Properties

Overview

Resources cannot be filtered using Node Custom Properties in SAM.

Environment

SAM 6.2

Cause 

The Nodes table has been split in SAM 6.2.

Resolution

Depending on the report selected, take note of the different syntax to be used:

Resource: Application with Problems 
Filter: Use SWQL syntax
For example: Nodes.CustomProperties.Region = 'NEZ'

 

Resource: Report from Orion Report Writer
Report: Current Status of Each Application
Filter: Use SQL syntax
For example: Region = 'NEZ'

 

 

 

 

Last modified

Tags

Classifications

Public