Query raport Technical with role and support group

Query raport Technical with role and support group

Hi, 
I need create query raport Technical with role and support group. 

SDP: 111140 MSSQL 2016 
How create this raport? I try use query from knowledge but not work (sql problem).

regards
Mat 

                  New to ADSelfService Plus?