cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
571
Views
2
Helpful
4
Replies
Highlighted
Beginner

Agent State Detail Report Truncating

In CUIC we can only get up to 8000 lines of information when running our agent detail state report.  We are hoping to run the Agent State Detail Report with a SQL statement.  The SQL information we get from CUIC is:

{call sp_agent_state_detail('2015-08-01 05:00:00','2015-08-11 04:59:59','0','Support Center',null,null,null)}

Does anyone have the correct SQL query to run this report?

Everyone's tags (4)
1 ACCEPTED SOLUTION

Accepted Solutions
Beginner

Re: Agent State Detail Report Truncating

Actually, you can, you just have to set up the link server correctly. But since it is a procedure, you need to execute it as such (taking your sql statement and what looks like your link server).  Note the two single quotes around each parameter.

SELECT * FROM OPENQUERY([CISCO2], 'call sp_agent_state_detail(''2015-08-01 05:00:00'',''2015-08-11 04:59:59'',''0'',''Support Center'',null,null,null)')

4 REPLIES 4
Contributor

Re: Agent State Detail Report Truncating

CUIC will only consume the first 8000 rows from whatever SQL is run.  (3000 rows for a "realtime" report).  It looks like you are talking about UCCX.  The SQL you want is exactly what you posted minus the curly braces.

Regards,

Jack Parker

Beginner

Re: Agent State Detail Report Truncating

This is error we are getting

Contributor

Re: Agent State Detail Report Truncating

Looks like you are calling this from SQLServer via a linked server?  I don't think they allow that.  You might need to connect directly to the underlying Informix database to do this.  I would take this up with TAC and see what is supported.

Regards,

Jack Parker

Beginner

Re: Agent State Detail Report Truncating

Actually, you can, you just have to set up the link server correctly. But since it is a procedure, you need to execute it as such (taking your sql statement and what looks like your link server).  Note the two single quotes around each parameter.

SELECT * FROM OPENQUERY([CISCO2], 'call sp_agent_state_detail(''2015-08-01 05:00:00'',''2015-08-11 04:59:59'',''0'',''Support Center'',null,null,null)')

CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards