[cisco-voip] SQL Query Question

[Wes Sisk]

yep.

for educational purposes you can dump the contents of dcdirectory to  
a plain text file with the command:
dumpall out.txt
from the command prompt on the callmanager server

this is also the easiest way i've found to answer the question 'what  
users are associated to this device'?

/Wes

On Nov 3, 2006, at 12:16 PM, STEVEN CASPER wrote:

Just so I'm clear on this. The directory info such as Manager User ID is
stored in LDAP, the phone attributes like Device Pool is stored in SQL?

Thanks!



>>> "Wes Sisk" <wsisk at cisco.com> 11/03/06 11:56 AM >>>
information is not stored in SQL, only in LDAP directory, well, unless

you are on 5.0, then it's all in the information SQL database.

STEVEN CASPER wrote:
> Does not look like I can get this in a BAT report.
>
> Anyway of running a SQL query and pulling the following info?
>
> Controlled Device, First Name, Last Name, Manager User ID, Telephone
> Number, Device Pool, User ID
>
> Thanks!
>
> Steve Casper
> Voice Technologies
> M&T Bank
> (410) 347-6026
>
>
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>


_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

This message (including any attachments) contains confidential
and/or proprietary information intended only for the addressee.
Any unauthorized disclosure, copying, distribution or reliance on
the contents of this information is strictly prohibited and may
constitute a violation of law.  If you are not the intended
recipient, please notify the sender immediately by responding to
this e-mail, and delete the message from your system.  If you
have any questions about this e-mail please notify the sender
immediately.