SWQL Query in Email Body -

I have a SQWL query in the body of my email alert.
${N=SWQL;M=SELECT OriginalName AS Tag FROM Orion.VIM.TagCustomPropertiesMapping WHERE Name LIKE '%ORION%' }

In this case it returns 3 records when you run it in SWQL Studio, which is the expected result.
orion1
orion2
orion3

In the email, however it only shows 1 record, the first returned from the query "orion1" as it should.
How can I concatenate the result to display it one one line: "orion1, orion2, orion3" ?

Find more posts tagged with

swql query

vmware tag

email alerts

Accepted answers

All comments

jm_sysadmin

Does this help? Concat Orion Variable with string in SWQL? - Orion SDK - The Orion Platform - THWACK (solarwinds.com)

rhether

I tried that:
${N=SWQL;M=SELECT CONCAT(OriginalName,' - ') AS Tag FROM Orion.VIM.TagCustomPropertiesMapping WHERE Name LIKE '%ORION%' }

Output is: orion1 -

The issue is I have to CONCAT the result from the Query, combining x # of records onto 1 line

rhether

I could not do this in SWQL
I was able to do it in SQL

SELECT STRING_AGG(OriginalName, ' | ') AS result FROM [Orion].[dbo].[VIM_GroupingCustomPropertiesMapping] WHERE Name LIKE '%orion%'