Inserting a variable in alert email only if value is not empty

How do I insert a variable into the body of an email alert only if the variable is not blank.
e.g if the custom property name is RunBook and the value is :KB1234"

how would I get it to insert: "Runbook: KB1234"
otherwise if the value is empty, nothing is displayed.

Should be an easy one, I did search the forums.

Find more posts tagged with

email alert

npm

Alerting

Accepted answers

rhether

I was able to figure it out a few hours after posting it.

${SQL:SELECT ISNULL('MyText :'+[RunBook],'') FROM [ORION].[dbo].[Nodes] where NodeID = ${N=SwisEntity;M=NodeID}}

I was surprised I did not have to use 'CustomProperties.RunBook', I got away just using 'RunBook'

All comments

sum_giais

Use a custom SWQL Variable for that. Here's an attempt at one.. does it work? Sorry not able to test at the moment.

${N=SWQL;M=SELECT ISNULL('${N=SwisEntity;M=CustomProperties.RunBook}', 'Value NULL OOPS') AS val1 FROM Orion.Nodes AS n}

rhether

I was able to figure it out a few hours after posting it.

${SQL:SELECT ISNULL('MyText :'+[RunBook],'') FROM [ORION].[dbo].[Nodes] where NodeID = ${N=SwisEntity;M=NodeID}}

I was surprised I did not have to use 'CustomProperties.RunBook', I got away just using 'RunBook'