Visibility of catalog variables in reports

[AmanPratapS7233]

Hi All,

I've got a requirement where the business wants to get a list of all the RITMs raised on Catalog item 'A'. The list should include many fields for ex - assignment group, requested for etc and VARIABLES of the catalog item as well.

I tried to export the csv from the list view but, I am not able to get the variables. Can you please guide me ?

Thanks

[Mayura1997 · Accepted solution]

Hi, You can create a report on RITM table and select acatalog item in filter. For variables, you can use variables(+) in columns of the report and select the required variables name and save the report. 

[Tanushree Maiti · Accepted solution]

Hi @AmanPratapS7233 

Option A:

You can create a report that with variable columns and then export that report to CSV or Excel.

1. Navigate to Reports > Create New.
2. Data Source: Select sc_req_item (Requested Items) table.
3. Filter Conditions: Set Cat Item | is | [Name of Catalog Item A].
4. Configure -> Choose Columns:
• In the slushbucket, scroll down until you see Variables (marked with +).
• Click Variables. A popup will appear asking for the Catalog Item. Select Catalog Item A.
• Select the variables you want and move them to the right.
5. Save and Run the report.
6. Click the share/export icon and select Export > CSV or Excel

Option B:

If you need to do this frequently, creating a Database View is the most robust approach to join RITM data with Variable data

Refer: Reporting on Catalog item variables

[Mayura1997 · Accepted solution]

Hi, You can create a report on RITM table and select acatalog item in filter. For variables, you can use variables(+) in columns of the report and select the required variables name and save the report. 

[Tanushree Maiti · Accepted solution]

Hi @AmanPratapS7233 

Option A:

You can create a report that with variable columns and then export that report to CSV or Excel.

1. Navigate to Reports > Create New.
2. Data Source: Select sc_req_item (Requested Items) table.
3. Filter Conditions: Set Cat Item | is | [Name of Catalog Item A].
4. Configure -> Choose Columns:
• In the slushbucket, scroll down until you see Variables (marked with +).
• Click Variables. A popup will appear asking for the Catalog Item. Select Catalog Item A.
• Select the variables you want and move them to the right.
5. Save and Run the report.
6. Click the share/export icon and select Export > CSV or Excel

Option B:

If you need to do this frequently, creating a Database View is the most robust approach to join RITM data with Variable data

Refer: Reporting on Catalog item variables

[Ankur Bawiskar · Accepted solution]

@AmanPratapS7233 

I will suggest to create database view and then use that in reporting

Databases view by request item and service catalog (variable) 

Report on Item Variables in the Service Catalog with a Database View 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏