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

SQL query for CCM version

Hi. Is there an SQL query term that would pull the CCM version (3.x, 4.x)? Currently not privy to RO strings for an snmp query, nor a remote desktop function.

Thanks for any response.

3 REPLIES
Cisco Employee

Re: SQL query for CCM version

SELECT installationComponent

FROM ComponentVersion

WHERE (SoftwareComponent LIKE '%ccm.exe%')

New Member

Re: SQL query for CCM version

Thank you for the response. Initial query failed, but to follow on:

- which database would this be run against? I ran against Master, CCM0301, and a couple others.

- all queries fail. Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'ComponentVersion'..

Thanks again.

Silver

Re: SQL query for CCM version

Run the query against the CCM03xx database, where xx is the highest-numbered database on the CallManager. There are two databases on the CallManager publisher: CCM03xx and CDR. The former is the configuration database, and the latter contains the CDR and CMR.

When you first install CallManager, the first database will be called CCM0300. Each time you upgrade the CallManager, the last two digits of the database number increase by 1; so the first time you upgrade your current configuration database will be CCM0301. CallManager keeps the previous configuration database around, so you will generally have two configuration databases there.

Just choose the most recent configuration database and run the query, which in your case looks like it might be CCM0301, but if there is a CCM0302 then use that one!

Try a query such as:

select softwareComponent, version

from ComponentVersion

where softwareComponent = 'Cisco CallManager'

That should return the version in the version column for each process node (that is running CallManager, so the publisher and any subscribers).

You could also try something like this, if you are interested:

select CallManager.name, CallManager.description,

CallManager.ctiID, ComponentVersion.softwareComponent,

ComponentVersion.version

from ProcessNode, CallManager, ComponentVersion

where ProcessNode.pkid = CallManager.fkProcessNode

and ComponentVersion.fkProcessNode = ProcessNode.pkid

and ComponentVersion.softwareComponent = 'Cisco CallManager'

124
Views
0
Helpful
3
Replies