Cisco CCM oldest CDR record using sql query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Cisco CCM oldest CDR record using sql query

Author

Topic

colorpurple100
Starting Member

2 Posts

Posted - 2007-11-09 : 00:53:54

Hello all,

I need assistance in finding the oldest CDR record in Cisco Callmanager DB using sql query. The CCM version is 3.3(5).
Any assistance is needed. Thanks.

nathans
Aged Yak Warrior

938 Posts

Posted - 2007-11-09 : 01:21:11

Hi there,
Its difficult to help without knowing the schema of the database... but a quick google search turned up this page:

http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a00801d71c5.shtml

From that, I could guess that this might be close to what you need:

select top 1 *
from CallDetailRecord
order by dateTimeConnect asc

Nathan Skerl

colorpurple100
Starting Member

2 Posts

Posted - 2007-11-09 : 02:21:13

Thanks for answering. I reviewed this infomation earlier. It does
direct you in the right direction, but it does not give the specific
query to retrieve th oldest CDR call detail record with the sql query. The database is OBDC I think. Even though I know more about networks than servers, I still have been requested to pulled this
information. Thanks.

nathans
Aged Yak Warrior

938 Posts

Posted - 2007-11-09 : 10:17:03

By schema I mean the physical structure of the table involved including column names and datatypes. This will make it much eaiser for us to help.

Did the query i posted return the desired resultset?

Nathan Skerl

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources