Creating a report of RITM with variables and approvals

[tsutherland]

I am trying to create a report of a specific catalog item and its variables (dealing with access requests) along with the approvals. I have created a database view which includes the sc_req_item table and the sysapproval_approver tables. In creating a report, I can dot walk to the variables of the specific item to add the columns, but they do not show in the report.

I found a VERY similar old question on the community here (https://community.servicenow.com/community?id=community_question&sys_id=21a65ccedb8063045ed4a851ca961934&view_source=searchResult) which indicates that one could add the variables table in the DB view and link the RITM records sys_id with the variables task field, but there are no details how to do that.

Does anyone know how to do that or have another solution to this issue?

[ServiceNow Tec2 · Accepted solution]

This has been resolved by ServiceNow Technical Support. Please refer to KB0597916 for more information.

[kmarinelli]

This is a limitation we have also struggled with.  Our business and internal audits often ask for reports of  Service Catalog Items (RITM) - such as Building or Security access -  They require:  What exactly was requested (catalog item variables), for Whom, and approval details.    The organization is committed to using the ServiceNow Platform to manage these service requests and is happy with the approval process and ability to automate, but the inability to provide detailed reporting is disappointing. 

An idea is posted by another member in the idea portal to develop this enhancement.  Please review and up-vote if you agree.

https://community.servicenow.com/community?id=view_idea&sysparm_idea_id=20e195d2db4b28506621d9d96896192e&sysparm_idea_table=x_snc_com_ideation_idea&sysparm_module_id=enhancement_requests 

In the meantime, if anyone has any suggestions, I'm all ears!   Sounds like to get variables, I need to report directly on sc_req_item - has anyone had luck pulling in approval details?