AnsweredAssumed Answered

SQL Query to get all active agents for a single client

Question asked by Nick_McCloud_1548 on Jul 29, 2014
Latest reply on Jul 31, 2014 by Nick_McCloud_1548

 

Has anyone ever been able to retrieve all of the active agents that a particular client has active? We are currently running v9. I essentially am trying to get out of the SQL database exactly what the System View shows in the "Agents" and indicates if the agent is active. I only need it for 1 client. Any help is greatly appreciated.

 

Nick

Outcomes