Query about groups and technicians

Query about groups and technicians

Hi team,

could be possible to obtain a query to extract a list of support groups, associated roles and technicians (with additional user information like name, email, phone, etc)?

SDP v11.0
SQL Server

Thanks in advance

                  New to ADSelfService Plus?