Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Callmanager Database Definations

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Callmanager Database Definations

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 '%0%'

Disabled PC Voice VLAN query

USE CCM0300

SELECT Name, XML

FROM dbo.Device

WHERE XML LIKE '%1%'

Please rate any helpful posts

Thanks

Fred

4 REPLIES
Green

Re: Callmanager Database Definations

No.

Thats not public information, only Engineering internal docs.

New Member

Re: Callmanager Database Definations

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.

Re: Callmanager Database Definations

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 '%0%'

Disabled PC Voice VLAN query

USE CCM0300

SELECT Name, XML

FROM dbo.Device

WHERE XML LIKE '%1%'

Please rate any helpful posts

Thanks

Fred

New Member

Re: Callmanager Database Definations

Thanks Fred:)

Thats what I was looking for.

243
Views
0
Helpful
4
Replies