CM subscriber dump from Publisher

[rossporubski]

We are still back on the unsupported vers 4.3 Call Manager

I need to do a db dump from sql analyzer of all current phones in use. The business would like to distinguish what DID's from which blocks are mainly being used.

Basically an overall subscriber dump.

Thank you

[testeven]

Hi,

You can also get a Route Plan report and it will give you all the assigned and unassigned DNs along with other numbers such as meet me, call pickup, MWIs, CTI RPs,  etc

Please refer to:

http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/admin/4_2_1/ccmcfg/b03rtrep.html

Regards,

Tere.

If you find this post helpful, please rate!

[rossporubski]

Thank you testeven,

Unfortunately this isn't what we're looking for.

Essentially a dump directly from the publisher db will provide a .csv report. Which can be manipulated to contain, only the specific data the requestor would like.

In this case, it's an internal audit by billing. They want to see who, (name) is assigned to what, (extension/full DN)