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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Historical report for all splits 1
- Thread starter MichalPol
- Start date
- Thread starter
- #2
Hi again,
I forget to add I need to know which agents were logging in/out into skill during last month to check witch agent account is active, so I need one report for all skills showing agent login/logout activity during last month.
Regards,
MichalPol
I forget to add I need to know which agents were logging in/out into skill during last month to check witch agent account is active, so I need one report for all skills showing agent login/logout activity during last month.
Regards,
MichalPol
Try this one:
Input - SPLIT (multi-value)
Query - LOGID, max(LOGIN), max(ROW_DATE)
Where statements - ACD=$acd and SPLIT=[Splits/Skills:] GROUP BY LOGID
This will display the last date and time any agent with any one of those skills logged in.
Input - SPLIT (multi-value)
Query - LOGID, max(LOGIN), max(ROW_DATE)
Where statements - ACD=$acd and SPLIT=[Splits/Skills:] GROUP BY LOGID
This will display the last date and time any agent with any one of those skills logged in.
-
1
- #4
Since you want this for all skills, you don't actually need to use SPLIT as an input.
I have an Agent Audit report:
SELECT UNIQUE haglog.LOGID, min(haglog.LOGIN), max(haglog.LOGOUT) FROM haglog Where ACD = [ACD:] GROUP BY haglog.LOGID
Sean Murphy
Call Centre Analyst
IAG New Zealand
I have an Agent Audit report:
SELECT UNIQUE haglog.LOGID, min(haglog.LOGIN), max(haglog.LOGOUT) FROM haglog Where ACD = [ACD:] GROUP BY haglog.LOGID
Sean Murphy
Call Centre Analyst
IAG New Zealand
- Thread starter
- #5
Depends on what components of CMS you have purchased/have access to. Assuming you have report designer access...
Commands > Report Wizard > Next >
Historical
aily > Next >
GridLayout > Next >
Agent > Agent login/Logout > No Pre-Selection > Next >
Add: Agent Name, Login Time, Logout Time > Next >
Fill Table by Row > Next >
Leave Input prompts > Next > Next > Next >
Edit Report in Report Designer > Finished >
From Report Designer, Edit > Queries > Query0 (EDIT)
Highlight LOGIN on right side panel, click edit and change to MIN(LOGIN)
Highlight LOGOUT on right side panel, click edit and change to MAX(LOGOUT)
Click WHERE
Delete the "and SPLIT = [Skill:] and ROW_DATE = [Dates:]" section from the Where panel at the bottom. Add "Group by LOGID" at the end of the where statement.
OK
Remove the Date and Skill fields from the report page.
Edit > Inputs. Remove both inputs.
Report > Save As
Report > Run (test the report).
You'll probably need to make some modifications to the date/time format in the resulting table.
Report > Design
Sean Murphy
Call Centre Analyst
IAG New Zealand
Commands > Report Wizard > Next >
Historical
aily > Next > GridLayout > Next >
Agent > Agent login/Logout > No Pre-Selection > Next >
Add: Agent Name, Login Time, Logout Time > Next >
Fill Table by Row > Next >
Leave Input prompts > Next > Next > Next >
Edit Report in Report Designer > Finished >
From Report Designer, Edit > Queries > Query0 (EDIT)
Highlight LOGIN on right side panel, click edit and change to MIN(LOGIN)
Highlight LOGOUT on right side panel, click edit and change to MAX(LOGOUT)
Click WHERE
Delete the "and SPLIT = [Skill:] and ROW_DATE = [Dates:]" section from the Where panel at the bottom. Add "Group by LOGID" at the end of the where statement.
OK
Remove the Date and Skill fields from the report page.
Edit > Inputs. Remove both inputs.
Report > Save As
Report > Run (test the report).
You'll probably need to make some modifications to the date/time format in the resulting table.
Report > Design
Sean Murphy
Call Centre Analyst
IAG New Zealand
- Thread starter
- #7
- Status
Similar threads
- Locked
- Question
- Locked
- Question