Hi, The 'show tech systables' would give you the list of tables in the sysmater - this option will not be available on 2.0.4 CER. You can run sql queries on the database for the tables other than the cdr_deltatab and sys entries. admin: admin:show version active Active Master Version: 8.5.1.10000-7 Active Version Installed Software Options: No Installed Software Options Found. admin: admin:show tech systables -------------------- show tech systables -------------------- System Tables tabname ============================== GL_COLLATE GL_CTYPE VERSION applicationuser applicationusertousergroupmap cdr_deltab_000001 cdr_deltab_000002 cdr_deltab_000003 cdr_deltab_000004 cdr_deltab_000005 cdr_deltab_000006 cdr_deltab_000007 cdr_deltab_000008 cdr_deltab_000009 cdr_deltab_000010 cdr_deltab_000011 cdr_deltab_000012 cdr_deltab_000013 cdr_deltab_000014 cdr_deltab_000015 cdr_deltab_000016 cdr_deltab_000017 cdr_deltab_000018 cdr_deltab_000019 cdr_deltab_000020 cdr_deltab_000021 cdr_deltab_000022 cdr_deltab_000023 cdr_deltab_000024 cdr_deltab_000025 cdr_deltab_000026 cdr_deltab_000027 cdr_deltab_000028 cdr_deltab_000029 cdr_deltab_000030 cdr_deltab_000031 cdr_deltab_000032 cdr_deltab_000033 cdr_deltab_000034 ceraniextmapping cercallhistory cerccmclusterattributes cerccmlist cerdiscoveryengine ceremergencynumber cererl cererlaudit ceripsubnets cerlicenses cermanualentryphones cerremote cersecuritycontact cerseedswitches cerserver cerservergroup cersnmpcmtystring cerswitchport cerswitchportlocation cerswitchporttableview cersystemparameters cerunlocatedphone cervhmphones dblschemaorder functionrole functionroletoresourcemap functionroletousergroupmap intradoelinstatus offpremiseslocation offpremiseslocationassociation sysaggregates sysams sysattrtypes sysblobs syscasts syschecks syscolattribs syscolauth syscoldepend syscolumns sysconstraints sysdefaults sysdepend sysdirectives sysdistrib sysdomains syserrors sysfragauth sysfragments sysindexes sysindices sysinherits syslangauth syslogmap sysobjstate sysopclasses sysopclstr sysprocauth sysprocbody sysproccolumns sysprocedures sysprocplan sysreferences sysroleauth sysroutinelangs sysseclabelauth sysseclabelcomponentelements sysseclabelcomponents sysseclabelnames sysseclabels syssecpolicies syssecpolicycomponents syssecpolicyexemptions syssequences syssurrogateauth syssynonyms syssyntable systabamdata systabauth systables systraceclasses systracemsgs systrigbody systriggers sysusers sysviews sysviolations sysxadatasources sysxasourcetypes sysxtddesc sysxtdtypeauth sysxtdtypes typeapplication typeresource usergroup admin: - Sriram Please rate helpful posts ! ... View more

Glad that you find it helpful. I had a discussion with the developers a couple of weeks back regarding this scenario - the current plan is to get enhancment CSCsx31179  in 9.0 version of CallManager. If I get any confirmation that the enhancement will be resolved in 9.0, I will reply to this thread. - Sriram Please rate helpful posts ! ... View more

Hi, Is the problem happening when you see the 'ccm' component in the 'show tech notify' output ? CSCso93220 causes the ccm component to be deleted from the notification list of database layer monitor - so the problem happens all of a sudden, and 'show tech notify' output at that point would be missing the 'ccm' component. - Sriram Please rate helpful posts ! ... View more

This sounds like CSCso93220. please use the cisco bugtoolkit to pull info on this defect. 6.0.1 is affected by this bug. Basically, an affected server's 'show tech notify' output will be missing the 'ccm' component Sent from Cisco Technical Support iPhone App ... View more

On each sub's os admin page, is settings > ip > publisher set to the correct host name of the pub ? If not set it up, reboot one sub at a time and then check dbrep status. You might have to stop replication on all servers, and then a reset all from the pub after that. Sent from Cisco Technical Support iPhone App ... View more

Hi Antonio, You can adjust the CallManager service parameter (System > Service Parameter > server > Cisco CallMager > SIP Session Expires Timer > increase from default 1800 seconds to say, 3600 seconds). This will make CallManager try to negotiate an initial sesssion timer of 1 hour - whether the SIP far end accepts that request or not is another question. You can run 'debug ccsip mess' on the SIP Gateway, and check the messages - if you have trouble understanding the logs, you can load the logs here. Let us know the calling party, called party, time stamp of call, IP address of CallManager, voice gw and sip far end. - Sriram Please rate helpful posts ! ... View more

The 'passwordreverse' column in the 'enduser' and 'applicationtable' tables is the Digest Credentials value, not the password. The password (and pin for endusers) are stored in the 'credential' table (1) Identified the application user whose password I want to try to update admin:run sql select * from applicationuser where name='sriram' pkid                                 name   isstandard passwordreverse acloobsubscription acloodrefer aclpresencesubscription aclunsolicitednotification fkmatrix_presence                    aclallowreplace ==================================== ====== ========== =============== ================== =========== ======================= ========================== ==================================== =============== 9045b277-b27d-bcde-9622-6811438d3457 sriram f          NULL            f                  f           f                       f                          ad243d17-98b4-4118-8feb-5ff2e1b781ac f admin: admin: (2) Get information from the credential table, correlated with the application user : admin:run sql select * from credential where fkapplicationuser='9045b277-b27d-bcde-9622-6811438d3457' pkid                                 fkenduser fkapplicationuser                    tkcredential cantchange credmustchange fkcredentialpolicy                   doesntexpire timechanged timeadminlockout credentials                                                      imsinfo ==================================== ========= ==================================== ============ ========== ============== ==================================== ============ =========== ================ ================================================================ ======= 137b0b7b-8974-45a9-a73e-c3f8d96a555c NULL      9045b277-b27d-bcde-9622-6811438d3457 3            f          f              9454babf-48d0-4e16-9b80-2d0da4b38750 f            1303245071  NULL             2d28ad897374d31bc2fe6959a336b75aa380cfa2e7cc5bf3436cbcc02955b029 1 admin: Isolating the important value from the previous output, admin:run sql select pkid, fkapplicationuser, fkenduser, tkcredential, credentials from credential where fkapplicationuser='9045b277-b27d-bcde-9622-6811438d3457' pkid                                 fkapplicationuser                    fkenduser tkcredential credentials ==================================== ==================================== ========= ============ ================================================================ 137b0b7b-8974-45a9-a73e-c3f8d96a555c 9045b277-b27d-bcde-9622-6811438d3457 NULL      3            2d28ad897374d31bc2fe6959a336b75aa380cfa2e7cc5bf3436cbcc02955b029 admin: tkcredential - 3 = pw, 4 = pin (3) Found that sql updates are not allowed on the credential table via CLI : admin:run sql update credential set credentials='69c4f936f9cdf45f6bbca2570c31215629bb5d6fb97493478b8ff3db6fffbc5' where fkapplicationuser='9045b277-b27d-bcde-9622-6811438d3457' No UPDATE permission for credential. admin: ----- So, you would need to reset the password through the Admin GUI. Hope this helps. - Sriram Please rate helpful posts ! ... View more

Hi Antonio, - Can you please let us know if you are referring to the SIP Session Expires timer ?SIP Session Expires timer controls the duration of time that a SIP call can be active. - Do you have a CallManager in the call flow ? What's the session expires timer set in the service parameters, if so ? - Is the sip reINVITE happening ? If not, have you looked as to why it fails ? - Sriram Please rate helpful posts ! ... View more