cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
352
Views
0
Helpful
3
Replies

SQL query for CCM version

mikemck
Level 1
Level 1

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 3

Hin Lee
Cisco Employee
Cisco Employee

SELECT installationComponent

FROM ComponentVersion

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

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.

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'

Getting Started

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: