96x1 and 1600 Series SNMP Inventory - Anyone Interested? 1

[IPOthermia]

This post is just to gauge interest. I use a freeware tool to keep track of about 900 phones at 35 locations across the country. If having the details about how to do this is of interest to you let me know and I'll post it here if there is enough interest.

 

[phoneguy55]

Your post sparked my interest.

 

[kyle555]

Yes, very much so!

 

[IPOthermia]

I have been using a freeware program since late 2012 to generate inventory of IP phones – 1600 and 96x1 models. The program can be found here ->

http://www.snmpview.de/xxx0815.php

In ASA - change system-parameters ip-options
See page 3 and set your community name. It must match the community name in the devices.txt file.
There must also be a node name here for the IP address of the PC you are using to collect this data.

There are three files to pay attention to in the directory where SNMPview is installed:

Devices.txt:
10.140.1.110;$IpAddr;MYcommName;1;
10.140.1.112;$IpAddr;MYcommName;1;
x
x
x - create a record for each of your IP addresss where there is a phone. If you only have a few subnets hit all addresses.
x - phones from the TTI list can also be inventoried
x - phones that haven't completed unnamed registration will also answer SNMP, but they do not show up on the TTI list.
x - These lines are filler and you may have dozens or hundreds of lines here, not just the four I included
x - One of these models doesn't care about the community name, but the other one DOES!
x
x
10.140.1.201;$IpAddr;MYcommName;0;
10.140.1.202;$IpAddr;MYcommName;0;

Community – must match your setting in ASA
0 or 1 – These match a table of OID’s in the SNMPview.cfg file.
Blank lines in this file will crash SNMPview

This file may be hundreds of lines long. I usually export my List Registration from ASA and using a spreadsheet to create the lines shown above.
1600 Phones rely on table 0
96x1 Phones rely on table 1

Snmpview.cfg:

The [Header] section shown here is where SNMPview gets its column header information.
The OID’s are contained in the Tables 0 and 1. This program supports 50 tables.
It is worth reading the config file carefully, there are some other cool things this program can do.
I have a setup for collecting gateway information such as temperature and fan speeds.

Edit the following sections in this file as shown

[Header]
0=location
1=system
2=name
3=MAC
4=SN
5=IPAddress
6=PN
7=MN
8=Ext
9=Uptime

(Text Omitted)

#OID-Tabelle 0 - 1600
[OID0]
1=2.1.1.1.0
2=2.1.1.5.0
3=4.1.6889.2.69.3.1.42.0
4=1.3.6.1.4.1.6889.2.69.3.1.46.0
5=
6=4.1.6889.2.69.3.1.45.0
7=4.1.6889.2.69.3.1.43.0
8=4.1.6889.2.69.3.6.3.0
9=1.3.6.1.2.1.1.3.0

#OID-Tabelle 1 - 9600
[OID1]
1=2.1.1.1.0
2=2.1.1.5.0
3=4.1.6889.2.69.5.1.72.0
4=4.1.6889.2.69.5.1.79.0
5=4.1.6889.2.69.5.1.58.0
6=4.1.6889.2.69.5.1.78.0
7=4.1.6889.2.69.5.1.74.0
8=4.1.6889.2.69.5.6.4.0
9=1.3.6.1.2.1.1.3.0

Snmpvew.log:
This is where the semicolon delimited output is written after all of the devices have been interrogated by SNMPview. If you stop and close the program before this file is written, it does not get written. I use Excel to import this file into a row/column view.

NOTES:
MAC address field. I use and Excel spreadsheet to break this into columns. Then I use a 'lookup' to convert the smaller columns into values 0-9 and A-F. 30-39 = 0 to 9 and 41-46 = A to F. 3a = ':' Sample MAC 33313a42453a31343a43353a44363a4642

Uptime. If you have an OID for uptime, making the column head "Uptime" will convert the value to days, hours, minutes, seconds automatically.

OID’s in no particular order for 96x1 Phones:
1.3.6.1.4.1.6889.2.69.5.5.1.0 - Button Modules Attached.
1.3.6.1.4.1.6889.2.69.5.5.3.0 - Software Version
1.3.6.1.4.1.6889.2.69.5.5.5.0
1.3.6.1.4.1.6889.2.69.5.2.22.0 - SSON
1.3.6.1.4.1.6889.2.69.5.2.12.0 - VLAN
1.3.6.1.4.1.6889.2.69.5.2.11.0 - L2Q = (1 = Enabled)
1.3.6.1.4.1.6889.2.69.5.1.105.0 = SSON String Content
1.3.6.1.4.1.6889.2.69.5.1.104.0 = SNMP Address List
1.3.6.1.4.1.6889.2.69.5.1.85.0 = Interface2 speed 10, 100, 1000
1.3.6.1.4.1.6889.2.69.5.1.81.0 = Interface1 speed 10, 100, 1000
1.3.6.1.4.1.6889.2.69.5.1.79.0 = Serial Number
1.3.6.1.4.1.6889.2.69.5.1.78.0 = Comcode
1.3.6.1.4.1.6889.2.69.5.1.74.0 = Model
1.3.6.1.4.1.6889.2.69.5.1.72.0 = MAC
1.3.6.1.4.1.6889.2.69.5.1.54.0 = HTTP Server
1.3.6.1.4.1.6889.2.69.5.1.56.0 = ICMP
1.3.6.1.4.1.6889.2.69.5.1.46.0 = Router IP
1.3.6.1.4.1.6889.2.69.5.1.45.0 = Font File
1.3.6.1.4.1.6889.2.69.5.1.42.0 = DSP Version
1.3.6.1.4.1.6889.2.69.5.1.36.0 = Domain Label
1.3.6.1.4.1.6889.2.69.5.1.35.0 = DNS List
1.3.6.1.4.1.6889.2.69.5.1.27.0 = DHCP Renewal in x Seconds (Zero = Bad)
1.3.6.1.4.1.6889.2.69.5.1.26.0 = DHCP Renewal (Zero = Bad)
1.3.6.1.4.1.6889.2.69.5.1.21.0 = DHCP Timer
1.3.6.1.4.1.6889.2.69.5.1.22.0 = DHCP Timer
1.3.6.1.4.1.6889.2.69.5.1.19.0 = DHCP Lease expiration
1.3.6.1.4.1.6889.2.69.5.1.16.0 = Codec TX
1.3.6.1.4.1.6889.2.69.5.1.15.0 = Codec RX
1.3.6.1.4.1.6889.2.69.5.1.12.0 = Backup Location
1.3.6.1.4.1.6889.2.69.5.1.9.0 = Backlight Timer
1.3.6.1.4.1.6889.2.69.5.1.5.0 = App
1.3.6.1.4.1.6889.2.69.5.1.4.0 = APP in use

 

[IPOthermia]

Once you get the hang of the phone inventory you can also do gateways.

The following command needs to be set in each of the gateways for the SNMPview to get a response. This must match the community name in the devices.txt file.

snmp-server comm read-o mycommunity read-w mycommunity



Edit SNMPview with the following information. I setup SNMPview a 2nd time on my PC in a different subdirectory.
[Header]
0=location
1=system
2=name
3=MAC
4=SN
5=Degrees
6=Uptime
7=SiteName
8=Serial
9=Fan1
10=Fan2
11=Fan3
12=Fan4
13=Fan5
14=Fan6

#OID-Tabelle 4 - G450 Media Gateways
[OID4]
1=2.1.1.1.0
2=2.1.1.2.0
3=
4=
5=1.3.6.1.2.1.99.1.1.1.4.47
6=1.3.6.1.2.1.1.3.0
7=1.3.6.1.2.1.1.5.0
8=1.3.6.1.4.1.6889.2.9.1.1.4.0
9=1.3.6.1.2.1.99.1.1.1.4.41
10=1.3.6.1.2.1.99.1.1.1.4.42
11=1.3.6.1.2.1.99.1.1.1.4.43
12=1.3.6.1.2.1.99.1.1.1.4.44
13=1.3.6.1.2.1.99.1.1.1.4.45
14=1.3.6.1.2.1.99.1.1.1.4.46

#OID-Tabelle 5 - G430 Media Gateways
[OID5]
1=2.1.1.1.0
2=2.1.1.2.0
3=
4=
5=1.3.6.1.2.1.99.1.1.1.4.54
6=1.3.6.1.2.1.1.3.0
7=1.3.6.1.2.1.1.5.0
8=1.3.6.1.4.1.6889.2.9.1.1.4.0
9=1.3.6.1.2.1.99.1.1.1.4.47
10=1.3.6.1.2.1.99.1.1.1.4.48
11=1.3.6.1.2.1.99.1.1.1.4.49
12=
13=
14=

 

[kyle555]

That works great! thank you very much!

 

[jtc22]

Great tool. Thank you.

 

[BIS]

In Devices.txt, how would you add a complete subnet. 10.2.100.0/24 for example?

 

[IPOthermia]

I would use a spreadsheet (Excel) to make all 255 entries. There isn't shorthand that I know of. In the past I have had devices lists with 17,000 entries to try and account for all subnets in my network.

 

[BIS]

Ouch.

Ok thanks

 

[kyle555]

I guess the right answer is a pro SNMP modeling tool. I like that this one is simple enough to setup that I don't need to know much if I'm willing to roll up my sleeves!

 

[IPOthermia]

I have a high dollar SNMP (single pane of glass server) especially for the purpose of monitoring all of this stuff. But it doesn't understand AVAYA MIBs, it requires customization, needs special licensing, we don't have anyone who can do the administration, etc, etc, so this works for my purposes without having to involve thousands of dollars a year to a vendor.

 

[IPOthermia]

Adding the following sections to the snmpview.cfg will allow values to be either highlighted or lowlighted according to whether they are above or below desired thresholds.

#optionale Maximalwerte für OID-Tabelle 0 Syntax: Spaltenindex=Maximalwert
#optional maximal values for OID table 0 syntax: column index=maximal value
[Max5]
5=33
9=2750
10=2750
11=2750


#optionale Minimalwerte für OID-Tabelle 0 Syntax: Spaltenindex=Minimalwert
#optional minimal values for OID table 0 syntax: column index=minimal value
[Min5]
5=21
9=2500
10=2500
11=2500


#optionale Maximalwerte für OID-Tabelle 0 Syntax: Spaltenindex=Maximalwert
#optional maximal values for OID table 0 syntax: column index=maximal value
[Max4]
5=33
9=4600
10=4600
11=4600
12=4600
13=4600
14=4600


#optionale Minimalwerte für OID-Tabelle 0 Syntax: Spaltenindex=Minimalwert
#optional minimal values for OID table 0 syntax: column index=minimal value
[Min4]
5=21
9=4400
10=4400
11=4400
12=4400
13=4400
14=4400