How to grant access to CMDB Query results to other fulfillers

The SN Nerd · ‎12-15-2020

Hey Community,

I've recently started playing around with CMDB Query Builder to build a report of Business Applications and their downstream relations. I've finally got the results I want and have built a report.

It would appear that the query results are restricted to the author of the CMDB Query, and this is reflected in the ACLs for the base table cmdb_qb_result_base.
I want to share the report I've created with the requestor and others so they can add fields as required. The requestor has the required roles but fails the ACL script, as they are not the 'created by' user.

Is this really by design?

Short of customizing the ACLs, is there a configuration mechanism to share the results in the tool with other licensed users?

The Product Documentation also makes mention of creating CMDB Groups and relating Queries there, but I don't understand how that is supposed to work and is not referenced in the ACLs.

Regards,

Paul

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

The SN Nerd · ‎12-16-2020

When a CMDB Query Builder is created by a user, it can run also by a user that has the "cmdb_query_builder_read" and "cmdb_query_builder" roles and can view the results in a new tab that will display.

However, accessing the "CMDB Query Builder Results [cmdb_qb_result_base]" table or list directly will ONLY be available to the user that created the CMDB Query.

Recommendation:

- To have the other users run the CMDB Query to view the results in a new tab.

- But, if the requirement is to allow the other users to view the CMDB Query Builder Results [cmdb_qb_result_base] list (even it is not the creator of the query), the ACL: "cmdb_qb_result_base/read" can be modified.

https://<instance_name>.service-now.com/nav_to.do?uri=sys_security_acl.do?sys_id=3c2d10decbb73200cab07f1b734c9c75

KB0868465 - CMDB Query Builder Results [cmdb_qb_result_base] access

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

View solution in original post

Runjay Patel · ‎12-20-2020

Check out this video, it will clear all your doubts and help you to understand Cmbd Query Builder queries in details.

Link: https://www.youtube.com/watch?v=VUu3W2Xt_mI&t=93s&ab_channel=ServiceNowHelpdesk

It help you to understand below points.

Overview of CMDB Query Builder
How to create complex query
Will generate report which will help to make better business decision.
CMDB Query Builder feature.
Use cases like simple, complex, multilevel etc.

Please mark reply as Helpful/Correct, if applicable. Thanks!!

The SN Nerd · ‎12-20-2020

I have been struggling a bit with CMDB Query... will check this out.

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

Shambo · ‎11-17-2021

I think I got the answer.

Already addressed by this KB article but I am really surprised why this acl is there if we want to share the report in dashboard, it can' t be useful.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0868465