Reporting - Include fields from Requested Item and Catalog Task
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2017 03:31 AM
I need to create some reports which include variables on Requested Item and assignment group in Catalog Task. However, can't seem to find a way to combine these fields togeter. Any idea? I don't have Assignment Group on Requested Item form, only on the Catalog Task.
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2017 03:44 AM
I dont know how much following can help but giving a try:
if you need this report to show the relationship between requested item and catalog task:
you may want to create a database view considering these 2 tables and join the table based on your need.
once everything is in place; you can create report on database view.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2017 10:18 PM
Hi Belerin,
Just like Sushant mentioned creating a Database View would help you to add columns from multiple tables for reporting. Please find the attachments that could help you out with the same.
Creating a Report from Two Tables
Please do mark the answer as helpful/correct based on impact.
Thanks
Abhijith