CMDB Query Builder Results [cmdb_qb_result_base] access - Support and Troubleshooting

CMDB Query Builder Results [cmdb_qb_result_base] access Issue CMDB Query Builder Results [cmdb_qb_result_base] access.

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.

Release All

Cause This is working as designed as the "Out-Of-The-Box" ACL: "cmdb_qb_result_base/read" has the script below has the code " answer = (current.sys_created_by == gs.getUserName()); " which checks the created by. https:// .service-now.com/nav_to.do?uri=sys_security_acl.do?sys_id=3c2d10decbb73200cab07f1b734c9c75

Roles: cmdb_query_builder cmdb_query_builder_read

Script: answer = (current.sys_created_by == gs.getUserName()); if (answer) { var fields = current.getFields(); for (var i = 0; i var fieldName = fields.get(i).getName(); if (fieldName.startsWith("u_rel_")) { var val = current.getValue(fieldName); var rel = new GlideRecord('cmdb_rel_ci'); rel.get(val); var canRead = rel.canRead(); answer = canRead; } } }

Resolution 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:// .service-now.com/nav_to.do?uri=sys_security_acl.do?sys_id=3c2d10decbb73200cab07f1b734c9c75

Update the Script section:

From:

answer = (current.sys_created_by == gs.getUserName()); if (answer) { var fields = current.getFields(); for (var i = 0; i var fieldName = fields.get(i).getName(); if (fieldName.startsWith("u_rel_")) { var val = current.getValue(fieldName); var rel = new GlideRecord('cmdb_rel_ci'); rel.get(val); var canRead = rel.canRead(); answer = canRead; } } }

To:

answer=true;

Related Links Modifying the "Out-Of-The-Box" ACL: "cmdb_qb_result_base/read" will relates to customizations which unfortunately falls outside of the scope of Technical Support. We will handle and manage break-fix issues with the platform and questions regarding expected OOB functionality.

If this functionality is extremely important to your business, please understand that you may need to engage Professional Services which can be provided by ServiceNow on a paid engagement or your preferred partner.