Macro expansion in email messages not working with AppInsightforSQL macros

Question

SAM V 6.0.0

Constructed Alert email :

Subject

SQL Database ${DatabaseName} on ${NodeName} is now OK

Body:

Database Name     ${DatabaseName}

DB URL                  ${AppInsightforSQL:DatabaseDetailsURL}

AlertName               ${Alert}

Email output of alert:

Subject:

SQL Database DATABASENAME on  is OK

Body:

Database Name DATABASENAME 
          DB URL ${AppInsightforSQL:DatabaseDetailsURL}
          AlertName APP PROD Databases

Problems:

*  ${NodeName} is not resolving
* ${AppInsightforSQL:DatabaseDetailsURL} is not resolving

Thoughts ?

cgregors · Answer

ok, found 1 answer. Use ${Node.Caption} not  ${NodeName}

Still can't figure out ${AppInsightforSQL:DatabaseDetailsURL}