Displaying Powershell script output in a widget

hebridean

I'm trying to create a widget to display DHCP scope information using a Powershell script. I have created a Powershell application monitor template and assigned it to a DHCP server node. The script writes output using the format "Write-Output "Message.DHCP: $DHCPScopeID Utilisation: $percentUtilization"
Testing it against the DHCP server works fine.
I now need to create a widget that displays the output of the powershell script in a table, but I haven't been able figure that bit out.
I've tried adding a "Custom Object Resource" and "Custom Table" but i can't see how to get the script output displayed.

Any help appreciated very much appreciated, I'm at a loss just now

bobmarley

I use a Custom Query resource to get to those tables, below is an example. Change the Where to fit your needs. 

SELECT Caption, ErrorMessage, NodeID, ComponentName, ComponentType, ComponentAvailability, ComponentPortNumber, ComponentStatisticData 
FROM Orion.APM.CurrentStatistics cp
INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID
--Where ComponentName LIKE 'SSL Certificate Expiration Date Monitor' AND ComponentStatisticData < 31 --displays only 31 days or less
Order BY ComponentStatisticData, ErrorMessage ASC