12-07-2006 07:35 AM - edited 03-14-2019 07:07 PM
Hi,
Is there a guide or information on CCO for Callmanager Database Definations.
Like there is one for CDR (http://www.cisco.com/en/US/partner/products/sw/voicesw/ps556/products_programming_usage_guide09186a00806556fb.html
BR
Solved! Go to Solution.
12-07-2006 09:35 AM
This SQL query should work for you. Just run it from MS Query Analyzer. Remember to change the Database name to your current CCM database name. This will return the Device Name and XML parameter for PC Voice VLAN Access.
Enabled PC Voice VLAN query
USE CCM0300
SELECT Name, XML
FROM dbo.Device
WHERE XML LIKE '%
Disabled PC Voice VLAN query
USE CCM0300
SELECT Name, XML
FROM dbo.Device
WHERE XML LIKE '%
Please rate any helpful posts
Thanks
Fred
12-07-2006 08:10 AM
No.
Thats not public information, only Engineering internal docs.
12-07-2006 08:14 AM
Hi Thanks for the reply.
The reason why I came up with this is because, I want to run a SQL query to find no.of phones with "PC Voice VLAN Access" disabled.
12-07-2006 09:35 AM
This SQL query should work for you. Just run it from MS Query Analyzer. Remember to change the Database name to your current CCM database name. This will return the Device Name and XML parameter for PC Voice VLAN Access.
Enabled PC Voice VLAN query
USE CCM0300
SELECT Name, XML
FROM dbo.Device
WHERE XML LIKE '%
Disabled PC Voice VLAN query
USE CCM0300
SELECT Name, XML
FROM dbo.Device
WHERE XML LIKE '%
Please rate any helpful posts
Thanks
Fred
12-07-2006 09:56 AM
Thanks Fred:)
Thats what I was looking for.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: