GroupRootCause Spacing

xfaulknor

Hello All,

I'm trying to send a big email with the statuses of a group's members. I've noticed that the code ${N=OrionGroup;M=GroupStatusRootCause} would show all members in a email but it would appear as a wall of text. Ill attach my output.

Just wanted to see if it's possible to have a new line break/spacing in between each member in the variable GroupStatusRootCause?

Thanks

attachments.zip

xfaulknor

So I've searched around Thwack to get this code and it works but in the email it just stops prematurely like there is a character limit or something?

Code:

${SQL:SELECT cast(cast([GroupMemberFullName]as varchar(max)) + '' + ' ' + '-' + ' ' as XML),

cast(cast([GroupMemberStatusName]as varchar(max)) + '' + CHAR(10) + CHAR(13) as XML)

FROM  [SolarWindsOrion].[dbo].[Containers_AlertsAndReportsData]

where   GroupID=${GroupID}  FOR XML PATH('')}

Result stops in emails