Reporting on User and User Role Tables

Sai89 · ‎06-09-2022

Hello All,

We have requirement in such way that, whoever have admin role has updated any records in User table?

For this following below steps which we are doing it but it has to be automated/scheduled in SNOW.

Step1: Getting to know admin role users in User Role table.

Step 2: Placing all the users in updated by condition and one more condition is updated (between some time period we are giving) in User table

How we can do automate for these two tables to schedule a report in SNOW.

thanks.

Chandu Telu · ‎06-09-2022

Hi,

i have given the similar answer in another request check

https://community.servicenow.com/community?id=community_question&sys_id=bc6009ac1b08d194c552c8031d4bcb41

Thanks
Chandu Telu
Please Mark ✅ Correct/helpful, if applicable,

Aishwarya Thaku · ‎06-09-2022

Hi Sai,

Database Views can be used for creating a report from multiple tables.

Please refer to the link below for the steps to create a database view -

Please mark my answer as helpful or correct if it helped you in any way.

Thanks & Regards,

Aishwarya