Reporting on bulk user access requests
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2023 01:18 PM - edited ‎10-13-2023 01:19 PM
Hello,
Our platform developers sometimes create forms in our Service Portal that allow requesters to make bulk access requests. Basically, if multiple people need access to some kind of sensitive data, the requester can use the functionality in the form to add multiple people. The RITM gets completed when users get added to a user group. Even though we can report on the Group Member table to see if the users are now members of the group, we would like to know if the users actually had a corresponding RITM.
What table would house this data? Is it a custom table that the developers would've had to create? Or are they leveraging a table that regular reporting users can query?
Thank you, much appreciated. 
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-13-2023 03:07 PM
You have to create a database view and report off of that. Below is a screenshot of the tables and were clause to create the view.