TotalLoginTime = CASE WHEN ALOD.ALODEvent = 2 THEN ALOD.TotalLoginTime ELSE DATEDIFF(ss,LoginDateTime, (CASE WHEN DATEDIFF(ss, :end_date, (Select NowTime From Controller_Time)) > 0 THEN :end_date ELSE (Select NowTime From Controller_Time) END)) END,
Both ALOD and ANRDU in that query get their LoginDateTime values from Agent_Event_Detail. One is looking for Event=2 (not ready), the other looks for Event=3 (log out). If the query isn't finding matching LoginDateTime values for those two Event types, then you may have an underlying database issue.
There's also likely an issue with the WHERE statement on AgentNotReadyDetails... I've seen that method of interval calculation in Cisco AED reports before and recall there being issues with it. If I remember right, it sometimes puts Not Ready events into the wrong interval (like 5pm instead of 4:30pm for example). More details here:
It sounds like the query is giving you a negative time value of about -85 days. I see a few ways this could happen:
The Agent logout events in AED (Event=2) are somehow getting DateTime values that are earlier than the login times
NowTime in table Controller_Time is earlier than the agent login times. (this seems more likely)
So, I suggest looking at the Agent_Event_Detail table on the AW/HDS to ensure that the DateTime values on Event=2 lines are later than the login times... and also check the NowTime in table Controller_Time to ensure it is correct.
Here's the NowTime query:
SELECT [NowTime] ,[TimeZone] ,[TimeZoneName] FROM [Controller_Time]
And here's the appropriate query for AED (should return 0 results if DateTime/LoginDateTimes are correct):
SELECT [DateTime] ,[SkillTargetID] ,[MRDomainID] ,[TimeZone] ,[LoginDateTime] ,[Event] ,[RecoveryKey] ,[Duration] ,[ReasonCode] ,[DbDateTime] FROM [Agent_Event_Detail] WHERE Event=2 AND DateTime<LoginDateTime
The short answer is that you don't.... That isn't entirely true while at
the same time it kind of is, but for the most part you don't configure
the softkeys. You enable or disable them via TCL. Here is the long
answer. Be sure to read the whole thing or e...
Topology: IP Phone > Switches > Microsoft NPS setup to forward 802.1x
proxy to > ISE 2.1 patch 3 Authentication: EAP-TLS using Cisco MIC SANs
Phone Models 802.1X support? 802.1x flavor Addtl Comment EAP-MD5 EAP-TLS
Cisco 3905 Y Y N Cisco 6911 Y Y N Cisco ...
This document describe how DST changes and how time changes are
implemented in DST. Daylight Saving Time (DST) is the practice of
setting the clocks forward 1 hour from standard time during the summer
months, and back again in the fall, in order to make b...