1E2373C5100001304159F5640A010141 3 GROUP_READ_EXEC_OTHER_NONE Default Agent Logout by Media 1E1E3533100001301804FEC50A010141 21 GROUP_READ_EXEC_OTHER_NONE Default Agent Logout by Media 80 CCCCCCCC00000000AAAAAAAA00000003 SQUERY SELECT Agent.EnterpriseName AgentEntName, AgentName = Person.LastName + ', ' + Person.FirstName, Agent_Logout.LoginDuration, LogonDate = DateAdd(s,-1 * Agent_Logout.LoginDuration,Agent_Logout.LogoutDateTime), Agent_Logout.ReasonCode, Reason_Code.ReasonText, Reason_Code.Description, Agent_Logout.LogoutDateTime, CASE Agent_Logout.PhoneType When 0 THEN 'Local' WHEN 1 THEN 'Mobile.Call By Call' WHEN 2 THEN 'Mobile.NailedUp' Else 'n/a' END PhoneTypeText, RemotePhoneNumber = Agent_Logout.RemotePhoneNumber, Extension = Agent_Logout.Extension, Media_Routing_Domain.EnterpriseName Media, Date = CONVERT(char(10), (Agent_Logout.LogoutDateTime), 101) , Time = (RIGHT('0'+ CONVERT(Varchar(2),DATEPART(hh,(Agent_Logout.LogoutDateTime))),2) + ':' + RIGHT('0'+ CONVERT(Varchar(2),DATEPART(mi,(Agent_Logout.LogoutDateTime))),2)), Year = DATEPART(yyyy, (Agent_Logout.LogoutDateTime)), Month = DATEPART(mm, (Agent_Logout.LogoutDateTime)), Week = DATEPART(ww, (Agent_Logout.LogoutDateTime)), DOY = DATEPART(dy, (Agent_Logout.LogoutDateTime)) FROM Agent, Person, Media_Routing_Domain, Agent_Logout, Reason_Code WHERE ( Agent.PersonID = Person.PersonID ) and ( Agent.SkillTargetID = Agent_Logout.SkillTargetID ) and ( Agent_Logout.MRDomainID = Media_Routing_Domain.MRDomainID ) and ( Agent_Logout.ReasonCode = Reason_Code.ReasonCode)and ( Reason_Code.ReasonCode = Agent_Logout.ReasonCode ) ORDER BY Person.LastName, Person.FirstName, Media_Routing_Domain.EnterpriseName, Agent.EnterpriseName, PhoneTypeText, Agent_Logout.RemotePhoneNumber, Agent_Logout.Extension, Agent_Logout.LoginDuration, Agent_Logout.LogoutDateTime ASC true 900 false 1E20EA7A100001301C2DCB290A010141 1 CONVERT(char(10),+(Agent_Logout.LogoutDateTime),+101) 12 STRING Date Date false true true true false false NONE 1E1E353B1000013012860B370A010141 0 Agent_Logout.Extension 10 STRING Extension Extension false true true true false false NONE 1E1E353B100001303F2474340A010141 0 Agent_Logout.ReasonCode 4 DECIMAL ReasonCode ReasonCode false true true true false false NONE 1E1E353B100001305A8CA8E80A010141 0 Reason_Code.Description 6 STRING Description Description false true true true false false NONE 1E20EA91100001307075ACE30A010141 1 CASE+Agent_Logout.PhoneType+When+0+THEN+'Local'++++WHEN+1+THEN+'Mobile.Call+By+Call'+WHEN+2+THEN+'Mobile.NailedUp'+Else+'n/a'+END 8 STRING PhoneTypeText PhoneTypeText false true true true false false NONE 1E1E353B100001305D7CE0CF0A010141 0 Agent_Logout.RemotePhoneNumber 9 STRING RemotePhoneNumber RemotePhoneNumber false true true true false false NONE 1E20EAA01000013015766FD00A010141 1 (RIGHT('0'++CONVERT(Varchar(2),DATEPART(hh,(Agent_Logout.LogoutDateTime))),2)+++':'+++++++RIGHT('0'++CONVERT(Varchar(2),DATEPART(mi,(Agent_Logout.LogoutDateTime))),2)) 13 STRING Time Time false true true true false false NONE 1E1E353B10000130744C84C00A010141 0 Media_Routing_Domain.EnterpriseName 11 STRING Media Media false true true true false false NONE 1E1E353B1000013043D5E0610A010141 0 Agent.EnterpriseName 0 STRING AgentEntName AgentEntName false true true true false false NONE 1E20EA9F100001301A3796AD0A010141 1 DATEPART(ww,+(Agent_Logout.LogoutDateTime)) 16 DECIMAL Week Week false true true true false false NONE 1E20EAA01000013011AA59F10A010141 1 DATEPART(yyyy,+(Agent_Logout.LogoutDateTime)) 14 DECIMAL Year Year false true true true false false NONE 1E20EA811000013066D4333E0A010141 1 DateAdd(s,-1+*+Agent_Logout.LoginDuration,Agent_Logout.LogoutDateTime) 3 DATETIME LogonDate LogonDate false true true true false false DATE_SHORT_TIME_SHORT NONE 1E1E353B100001306E2217550A010141 0 Agent_Logout.LogoutDateTime 7 DATETIME LogoutDateTime LogoutDateTime false true true true false false DATE_SHORT_TIME_SHORT NONE 1E1E353B1000013032880C0A0A010141 0 Reason_Code.ReasonText 5 STRING ReasonText ReasonText false true true true false false NONE 1E1E353B100001307EB05AF40A010141 1 Agent_Logout.LoginDuration 2 DECIMAL LoginDuration LoginDuration false true true true false false Minutes+and+seconds+(hh:mm:ss) SUM 1E20EA9210000130198AC0010A010141 1 DATEPART(mm,+(Agent_Logout.LogoutDateTime)) 15 DECIMAL Month Month false true true true false false NONE 1E20EA7E100001307913A7C00A010141 1 DATEPART(dy,+(Agent_Logout.LogoutDateTime)) 17 DECIMAL DOY DOY false true true true false false NONE 1E20EA7A10000130394C31510A010141 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 1E1E353B100001306E2217550A0101411E20EA7A10000130394C31510A010141 false 0 false 1E2373E4100001303A7C2C400A010141 3 Agent Logout (peragt03) Agent Logout by Media true 1 10 2 0 0 1E2373F71000013004A863CE0A010141 1E2373F7100001307295A79B0A010141 1E2373F7100001302DC524AC0A010141 false false false 21 1E2373F71000013057870E4C0A010141 1 70 1E20EA7E100001307913A7C00A010141 true DOY -1 1E2373F610000130118F99EE0A010141 1 70 1E1E353B100001307EB05AF40A010141 true Login Duration 4 1E2373F71000013004A863CE0A010141 1 70 1E20EA7A10000130394C31510A010141 true AgentName 0 1E2373F710000130026966E80A010141 1 70 1E1E353B100001303F2474340A010141 true ReasonCode -1 1E2373F7100001307143D2170A010141 1 70 1E20EA9210000130198AC0010A010141 true Month -1 1E2373F71000013033E062660A010141 1 70 1E1E353B100001306E2217550A010141 true Logout DateTime 3 1E2373F7100001307929C1AF0A010141 1 70 1E1E353B1000013032880C0A0A010141 true ReasonText 5 1E2373F710000130117CC3FC0A010141 1 70 1E20EAA01000013015766FD00A010141 true Time -1 1E2373F6100001306A5030D80A010141 1 70 1E20EA7A100001301C2DCB290A010141 true Date -1 1E2373F71000013058F80B370A010141 1 70 1E20EA91100001307075ACE30A010141 true Connection Type 6 1E2373F7100001302DC524AC0A010141 1 70 1E20EA811000013066D4333E0A010141 true Logon DateTime 2 1E2373F710000130376D91C50A010141 1 70 1E1E353B100001305A8CA8E80A010141 true Description -1 1E2373F710000130166F147F0A010141 1 70 1E1E353B1000013043D5E0610A010141 true AgentEntName -1 1E2373F7100001307F1F12420A010141 1 70 1E1E353B100001305D7CE0CF0A010141 true Mobile Agent Number 7 1E2373F710000130324424640A010141 1 70 1E20EAA01000013011AA59F10A010141 true Year -1 1E2373F710000130298A2C230A010141 1 70 1E1E353B1000013012860B370A010141 true Extension 8 1E2373F7100001302FE98DD10A010141 1 70 1E20EA9F100001301A3796AD0A010141 true Week -1 1E2373F7100001307295A79B0A010141 1 70 1E1E353B10000130744C84C00A010141 true Media 1