Hello,

I am looking to create a two reports for internal auditing of ServiceDesk access. Having trouble doing this through the GUI report creator.

1. A report detailing "role" access to the system. Who is an Admin, Technician, etc.

2. A report detailing all groups and their members.

Has anyone created such reports and have an MSSQL query to share? I would suggest these types of reports be included as canned reports.

Many thanks,

Shawn