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

How do I get a report on nodes that do not have any one of three custom properties defined?

I have created 3 custom properties for nodes. I would like to run a report that will show me those nodes that do not have any one of the custom properties defined. They are:

AzureSubscription

GEHCProdLine

Classification

I can either use the SWIS API or better yet I would like to be able to write a custom report to do this in report manager.

As always, thanks for the help!

Find more posts tagged with

Accepted answers

Petr.Vilem

https://thwack.solarwinds.com/servlet/JiveServlet/download/282338-63750/Nodes%2Bmissing%2BAzureSubscription.xml

All comments

rharland2012

I believe you could edit a vanilla 'All Nodes' report and use SQL statements in the 'edit resource' piece of the Report Builder to define only nodes that don't have a defined value for these custom properties (or if these custom properties are yes/no, then do it that way).

Petr.Vilem

Try to import attached report - it is created only with first mentioned custom property, but it should not be problem to extend it.

Nodes+missing+AzureSubscription.xml

brent.weaver

Petr, Thank you VERY much for taking the time to respond. I do not see anything attached, what am I missing?

Thanks.

Petr.Vilem

https://thwack.solarwinds.com/servlet/JiveServlet/download/282338-63750/Nodes%2Bmissing%2BAzureSubscription.xml

brent.weaver

Thank you everyone for your help here. I was totally able to do this without incident. Being an open source guy I almost always overthink things ...

SolarWinds is really a nice, well thought out product and I am very pleased with the community and product!

FormerMember

Hi brent.weaver@ge.com‌,

I'm glad to hear that. And if you feel that SAM or any other SW product saved your bacon, you might want to share your thoughts in the Spread the Word forum, and you'll get a $25 e-gift card from Amazon.