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

List of nodes by view type (report)

hello! I need a report on the provision of a custom node, but so that all assets (installed by default and manually) are included in the report Ideally, the report should be in the form of:

Find more posts tagged with

Reports

Accepted answers

All comments

bobmarley

There was a report already on Thwack that had some of what you need List of nodes by view type - Forum - Network Performance Monitor (NPM) - THWACK (solarwinds.com)

I added a few things to it here. If you put this into a custom swql report it should look like what was requested.


--Note ICMP Nodes will return as Unknown in DeviceType
SELECT
     n.caption AS [Node Name]
    ,n.IPAddress as [IP_Address]
    ,v.ViewGroupName AS [Assigned View Name]
    ,vd.DeviceType

FROM Orion.NodeSettings ns

join Orion.Views v on ns.SettingValue = v.ViewID

join Orion.Nodes n on ns.NodeID = n.NodeID

join Orion.Viewsbydevicetype vd on ns.SettingValue = v.ViewID

where SettingName = 'ViewID' And vd.ObjectType like 'n'

Order By DeviceType ASC

AlexBell

Great! Or maybe you can also help how to get DeviceType from the [NodesCustomProperties] table?

bobmarley

Change the YOURCUTOMPROPERTIES to match yours below.

--Note ICMP Nodes will return as Unknown in DeviceType
SELECT
     n.caption AS [Node Name]
    ,n.IPAddress as [IP_Address]
    ,v.ViewGroupName AS [Assigned View Name]
    ,vd.DeviceType
    ,[n].CustomProperties.YOURCUSTOMPROPERTIES

FROM Orion.NodeSettings ns

join Orion.Views v on ns.SettingValue = v.ViewID

join Orion.Nodes n on ns.NodeID = n.NodeID

join Orion.Viewsbydevicetype vd on ns.SettingValue = v.ViewID

where SettingName = 'ViewID' And vd.ObjectType like 'n'

Order By DeviceType ASC