Submit a ticketCall us
Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Application alerts that include Orion.APM.Application variable do not generate email in SAM

Application alerts that include Orion.APM.Application variable do not generate email in SAM

Updated January 7, 2018

Overview

An alert that included ObjectType and Orion.APM.Application as custom SQL variables in the email title and body did not generate email for the following query:

${SQL:Select ApplicationEmails FROM APM_ApplicationCustomProperties WHERE ApplicationID = ${ApplicationID}}

Macro parsing failed with the following message: MACRO SQL ERROR - Incorrect syntax near '{'

Environment

  • SAM 6.7 and later

Cause

The macro parser cannot resolve the 'Orion.APM.Application' variable.

Resolution

  • Use the following variable instead: ${N=SwisEntity;M=ApplicationID}
Last modified

Tags

Classifications

Public