Reporting on Requested Item from Service Portal

[greenbean]

Dear Community,

 I want to create a data dump as a one time report for one key service catalogue item. The report would need to contain our sc_req_item values, sc_task values, sysapprover_approver values in one report for business analysis by another team. Example, Requester data  - the user provided data i.e. user completed the form questions, assignment group data, i.e. work notes, the approver data i.e. comments. title. location, approved, rejected.

Under the 'Create a report' module, it will only allow one table type, I thought if I could create a data source from sc_req_item however I cannot seem  to make the reports merge.

I could created three separate reports and merge the fields as required however for accuracy I'd rather not do that due to human error risk

Thanks

[Tom Sienkiewicz]

Yes I think OOTB the list report is the only type of report that lets you add variables.

It should be easy to add sc_cat_item, sc_req_item values to such a report. Adding approver or sc_task information is another story, since this is not a 1:1 relationship. So you might have to create some database view to achieve such a report, although the result would be as many rows for one Requested Item as there are approvers/sc_tasks connected to it.

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/use/reporting/concept...

[JeremyHoffman · Accepted solution]

Hi Greenbean,

If I am reading your post correctly, you should be able to accomplish this by creating a list view report on the sc_task table.

1. Under Configure, Choose Columns:
• Click on the Variables+ then the "expand" icon in the middle to pop up the list of Request items.
• Select the Catalog item you want to report on.
• Select and add the Variables you want to display.
• Here is a view of the variables we have for our Laptop item, I have most of them added to the Selected box already:
1. 
• Click on Request Item+ then expand that to see all the fields in the Request item
• Add Item, Approval and Approval History.
• You can see I have these fields added to the Selected box already. (Request item.approval, Request item.approval history, and Request item.item) 
• Note: the request.item approval and approval history show data for us as our approvals are at the Request item level. You may need to adjust and show Request.approval and approval history if your approvals are at the Request level.
• Add/remove fields from the sc_task table or expand the Request item or Request fields to add fields from those tables.
• I will often add more fields then necessary to see what data is returned and then remove unwanted fields. I will also set a Filter condition to something like created last week to allow the report to run faster. I will update it with the final date range and filter conditions once I have all the columns defined.
• Once you have the columns, and filter conditions set, Run the report. you can either export the data by clicking on one of the header columns in report. Or you can share (add to a dashboard) for others to view within the platform if they have the appropriate access to see the data.  

I hope this helps, please mark as Helpful if it does.