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

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

Adding Service to a group of phones

Hi all,

I'm making a java app that connect directly to SQLServer DB on Callmanager 4.1(3). I want to INSERT directly some service to a lot of phones.

I identify the tables: "TelecasterService" and "TelecasterSubscribedService" on "CCM0300" DB.

So, i need the PKID of the device (i get it from "Device" table).. but i don't know what is "msrepl_tran_version" field on the mencioned tables...

?Can i just use NEWID() to this field?

?What is this field?

Thanks a lot in advance!

(And sorry for my english :D)


Re: Adding Service to a group of phones


please DO NOT DO THAT this way. Inserting rows directly to the SQL server WILL (I repeat: it WILL) screw up the CallManager.

Use BAT instead.

Or, use AXL if you like some programming.


New Member

Re: Adding Service to a group of phones


Ok.. i'll try using AXL...

Why Callmanager is so delicate?



Re: Adding Service to a group of phones

I guess by looking at how SQL Server DB replication works, you'd be able to figure out what to put in there.

However, you should consider CCM to be just like any other 3 tier system.. with the database being the third tier and a business layer in the middle. If you write directly to the database, you bypass the business layer, which means that you'll bypass certain logic that ensures a consistent database.

Starting with CCM 5.0, there's an axl command to write into the CCM database, and the schema has been extended quite a bit with a lot of consistency information.. you'll note that depending on which table, there's quite a bit of processing to be done to ensure consistency, which makes AXL a lot more attractive as all those checks are done automatically for you that way.

New Member

Re: Adding Service to a group of phones

Thanks for reply...

You're totally right, bypassing layers maybe i'll lost the consistent of CCM database.

I'll try with AXL... i don't know how i must use it.. so..i'll be posting :P



Re: Adding Service to a group of phones

Just to make you scared, once I needed to create a lot of pickup groups for a CCM cluster with 2000 users. I figured out what the pickup groups look like in the CCM database and sort of added the new ones in a couple of minutes then walked away to have a beer.

Next day I found out pickup groups do not work at all and I spent a week correcting what I broke in a couple of minutes.

So don't take the chance, don't touch the CCM DB.

New Member

Re: Adding Service to a group of phones

ok, thanks for the advice.

just one cuestion: you can drink a beer in your job? Tell me how can i work there! :P

Thanks for all replys!..