12-20-2005 12:56 PM - edited 03-13-2019 11:37 AM
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.
12-20-2005 06:19 PM
SELECT installationComponent
FROM ComponentVersion
WHERE (SoftwareComponent LIKE '%ccm.exe%')
12-21-2005 10:42 AM
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.
12-21-2005 01:58 PM
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'
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: