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

Adding location details to nonSNMP nodes

Ive a few nodes that have SNMP blocked by thier ISP and i was wondering how i would go about filling out the (normally SNMP) location and contact detail fields without getting the info from SNMP. any ideas?

Find more posts tagged with

Accepted answers

All comments

DonYonce

ERB,
In version 7.x you can add a couple custom properties (called Device_Location and Device_Contact for example) and place the information in these fields. Then add a resource to the "Node Details" view to show these custom properties.

One other method ...
Since these nodes are type 'ICMP' instead of 'SNMP' you could enter them manually into the database instead.
First, shutdown the Orion NetPerfMon Polling Engine Service (from the Control Panel Services applet or from the "Stop NetPerfMon" utility included with Version 7.x)

Then open the database directly using the SolarWinds Database Manager and execute the following query (right click on Nodes table and select "Query"):

Select Top 1000 Caption,IP_Address,Location,Contact From Nodes Where ObjectSubType = 'ICMP'

Click the "Read-Write" option at the top of the Query window. This allows you to change the database directly.

Enter the Location and Contact for each Node.

Restart the SolarWinds NetPerfMon Polling Engine Service.

Since these Nodes are ICMP only, the Location and Contact you entered manually into the database will never get overwriten via SNMP.

Don

ironmike2000

I know this is a really old thread and I hope someone sees this post. I'm trying to to this exact thing on version 9.5. I shut down the NPM service, update the Location and Contact fields with my custom data. At that point the info is confirmed updated in the database. Once I restart the service, these fields get overwritten.

Has anyone worked out a way to do this on version 9.5?

Jim_McCormick

Ditto on Ironmike's request.
I monitor about 2000 devices spread over 80 sites. At each site, the switches are housed in one of several TRs. On each switch, I use the snmp-server location field for the site location and then the snmp-server contact field for which technical room its in.

In NPM, Nodes are displayed by location, then contact. The problem is that I monitor up and down state of servers at each location. This is done by ICMP only. Now, the node tree's first item is "Unknown" and within it are all the servers. I'd like the server to appear under it's location but keep them as ICMP monitored only.

BillFitz

You cannot retain the data in the fields that are used by Orion to store data collected by SNMP.

For this reason we provide the ability to create custom fields and populate those (you can update many at one time under Manage Nodes).

Unless I am misunderstanding your question, you will need to create a custom property to do this.

On your Orion server in the Solarwinds Orion program group you will see Grouping and Access Control, Custom Property Editor. If you haven't seen it yet I think you will find that it is what you are looking for.

Any custom property you create is also eligible to be used in the Nodes Tree grouping as well. I've seen some clients do very elaborate grouping this way.

Hope that helps.

ironmike2000

Ok, I'm cool with that. I do have some custom properties that I will use for this purpose.

With that said, has anyone created any SQL scripts or NPM jobs to read the values in the Orion SNMP fields (Contact and Location) and write them to a custom property? That would solve my problem. At this point I am doing it by hand in the custom property editor.

I'm not a SQL guru so any help with something to do this is much appreciated.

Thanks

sedmo

The SQL query should look like this:

update nodes

set xxx = Contact, yyy = Location

xxx will be the name of your custom property field that will hold the information in the Contact field and yyy will be the name of the custom property field that will hold the Location data.