database view of sys_user and sys_user_group

[simran3]

how do i create a database view of these tables?

[Community Alums]

Hi @simran3 ,

Please follow the steps to create the database view:

https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/use/reporting/task/t_Crea...

Also, for reference follow the thread: https://www.servicenow.com/community/developer-forum/database-view-combinining-sys-user-group-and-in...