List All Resources in Widget

Here is one I use.  It's really old but still seems to be working.  It does not include SAM monitors or API pollers (API pollers didn't even exist when I wrote this)

Select Monitor, _IconFor_Monitor, _LinkFor_Monitor, Current, Warning, _LinkFor_Warning, Critical, _LinkFor_Critical from (
Select
'CPU' as Monitor,
CASE
WHEN t.IsLevel1State = False THEN '/Orion/images/StatusIcons/Small-Up.gif'
WHEN t.IsLevel1State = True and IsLevel2State = False THEN '/Orion/images/StatusIcons/Small-Warning.gif'
WHEN t.IsLevel2State = True THEN '/Orion/images/StatusIcons/Small-Down.gif'
END as [_IconFor_Monitor],
'orion.dtc.corp/.../NodeDetails.aspx as [_LinkFor_Monitor],
t.CurrentValue as Current,
t.Level1Value as Warning,
'orion.dtc.corp/.../NodeProperties.aspx as [_LinkFor_Warning],
t.Level2Value as Critical,
'orion.dtc.corp/.../NodeProperties.aspx as [_LinkFor_Critical]
from Orion.Nodes n
inner join Orion.NodesThresholds t on t.InstanceId = n.NodeID
WHERE
t.name='Nodes.Stats.CpuLoad' AND
t.instanceId = 3861 AND
not n.ObjectSubType = 'ICMP' AND
t.CurrentValue > -1
UNION (
Select
'Memory' as Monitor,
CASE
WHEN t.IsLevel1State = False THEN '/Orion/images/StatusIcons/Small-Up.gif'
WHEN t.IsLevel1State = True and IsLevel2State = False THEN '/Orion/images/StatusIcons/Small-Warning.gif'
WHEN t.IsLevel2State = True THEN '/Orion/images/StatusIcons/Small-Down.gif'
END as [_IconFor_Monitor],
'orion.dtc.corp/.../NodeDetails.aspx as [_LinkFor_Monitor],
n.PercentMemoryUsed as Current,
t.Level1Value as Warning,
'orion.dtc.corp/.../NodeProperties.aspx as [_LinkFor_Warning],
t.Level2Value as Critical,
'orion.dtc.corp/.../NodeProperties.aspx as [_LinkFor_Critical]
from Orion.Nodes n
inner join Orion.NodesThresholds t on t.InstanceId = n.NodeID
WHERE
t.name='Nodes.Stats.PercentMemoryUsed' AND
t.instanceId = 3861 AND
not n.ObjectSubType = 'ICMP' AND
t.CurrentValue > -1
)
Union (
-- Disk Monitors
SELECT
v.Caption as Monitor,
CASE
WHEN v.VolumePercentUsed is null THEN '/Orion/images/StatusIcons/Small-Unknown.gif'
WHEN v.PercentDiskUsedThreshold.IsLevel2State = True THEN '/Orion/images/StatusIcons/Small-Down.gif'
WHEN v.PercentDiskUsedThreshold.IsLevel1State = True THEN '/Orion/images/StatusIcons/Small-Warning.gif'
ELSE '/Orion/images/StatusIcons/Small-Up.gif'
END as [_IconFor_Monitor],
v.DetailsURL as [_LinkFor_Monitor],
Round(v.VolumePercentUsed,0) as Current,
v.PercentDiskUsedThreshold.Level1Value as Warning,
'orion.dtc.corp/.../NodeProperties.aspx as [_LinkFor_Warning],
v.PercentDiskUsedThreshold.Level2Value as Critical,
'orion.dtc.corp/.../NodeProperties.aspx as [_LinkFor_Critical]
From Orion.Volumes v
Where NodeID = 3861
and v.Type in ( 'Fixed Disk', 'Mount Point', 'FixedDisk', 'MountPoint' )
))

Thanks brscott.  I tried putting this code into a modern dashboard using a table widget, but the validation fails.  It doesn't like 'orion' in the select clause.  I replaced your URL with mine but no change.  Any thoughts on this?
Thanks,
Joe

You are correct that will not work on a modern dashboard.  I misunderstood the assignment.  I thought you were doing this on the node summery page for a specific node.  So you want a list of all nodes and their resources on one single widget on a modern dashboard?

Or if you want a specific node on a modern dashboard it would work if you search and replace ${NODEID} with the nodeid you want.  If that works then you can modify it to use the node caption instead of nodeid.

Sorry for the delayed response.  Sort of.  I would like a widget that displays a single node along with all resources AND the resource alert status.  I would probably use a list of sites to drill down to the nodes, which would then drill down to specific nodes and resources.  Does this make sense?

Log a Feature Request here

"How To Create Ideas and Feature Requests" - thwack.solarwinds.com/.../DOC-167238

I don't think this is how NPM works. You need to select the resource first (in List Resources), NPM then assigns a poller and starts polling the data into respective table. Some resources don't have a simple status (e.g. L2 Topology, VLANs). What you still could try is compiling a list of different data polled for a node, but this would be something like the code shared by others earlier.

Once the resources are selected in List Resources, a widget should be able to pull the status of those resources.  I'm particularly interested in drive space, which should be something readily available.

Once the resources are selected in List Resources, a widget should be able to pull the status of those resources.  I'm particularly interested in drive space, which should be something readily available.