UCCX Custom Report - StoredProcedure - unable to retrieve

[Shalid Kurunnan Chalil]

After reading many threads and Cisco documents. i succesfully connected to the UCCX databases and able to run the predefiined stored procedures and select queries from the table.

but how do i see the query behind the Cisco UCCX stored procedure for example sp_ccdr. i tried AGS Tools >> Stored Procedure Debugger

but when i run, i get error as

Details used

UCCX : 12.0

user id used : uccxhruser

Press YEs and then above error.

Am i doing it wrong ?

Regards,

[Graham Old · Accepted solution]

From the CLI run this command to list the stored procedures.

run uccx sql db_cra select sysprocedures.procname,sysprocedures.procid from sysprocedures

To list the stored procedure you need the procid from above

run uccx sql db_cra select data from sysprocbody where procid = 843 and datakey = 'T'

I have only listed the SP from the CLI using putty and captured the output

Graham

[Shalid Kurunnan Chalil]

superb mate. I got it. Many thanks.