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
Topic Participants
darren.ruddick
Dinesh Bhaskaran
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?