User227

Thanks Matthew. Will give it a try

Zak, Thanks for the reply. Yes that is the desired result, however we have tried the filter where Availability is not equal to 100 and various other combinations, but the data is not being parsed. I was not sure if there was a known bug in the SQL design for this. Thanks, Scott

I have since used the ${GroupStatusRootCause} variable to display any group member with an issue, but is there a a variable for listing all group members? Something like: ${GroupMemberDisplayNameAll}. I would like to enter a variable such as: Group contains members: ${GroupMemberDisplayNameAll} and have the output in am…

Thanks, I didn’t realize there was an option under the ‘Reporting’ menu at the top of the Orion Report Writer that would display the SQL commands when you click on ‘Show SQL’. Cheers,