cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
277
Views
10
Helpful
2
Replies
Highlighted

UCCX Custom Report - StoredProcedure - unable to retrieve

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

image.png

 

Details used

UCCX : 12.0

user id used : uccxhruser

image.png

 

image.png

Press YEs and then above error.

 

Am i doing it wrong ?

Regards,

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Rising star

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

View solution in original post

2 REPLIES 2
Highlighted
Rising star

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

View solution in original post

Highlighted

superb mate. I got it. Many thanks.