SELECT AaaUser.USER_ID,

       AaaUser.FIRST_NAME "FullName",

       AaaLogin.NAME "LoginName",

       AaaContactInfo.EMAILID "Email",

       AaaContactInfo.LANDLINE "Phone",

       AaaContactInfo.MOBILE "Mobile",

       (qd.queuename) "Group" FROM AaaUser

LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID

LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID

INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID

INNER JOIN HelpDeskCrew ON SDUser.USERID=HelpDeskCrew.TECHNICIANID

LEFT JOIN Queue_Technician qt ON qt.TECHNICIANID=AaaUser.USER_ID

LEFT JOIN QueueDefinition qd ON qt.QUEUEID=qd.QUEUEID

 

LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID

 

WHERE (SDUser.STATUS = 'ACTIVE')

We used to use this query to poll for current technicians. It is no longer valid in current versions and we would like an updated query.