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
Home
Products
Network Performance Monitor (NPM)
Report on Custom Properties for all nodes
bobmarley
--I created a daily report that displays the Ip address, Caption, NodID, and all of my custom properties --The report runs daily and sends a CZV file to me as well as posts it out to a network drive --I use this as a backup in case the custom properties get accidentally deleted, so I can import them back in if needed. --Replace the Cp1, CP2, etc with your custom property names - if you have more or less you can add or remove the CPx --As long as the last one does not have a comma (,) after it. --When you make your web based report make sure you select table, advanced and then SWQL --code below Select IP_Address, Caption, NodeID, CP1, CP2, CP3, CP4, CP5, CP6 FROM Orion.NodesCustomProperties cp INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID Order BY Caption
Find more posts tagged with
Accepted answers
All comments
There are no accepted answers yet
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of
