1E29F6DD100001301D9CAF570A010141 4 GROUP_READ_EXEC_OTHER_NONE Default Agent Skill Group Logout By Media 1E1D208E100001301B4DC7010A010141 23 GROUP_READ_EXEC_OTHER_NONE Default Agent Skill Group Logout by Media 80 CCCCCCCC00000000AAAAAAAA00000003 SQUERY SELECT Agent.EnterpriseName, AgentName = Person.LastName + ', ' + Person.FirstName, Agent_Skill_Group_Logout.LoginDuration, Agent_Skill_Group_Logout.ReasonCode, LogonDateTime = DateAdd(s,-1 * Agent_Skill_Group_Logout.LoginDuration,Agent_Skill_Group_Logout.LogoutDateTime), Skill = Skill_Group.EnterpriseName + ' (' + Media_Routing_Domain.EnterpriseName +')', Agent_Skill_Group_Logout.LogoutDateTime , Date = CONVERT(char(10), (Agent_Skill_Group_Logout.LogoutDateTime), 101) , Time = (RIGHT('0'+ CONVERT(Varchar(2),DATEPART(hh,(Agent_Skill_Group_Logout.LogoutDateTime))),2) + ':' + RIGHT('0'+ CONVERT(Varchar(2),DATEPART(mi,(Agent_Skill_Group_Logout.LogoutDateTime))),2)), Year = DATEPART(yyyy, (Agent_Skill_Group_Logout.LogoutDateTime)), Month = DATEPART(mm, (Agent_Skill_Group_Logout.LogoutDateTime)), Week = DATEPART(ww, (Agent_Skill_Group_Logout.LogoutDateTime)), DOY = DATEPART(dy, (Agent_Skill_Group_Logout.LogoutDateTime)), ReasonText = Reason_Code.ReasonText, ReasonDesc = Reason_Code.Description FROM Agent, Person, Skill_Group, Agent_Skill_Group_Logout, Media_Routing_Domain, Reason_Code WHERE Agent.PersonID = Person.PersonID and Agent.SkillTargetID = Agent_Skill_Group_Logout.SkillTargetID and Agent_Skill_Group_Logout.SkillGroupSkillTargetID = Skill_Group.SkillTargetID and Skill_Group.MRDomainID=Media_Routing_Domain.MRDomainID and Agent_Skill_Group_Logout.ReasonCode = Reason_Code.ReasonCode true 900 false 1E1D2095100001303F1A83B10A010141 0 Agent_Skill_Group_Logout.ReasonCode 3 DECIMAL ReasonCode ReasonCode false true true true false false NONE 1E1D209510000130284806C50A010141 2 Agent_Skill_Group_Logout.LoginDuration 2 DECIMAL LoginDuration LoginDuration false true true true false false Minutes and seconds (hh:mm:ss) SUM 1E1D209510000130567C0C390A010141 0 Reason_Code.Description 14 STRING ReasonDesc ReasonDesc false true true true false false NONE 1E2F4D53100001302EEE1B470A010141 0 DateAdd(s,-1+*++++Agent_Skill_Group_Logout.LoginDuration,Agent_Skill_Group_Logout.LogoutDateTime) 4 DATETIME LogonDateTime LogonDateTime false true true true false false DATE_SHORT_TIME_SHORT NONE 1E2F4D631000013056E458F50A010141 0 DATEPART(yyyy,+(Agent_Skill_Group_Logout.LogoutDateTime)) 9 DECIMAL Year Year false true true true false false NONE 1E2F4D45100001307B051D240A010141 0 Agent.SkillTargetID 1 STRING AgentName AgentName false true true true CCCCCCCC00000000DDDDDDDD00000001 7 GROUP_READ_EXEC_OTHER_NONE Default SELECT Agent.SkillTargetID AS ID, Agent.EnterpriseName AS VALUE FROM Agent (nolock) ORDER BY Agent.EnterpriseName ASC SELECT Distinct a.SkillTargetID as ID, a.EnterpriseName AS VALUE FROM Agent a (nolock), Agent_Skill_Group_Interval hh (nolock) WHERE a.SkillTargetID = hh.SkillTargetID ORDER BY EnterpriseName Agents Agents CCCCCCCC00000000AAAAAAAA00000002 STOCK false false NONE 1E2F4D6310000130020C1EBF0A010141 0 (RIGHT('0'++CONVERT(Varchar(2),DATEPART(hh,(Agent_Skill_Group_Logout.LogoutDateTime))),2)+++':'++++++RIGHT('0'++CONVERT(Varchar(2),DATEPART(mi,(Agent_Skill_Group_Logout.LogoutDateTime))),2)) 8 STRING Time Time false true true true false false NONE 1E2F4D45100001301365AC1D0A010141 0 CONVERT(char(10),+(Agent_Skill_Group_Logout.LogoutDateTime),+101) 7 STRING Date Date false true true true false false NONE 1E2F4D451000013001A92DC30A010141 0 DATEPART(dy,+(Agent_Skill_Group_Logout.LogoutDateTime)) 12 DECIMAL DOY DOY false true true true false false NONE 1E1D20951000013061C495360A010141 0 Agent_Skill_Group_Logout.LogoutDateTime 6 DATETIME LogoutDateTime LogoutDateTime false true true true false false DATE_SHORT_TIME_SHORT NONE 1E2F4D5D100001304AF0B6520A010141 0 DATEPART(mm,+(Agent_Skill_Group_Logout.LogoutDateTime)) 10 DECIMAL Month Month false true true true false false NONE 1E1D2094100001307EA7749A0A010141 0 Agent.EnterpriseName 0 STRING EnterpriseName EnterpriseName false true true true false false NONE 1E2F4D6310000130242D2F620A010141 0 Skill_Group.EnterpriseName+++'+('+++Media_Routing_Domain.EnterpriseName++')' 5 STRING Skill Skill false true true true false false NONE 1E2F4D6310000130764612A20A010141 0 DATEPART(ww,+(Agent_Skill_Group_Logout.LogoutDateTime)) 11 DECIMAL Week Week false true true true false false NONE 1E1D20951000013043B7BD6B0A010141 0 Reason_Code.ReasonText 13 STRING ReasonText ReasonText false true true true false false NONE 1E1D20951000013061C495360A0101411E2F4D45100001307B051D240A010141 false 0 false 1E29F6E410000130582A7CEE0A010141 15 AgtSkg Logout (agtskg03) Agent Skill Group Logout By Media true 1 10 3 0 0 1E29F6FD10000130454AE5A40A010141 false false false 23 1E29F6FD10000130255231590A010141 2 70 1E1D209510000130567C0C390A010141 true ReasonDesc -1 1E313A41100001305FB964D10A010141 0 70 1E2F4D45100001301365AC1D0A010141 true Date -1 1E313A651000013078C600AF0A010141 0 70 1E2F4D6310000130020C1EBF0A010141 true Time -1 1E313A7810000130142C345C0A010141 0 70 1E2F4D6310000130764612A20A010141 true Week -1 1E313A59100001307A627D550A010141 0 70 1E2F4D5D100001304AF0B6520A010141 true Month -1 1E29F6FD10000130454AE5A40A010141 1 70 1E1D2094100001307EA7749A0A010141 true Media 2 1E313A7B10000130155C4BC70A010141 0 70 1E2F4D631000013056E458F50A010141 true Year -1 1E313A321000013074B5C3EF0A010141 0 70 1E2F4D45100001307B051D240A010141 true AgentName 0 1E29F6FD1000013006D03F340A010141 4 70 1E1D209510000130284806C50A010141 true LoginDuration 5 1E29F6FD10000130669D1C2D0A010141 4 70 1E1D20951000013043B7BD6B0A010141 true ReasonText 6 1E29F6FD1000013007E70C1A0A010141 1 70 1E1D2095100001303F1A83B10A010141 true ReasonCode -1 1E313A61100001304E73FADD0A010141 0 70 1E2F4D6310000130242D2F620A010141 true Skill 1 1E313A54100001303A684DF20A010141 0 70 1E2F4D53100001302EEE1B470A010141 true LogonDateTime 3 1E29F6FC1000013061302F630A010141 3 70 1E1D20951000013061C495360A010141 true LogoutDateTime 4 1E313A3D10000130769EE8500A010141 0 70 1E2F4D451000013001A92DC30A010141 true DOY -1