AWESOME! Thank you! Em Fri Nov 28 2014 at 14:46:40, NateCCIE <[email protected]> escreveu:
> 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:[email protected]] *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 >
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
