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

[Travis Llewellyn]

In reply to myself incase anyone else need to know here is the SQL to
get the information. I am still tweaking it but this gets what I needed.

This is from Access fo you can drop the dbo. Off of it.

SELECT dbo_Device.name, dbo_Device.description, dbo_NumPlan.dNOrPattern
FROM (dbo_Device INNER JOIN dbo_DeviceNumPlanMap ON dbo_Device.pkid =
dbo_DeviceNumPlanMap.fkDevice) INNER JOIN dbo_NumPlan ON
dbo_DeviceNumPlanMap.fkNumPlan = dbo_NumPlan.pkid;


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: Travis Llewellyn
Posted At: Friday, January 07, 2005 10:47 AM
Posted To: Cisco VOIP List
Conversation: SQL for Device Name Description and DN
Subject: [cisco-voip] SQL for Device Name Description and DN


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.