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

SQL Query for CDR

Any SQL query guru who can help me with this?

The issue is that the process that was set up to gather information regarding CDR’s failed for a couple of weeks and now I am tasked with recovering that data into Equitrac, our time and billing server.  The data gets pulled into the SQL server on the CM1_PUB into the ART database.  From there it gets pulled out into a structure by a program called Facecollate and put into a useable structure for Equitrac. When I look at the authors of the SQL database that would have configured this system I see the following:

- usage EXEC Proc_WeeklyUtilizationOnDemandGen DATETIME INParameter,DATETIME INParameter,NVARCHAR OUTPamrameter

-- INT INParameter,INT OUTPUTParameter,INT OUTPUTParameter

-- drop proc Proc_WeeklyUtilizationOnDemandGen


Name            Proc_WeeklyUtilizationOnDemandGen

Environment     SQL Server 7.0

Functionality   Generate Weekly utilization report

Parameters      Input  : DATETIME - Value of From Date

                                Input  : INT - No Of Days

                Input  : NVARCHAR - Where Condition for the Query

Called Procs    Proc_WeeklyUtilizationBaseOnDemandGen

Assumptions     None

- usage Exec Proc_LoadCdrCmrData IntINParameter IntOutParameter

-- drop proc Proc_LoadCdrCmrData


Name            Proc_LoadCdrCmrData

Environment     SQL Server 7.0

Functionality   Loads CDR and CMR data from CCM database to ART database

Parameters      Input  : Int - Value of load id

                Output : Int - Return value

Called Procs    None

Assumptions     None