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 > Include Custom Property values in Alerts

Include Custom Property values in Alerts

Table of contents
Created by Chris Foley, last modified by Chris Foley on Feb 01, 2017

Views: 1,541 Votes: 2 Revisions: 5

Overview

This article provides the macros you can use within an Alert Action to pull a Custom Property value from a Node, a Volume, an interface or an Application.

Environment

  • SAM version 6.2.0 or later
  • All Windows versions

Steps

1. Edit the Alert Action you wish to add the Custom Property to.

2. Enter one of the following Macros:

 

  • For the Custom Property of a Node:

${N=SwisEntity;M=Node.CustomProperties.[PropertyName]}

 

  • For the Custom Property of a Volume or an Interface:

${N=SwisEntity;M=CustomProperties.[PropertyName]} 

 

  • For the Custom Property of an Application:

 

SQL:
${SQL: SELECT [PropertyName] FROM APM_ApplicationCustomProperties WHERE ApplicationID =${N=SwisEntity;M=ApplicationID;F=OriginalValue} }

 

SWIS:
${N=SWQL;M=SELECT [PropertyName] FROM Orion.APM.ApplicationcustomProperties WHERE ApplicationID =${N=SwisEntity;M=ApplicationID;F=OriginalValue}}


Note: Replace [PropertyName] with the name of the Custom Property.

 

3. Click Save Changes.

 

 

Last modified

Tags

Classifications

Public