How many users has 'Read & Write Access' in ServiceNow CMDB

[pampapathi1]

Hi All,

how create a report, how many users currently have 'Read & Write Access' in ServiceNow CMDB in the following tables, Need current access holders list.

alm_hardware
cmdb_ci
cmdb_ci_handheld_computing
cmdb_hardware_product_model
core_company
cmn_location
alm_stockroom

Could someone help me to resolve this.

Thanks,

Pampa

[pampapathi1 · Accepted solution]

Hi Atul,

Thank you for updating.

When we retrieve the role table in a report, we will see multiple role tables.

Could you please tell me more about this? Attached screen shot for your reference.

That helps a lot.

[Dr Atul G- LNG]

Hi @pampapathi1 

If you see OOTB cmdb_read role, that applies to Config table. 

You need to create report on Role tabel and then from thee get the application with role details. 

[pampapathi1 · Accepted solution]

Hi Atul,

Thank you for updating.

When we retrieve the role table in a report, we will see multiple role tables.

Could you please tell me more about this? Attached screen shot for your reference.

That helps a lot.

[Dr Atul G- LNG · Accepted solution]

Hi @pampapathi1 

Pratically we need to create report on sys_user_role, but due to performance impact this table is not available for reporting.

If you need the user who has this role then we can do on user had role table.