Solved: Re: Callmanager Database Definations

cisco_ipt · ‎12-07-2006

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

fred.s.mollenkopf · ‎12-07-2006

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

View solution in original post

gogasca · ‎12-07-2006

No.

Thats not public information, only Engineering internal docs.

cisco_ipt · ‎12-07-2006

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.

fred.s.mollenkopf · ‎12-07-2006

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

cisco_ipt · ‎12-07-2006

Thanks Fred:)

Thats what I was looking for.