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
Store

Can anyone let me know how to get a full list of node custom properties via a SWIS session?

FormerMember

Or how do I tell if a field in the nodes table is a custom property?

Thanks,

Daniel

Find more posts tagged with

Accepted answers

All comments

zackm

Once you are on NPM 11.5 or later, the traditional Nodes table is split up into 3 different tables in the database (NodesCustomProperties, NodesData, and NodesStatistics). These 3 tables are combined into the dbo.Nodes view in order to retain functionality for everyone who has been historically using the Nodes table for things.

In the SWQL Studio, you should be able to see a similar breakout within the Orion.Nodes, Orion.NodesCustomProperties, and Orion.NodesStats tables.

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

FormerMember

Thanks for the explanation ZackM. In our instance the Orion.Nodes has become Orion.NodesOld and the rest are exactly what you said.

Now have a basic question - how do I extract all the field names from Orion.NodesCustomProperties and NodesData tables? Is there a SWQL syntax for that?

tdanner

In general, you can query for the properties of any entity type by querying Metadata.Property, like this:

SELECT NameFROM Metadata.PropertyWHERE EntityName='Orion.NodesCustomProperties'

However, this will include navigation properties and inherited properties like Uri and InstanceType that you probably aren't interested in. You can include those like this:

SELECT NameFROM Metadata.PropertyWHERE EntityName='Orion.NodesCustomProperties'  AND IsNavigable=false  AND IsInherited=false

That will give you the list of the names of the actual custom properties on nodes, plus one extra item: NodeID. You can exclude that with one more clause:

SELECT NameFROM Metadata.PropertyWHERE EntityName='Orion.NodesCustomProperties'  AND IsNavigable=false  AND IsInherited=false  AND Name != 'NodeID'

FormerMember

Thanks for the excellent information Tim