Reporting on bulk user access requests

Ron B
Tera Contributor

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?

 

bulk request - view from Service Portal form.PNG

 

bulk request - view from RITM ticket.PNG

 

Thank you, much appreciated. 

 

1 REPLY 1

Brian Lancaster
Tera Sage

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.

BrianLancaster_0-1697234853538.png