I had an inquiry from our leadership as to who (technicians) can view what data in our Service Desk system, and I scoured the forums and can't find a query provided that matches our current database.  The HelpDeskCrew table is gone in this version, so the old queries don't work and I can't figure out which table to use to replace it.

I'm looking for 2 queries:

1.  Show which roles contain which privileges.

      Admin -> Users -> Roles

      Fields:

      Role Name, Role Description, Permissions granted/not granted to the role

      Example Roles (Out of the Box):

       AERemoteControl

      Example Permissions:

      View Contracts

      Add Requests

      Allow User to Share a Request

2. Which technicians have which roles assigned:

      Technician ID, Technician Name, Roles Assigned to Technician

      Example:

      Name                        Role

      My Name                   SDAdmin

System Info: