Hi Team,
Little background story:
I am currently dealing with an Cisco WLC 9800-L that has a few APs behind it, the WLC has SNMP on it and is working properly.
However, I was asked to setup SolwarWinds Atlas Map with the APs in it showing some details (initially we were hoping for a heat map, but SolarWinds does not support the WLC in question).
My idea was to get the info for the APs from the Cisco WLC. After a lot of Googling and ChatGPTing, here is where I am at:
I found a few OIDs to give me some details on the APs behind the WLC (e.g: bsnApIpAddress 1.3.6.1.4.1.14179.2.2.1.1.19 and bsnAPName 1.3.6.1.4.1.14179.2.2.1.1.3) However, when I add this to the UDP, it gives me the APs IPs and the AP Names into a Tabular format that I cannot use to add to the Network Atlas Map.
My goal is to show all the APs with it's information beside on a map, but in order to do that, I would need to format that data, which I have tried, but without any success. I saw some options to use SQL query, however, I am a pretty beginner with all of that, and would like to stick with "the easiest way" (sticking to GUI) if there is any.
Would anyone be able to assist me with that? Transforming a Tabular output into a ordered list to show on the map?
Here is what I would like it to look like in the Atlas Map.
Name: AP01 Status: Online IP: 192.168.0.1 Temperature: 22C
Name: AP02 Status: Online IP: 192.168.0.2 Temperature:22C
Name: AP03 Status: Online IP: 192.168.0.3 Temperature:22C
Name: AP04 Status: Online IP: 192.168.0.4 Temperature:22C
Name: AP05 Status: Online IP: 192.168.0.5 Temperature:22C
What is the easiest way to achieve that? Keep in mind that enabling SNMP on the AP itself is NOT an option as I was told that since the AP is behind the WLC that cannot be done.
Thank you in advance.