Contact Centers, CRM Customer Engagement

 View Only
  • 1.  Agents Login/Logout CMS Supervisor Report

    Posted 03-25-2010 02:21 PM
    I want to create a custom CMS Agent Group Report in CMS Supervisor that would display the following fields:

    Agent Name
    Login ID
    Login Time
    Logout Time
    Logout Date
    Staffed Time

    I do know how to create an Agents Login/Logout Skill Report (It uses a single value, not ranges nor lists).

    Our agents use a range of assigned skills.

    I would appreciate assistance,


  • 2.  Agents Login/Logout CMS Supervisor Report

    Posted 03-29-2010 05:35 AM
    I use the same thing, I don't know why this is not a standard report.

    take your login/logout split/skill report and do report/design
    go in edit-->inputs
    add Agent, remove split/skill
    go in edit-->queries and select and modify "data".
    go in the "where" tab and paste this : "ROW_DATE = [Dates:] and haglog.LOGID = [Agent:] and ACD=$acd ORDER BY haglog.LOGID,haglog.LOGIN".
    save and you are good to go.


  • 3.  Agents Login/Logout CMS Supervisor Report

    Posted 03-29-2010 05:37 AM
    forgot to mention, if you want to be able to run this with more than 1 agent, you can check the multiple-value checkbox in the edit-->inputs on the agent's row.


  • 4.  Agents Login/Logout CMS Supervisor Report

    Posted 04-09-2010 11:46 AM
    jooquase,

    Thank you for the assistance,

    I made a copy of the Login/Logout Split/Skill report.
    Added Agent, Removed Split/Skill
    Checked the Multi-Value checkbox

    I ran into a trouble when i pasted in the "Where" tab.

    The Query Asistant Window Pop Up Displayed
    This query contains syntax error. Save it with Errors?

    Do i need additonal steps?


  • 5.  Agents Login/Logout CMS Supervisor Report

    Posted 04-16-2010 11:32 AM
    If your using multi-value for agents, the where tab should show [Agents:] not [Agent:].


  • 6.  RE: Agents Login/Logout CMS Supervisor Report

    Posted 10-16-2014 10:56 AM

    I've been looking for a way to do this report, too!  Thanks for the help - it works perfectly!