[cisco-voip] CUCM5.1: Phone MacAddr + Directory Number/PT (Bulk not working)

[NateCCIE]

run sql SELECT device.name as devicename, dnorpattern, routepartition.name as partition, numplanindex from devicenumplanmap join numplan on fknumplan = numplan.pkid join routepartition on routepartition.pkid = numplan.fkroutepartition join device on device.pkid = fkdevice

 

I added line appearance number in case you have more than one line on a phone.

 

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of José Paulo de Oliveira Petry
Sent: Friday, November 28, 2014 9:22 AM
To: Cisco VoIPoE List
Subject: [cisco-voip] CUCM5.1: Phone MacAddr + Directory Number/PT (Bulk not working)

 

Hello,

 

Im trying to bulk export phones in my CUCM5, but the generated report is not showing all data (some phones are not coming with the directoy number, for example. And the phone has a directory number!)

 

Can I run a SQL Select commad to get a least Phone Mac Address + Directory Number + Partition??? How do I do that?

 

Cisco Unified CallManager 5.1.3.3000-5

 

Thanks in advance

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20141128/4c1e2f93/attachment.html>