Hi,
Please bare in mid I am very new to Solarwinds and have almost no knowledge in SQL/SWQL or scripting so I apologize in advance if I sound very lost.. It's because I am!
I went through several dozen threads in the forum regarding autopopulation of Custom Fields. I understand that there are two approaches -
1. Using API along with Powershell
or
2. With SQL/SWQL along with the Alerting functionalities of Solarwinds.
Basically what I want to achieve is exactly what is discussed here:
https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/95845/how-to-populate-custom-properties-using-swql-and-an-alert-action/302601#302601
but the problem is that what I want to populate is coordinates. We have Cisco switches and all of them have the ability to be configured with coordinates which look like this in the configuration:
location geo-location identifier <name>
latitude 30.467614102257855
longitude 33.24462890625001
The discussion above solves half of my question and explains very well how to set up the Alert condition and Trigger but what I need is to get these 2 lines - latitude and longitude which I cannot seem to find anywhere in the database tables. I know they will exist in the configuration files that are pulled daily by NCM but still I do not know how to pull them from there. So my question is do you have any ideas how can I take the value of these two lines from the config or the database if they are stored somewhere in order to insert them in Custom Properties?
They do not appear when I try to search for them in the Configure Action: Change Custom Property window.
