[cisco-voip] SQL for Device Name Description and DN

[Travis Llewellyn]

That worked perfect.
Thanks

Travis Llewellyn
Network Administrator
Communication Federal Credit Union
travisll at comfedcu.org

----------------------------------------
1 Timothy 4:12 In speech, conduct, love, faith and purity, show yourself
an example of those who believe.



-----Original Message-----
From: Kevin Thorngren [mailto:kevint at cisco.com]
Sent: Friday, January 07, 2005 11:36 AM
To: Travis Llewellyn
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] SQL for Device Name Description and DN

Hi Travis,

The built-in Route Plan Report may provide the information you are
looking for.  Just follow these steps:

- Go to CCMAdmin >  Route Plan > Route Plan Report
- Click on the "View in file" link toward the right side of the web page
- Save the CSV file

This file will contain all patterns, including phones, that are
configured in the CallManager.

HTH,
Kevin
On Jan 7, 2005, at 11:46 AM, Travis Llewellyn wrote:

>
> I am trying to come up with the SQL to get all phones Desc, Names, and
> DN's to export.
> Does anyone have a decent diagram of all the Callmanager tables?
>
> Travis Llewellyn
> Network Administrator
> Communication Federal Credit Union
> travisll at comfedcu.org
>
> ----------------------------------------
> 1 Timothy 4:12 In speech, conduct, love, faith and purity, show
> yourself
> an example of those who believe.
>
>
>
>
> -----------------------------------------------------------------
> This e-mail and the files transmitted with it are the property
> of Communication Federal Credit Union and/or its affiliates,
> are confidential, and are intended solely for use of the
> individual or entity to whom this e-mail is addressed. If you
> are not one of the named recipient(s) or otherwise have reason
> to believe that you have received this message in error, please
> notify the sender at 405-879-5600 and delete this message
> immediately from your computer. Any other use, retention,
> dissemination, forwarding, printing, or copying of this e-mail
> is strictly prohibited.
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>

-----------------------------------------------------------------
This e-mail and the files transmitted with it are the property
of Communication Federal Credit Union and/or its affiliates,
are confidential, and are intended solely for use of the
individual or entity to whom this e-mail is addressed. If you
are not one of the named recipient(s) or otherwise have reason
to believe that you have received this message in error, please
notify the sender at 405-879-5600 and delete this message
immediately from your computer. Any other use, retention,
dissemination, forwarding, printing, or copying of this e-mail
is strictly prohibited.