!!!Best Way to inventory 20,000 Ip Phones & Serial Numbers !!!

[jkoniecki]

hello ,

I have found 2 postings on tracking ip phones & Serial #'s from back in April. At that time their was no resolution to capturing the Phones Serial # . I was wondering if their was any news on what will help me Inventory 20,000 + Phones. With minimal errors and with out the need to audit them .

1 I know all the phones because of the DHCP scope but their is no easy way to get the serial # .

2 Manual Labor is out of the Question

3 Cisco Works support is not an issue .

Anyone care to shed some light on this one .

Thanks

Jk

[rocheist]

You can get the ip phone serial number from SQL server.

To do this;

create a ODBC connect to callmanager's sql server and than take the "device table" from CCM0300 and CCM0301 database.

good luck