Avayacoolstuff
Technical User
How can we pull list of agents who are inactive for last 6 months
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Question on CMS reporting
- Thread starter Avayacoolstuff
- Start date
- Status
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
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
- Status