Custom SDP Report
Dear Team , I am looking for a report that will show me all the support groups, the owner and group technician in charge
I have this report, but it doesn't show me what I need
select qd.QUEUENAME "Support group", au.FIRST_NAME "Technician",AaaContactInfo.EMAILID "Email" from QueueDefinition qd
left join Queue_Technician qt on qd.QUEUEID=qt.QUEUEID
join SdUser sd on qt.TECHNICIANID=sd.USERID
join AaaUser au on sd.USERID=au.USER_ID
LEFT JOIN AaaUserContactInfo ON au.USER_ID=AaaUserContactInfo.USER_ID LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID order by 1