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

Auditing Custom properties

Hello,

I need a query on custom property. Example : City = 'Atlanta'. Here I have created a drop down menu against Custom property "City" and its value is "Atlanta". Now, I would like to find where this custom property is being used in solarwinds where City = 'Atlanta'

Even if it's being used anywhere in views, groups, resources, Alerts etc.

Also, if my CP is in bits like (Zone1 = 'True'), I would need to find the same in entire solarwinds.

Please help me finding this.

Thank you.

@AlexSoul

@mesverrum

Find more posts tagged with

Accepted answers

All comments

mesverrum

Finding every scenario where a property exists tends to be fairly simple, but finding every possible variation of syntax to map to a specific value in that property would be a huge effort. For your example we'd need to be string parsing for scenarios like all of the below and many more to have any chance of being accurate

city = 'Atlanta'

city='Atlanta'

city like 'atlanta'

city like '%atlanta%'

city in ('atlanta','etc etc')

WinterSoldier

I have referred this article : https://thwack.solarwinds.com/t5/Report-Lab-Documents/Node-Custom-Properties-uses-report/ta-p/532605

Tried using this xml. However, I can get the report of CP which are in bits like (Zone1 = 'True') but I am not getting values of Custom properties where I have created a drop down list.

Example : My CP is City = 'Atlanta' where City has a drop down list like Atlanta, Texas, Newyork etc. How can I find that? Please suggest.

sturdyerde

It sounds like you need to do some custom DB queries to find all uses of a custom property with a specific value. While this may not answer your question, I still want to share an immensely useful post from @mesverrum: NODE CUSTOM PROPERTIES USES REPORT.

WinterSoldier

Yes and Thank you, @sturdyerde

Tried using this xml. However, I can get the report of CP which are in bits like (Zone1 = 'True/False') but I am not getting values of Custom properties where I have created a drop down list.

Example : My CP is City = 'Atlanta' where City has a drop down list like Atlanta, Texas, Newyork etc. How can I find that? Please suggest.

jaimin.pithadia

Hi,

Any clue on above request?