Need to create report to get ip's of phones in Vlan's on switches through NCM

noobes

I need to create a report preferably through NCM which will allow me to get a handle on the IP's of all phones within voice Vlan's on switches. I know one extremely long winded way of doing this and it would be to first run a scheduled job from NCM. I could run "sh ip int brief | i Vlan" on a group of switches in one site which would return me a list of Vlan's on the switches, I would then need to sift through the jobs log to see the returned Vlans and see what Vlan's are on what switches, I could then run

"sh ip arp Vlan 800" 801, 802 etc depending on what I get back from  "sh ip int brief | i Vlan". This would be very costly in terms of time resources though! Is there any way I can query the config I have on NCM to create a report which will allow me to do this in a quicker cleaner way? Any input is greatly appreciated!!!

zyl

Hello,

There is some 'tricky' way to do this...

Just create normal Report (from NCM), pick ARP Tables and select some properties:

Filter out nodes. Keep nodes/sites where are you looking for phones.

Save Report.

Edit your report by using some text editor (notepad?).

File path: "<Your SolarWinds installation>/SolarWinds/Orion/NCM/Reports/<Your Report>.ConfigMgmtReport"

Add two times:

                       AND            (ArpTables.MAC LIKE '00809f%')

(in my example I have filtred nodes by Vendor = Cisco)

MAC starting 00:80:9F stands for Alcatel phones.

Save file.

Done.

Remember, everytime you edit this report, you must write those two lines inside file (text editing...).

NCM flushes those lines when you are trying to change report.

PS. About duplicate entries, you can fix this by messing around with "Group/Merge similar rows" option

or Properties position in columns.

Best regards,

Mateusz