looking for report of list of resources

thwack.solarwinds.com/.../how-to-pull-the-report-of-list-all-list-resource

hi bro

not getting result 

I would assume you copy paste the query correct?

yes

then that's the problem.  The nodeID listed there is just an example.

ok . i want list all the nodeID . how can i do that 

It is discussed on the link.

Unfortunately, I no longer have a Solarwinds environment so I can't do testing of queries.  You will need to play around it.  I'm not sure if anyone else has figured out to do it via a query as it seems you will need to have a Node ID as an index to other tables.

I would suggest for you to file a feature request and paste it here and I will vote for it to pick up steam.

ok bro thank you 

hi bro

i got the query 

here it is 

Select A.Resources, A.Resources_Name , A.IP_Address , A.Nodes
From(
select 'Interfaces' as Resources, I.InterfaceName as Resources_Name , N.IP_Address as IP_Address, N.Caption as Nodes
From NodesData N Join Interfaces I On I.NodeID = N.NodeID
Union
select 'Volumes' as Resources , V.VolumeDescription as Resources_Name , N.IP_Address as IP_Address, N.Caption as Nodes
From NodesData N Join Volumes V On V.NodeID = N.NodeID
) A
Order By A.Nodes

hi bro

i got the query 

here it is 

Select A.Resources, A.Resources_Name , A.IP_Address , A.Nodes
From(
select 'Interfaces' as Resources, I.InterfaceName as Resources_Name , N.IP_Address as IP_Address, N.Caption as Nodes
From NodesData N Join Interfaces I On I.NodeID = N.NodeID
Union
select 'Volumes' as Resources , V.VolumeDescription as Resources_Name , N.IP_Address as IP_Address, N.Caption as Nodes
From NodesData N Join Volumes V On V.NodeID = N.NodeID
) A
Order By A.Nodes