Hi,
This is my first post on the Thwack forum. I have been using Solarwinds NPM and SAM for some time now but recently decided to setup some modern dashboards for our screens in the office.
I have created a UDP for our APC ATS devices and i would like to take the data and present it in a friendly format.
The custom SWQL query is below, please note that i am not a DBA so my scripting knowledge is very limited!
SELECT TOP 100 n.DisplayName, n.CustomPollerName, n.Node.DisplayName AS Node_DisplayName, n.CurrentValue, n.CustomPollerStatus.RawStatus FROM Orion.NPM.CustomPollerAssignmentOnNode n WHERE (n.Node.DisplayName LIKE '%ATS%')
This returns the correct values however i am looking to create a table in the format below:
Any ideas how i can get the data into the example above as it currently looks like this:
Thanks in advance 
