Need to create a report to identify the list of users those have edit access for CMDB records in CM

Geethika
Tera Contributor

‎11-08-2023 07:04 AM - edited ‎11-08-2023 07:25 AM

Need to create a report to identify the list of users those have edit access for CMDB records in CMDB

 

Could someone please assist me how to create report for this edit access in cmdb records.
As this is the priority have to complete as soon as possible 


So please assist me to complete this. Hope someone will reply to this

 

 

Thanks in advance,

Geethika 

0 Helpfuls
  • 327 Views
1 REPLY 1

Astik Thombare
Tera Sage

‎11-08-2023 09:25 AM - edited ‎11-08-2023 09:26 AM

Hi @Geethika ,

 

Step 1: Identify the roles that have edit access to CMDB records. This can be done by reviewing the access control lists (ACLs) associated with the CMDB tables. (For example, consider the cmdb_ms_editor and cmdb_ms_admin roles.)

Step 2: Create a report on the User table (sys_user) with the following conditions:

  • Active is True
  • Roles is cmdb_ms_editor
  • OR
  • Roles is cmdb_ms_admin

Please refer to the screenshot below.

 

AstikThombare4_0-1699463984346.png

 

After that, select the report of your choice (for my example, I'm choosing "List of Records").

 

AstikThombare4_1-1699464167918.png

 

This is how you will list the Users who have edit access to the CMDB table.

 

Please mark ✅ Correct if this resolves your issue. Also, mark 👍 Helpful if you find my response valuable based on its impact.

 

Regards,

Astik Thombare

0 Helpfuls