Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

i need a query for create report of resources

sadiqsul

hi all

i need a query to create a report of nodes with resources as well i need to add my custom property location

Find more posts tagged with

Accepted answers

All comments

adam.beedell

What do you mean by "nodes with resources"?

Location is already a property, you could add an equivalent though, Settings -> Custom properties -> Node -> Add

sadiqsul

hi adam

i have query for node with their interfaces but i want to add location on this query . how can i add ? i have already created location under custom propery

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

adam.beedell

Select ... ,a.customproperties.location