Calculate logged in time by agent

[christina.singer1]

Can anyone give me a hint about the SQL query used to calculate total logged in time (by agent) for a specific time period?

[Deepak Rawat]

Find the SQL query below Christina to find the logged in/out hours. Simply change the time and agent name as per your requirement. If you want to run the query for more agents simply separate them by comma such as 'Deepak Rawat, Test Agent, Test Agent2 etc'

run uccx sp db_cra sp_agent_log_activity('2016-02-09 18:30:00','2016-03-10 18:29:59','0','NULL','DEEPAK RAWAT',null,null)

For your reference, I also have attached the complete SP for this table in case that helps as well

Regards

Deepak

[christina.singer1]

Hi Deepak,

Thanks for your assistance.  Unfortunately I cannot run the SQL query you sent because some of the syntax is not compatible with SQL Server 2012. I will need to take a look at the appropriate adjustments.

[Chakshu Piplani]

That syntax is for you to run it on CCX, command line interface, which you can access by doing an SSH session to CCX server.