Report on custom catalog variables

 

Reporting on Custom Catalog Variables in ServiceNow

Reporting on OOTB catalog variables is quite straighforward. However, reporting on custom catalog variables requires extra 

Reporting on out-of-the-box (OOTB) catalog variables is straightforward. Here is an easy tutorial on how to do that. However, reporting on custom catalog variables require extra configuration. Since custom variables are stored in the sc_item_option_mtom table, they don’t directly appear as columns in sc_req_item or sc_task, making it less intuitive to report on them.

Here’s how you can effectively report on custom catalog variables:

Reporting via Service Catalog Request (sc_req_item) Using Dot-Walking

Note: even if your custom variable is not referenceable, you can still dot-walk in the sc_req_item table.

Steps:

1. Go to Reports > Create New
2. Select Table: sc_req_item
3. Go to Configure > click the "Choose columns" button and find your custom variable
4. In the available section; click on Variables & click + icon; it will ask you the catalog item; select your catalog item (i.e., IAM-Portal Standard request/Non-Standard request [REQ 1124])
5. Move variables you want from available to selected
6. In filter condition; select Item as your catalog item (e.g., Item = " IAM-Portal Standard request/Non-Standard request [REQ 1124]")
7. Still in filter condition; look for something like Variables.<Catalog Item>.<Custom Variable Name>
8. Use Filters for Specific Values (e.g., Application CONTAINS " HANA Cloud")
9. Generate Report

For creating more advanced reports on catalog items I recommend to watch these two videos on Database views:

• Two ways to create ServiceNow Catalog Item Variable Report
• Reporting on Catalog Variables