Question on CMS reporting

[Avayacoolstuff]

How can we pull list of agents who are inactive for last 6 months

 

[Stinney]

Historical / Agent / Attendance Monthly will show you an agent's attendance. However, the canned report is just one agent at a time. You would need to copy this report and customize it to do what you need. You would have to allow multiple agent inputs, add the LOGID to the query and table. Depending on the number of agents you have in your environment, the report might be a little strenuous on your CMS, each of those agents is considered a data element and a query for that many data elements might cause CPU utilization issues.

You'd be better off, setting up an ODBC connection to the CMS and run a queary against the magent table where the historical monthly data is stored for agents. If you have anyone at the company that has experience creating sql queries they could help you create a query to the cms database table magent where this information is stored. They would need to select the LOGID, ROW_DATE and TI_STAFFTIME where is no TI_STAFFTIME for the LOGID.

For example: Select LOGID, ROW_DATE, TI_STAFFTIME from magent where TI_STAFFTIME = 0 and ROW DATE between (*date range*) order by LOGID, ROW_DATE;

- Stinney

“The man who asks a question is a fool for a minute, the man who does not ask is a fool for life.” - Confucius