Agent State Detail Report Truncating

[Leah Sittig]

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?

[jacparke]

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

[Leah Sittig]

This is error we are getting

[jacparke]

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

[beenhazed · Accepted solution]

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)')