How to include variables in the report of Requested Items (Service Catalog)

[Rajanmehta]

Hello

We are on Jakarta. We have a need to create report on Requested Items (From Service catalog). The report also need to include variables of Requested Items as shown in the second screen shot below. I don't see these variables if I open any RITMxxxxx record. Only visible when hover over the information icon.

Please advise how can we create such report which would include Request Item with it's variable values?

Thanks,

Rajan Mehta

[darlawolf · Accepted solution]

Try this DOCs link: Use a service catalog variable in a report

[Rajanmehta]

Thank you Darla.

This is exactly what I was looking for. Appreciate your help.

Thanks,

Rajan Mehta

[Prateek kumar]

Hello rajan

1.Try creating a report on Variable ownership table(sc_item_option_mtom). PFA

2.You can also create a database view joining RITM table and variable ownership table

[Rajanmehta]

Thanks Prateek,

Appreciate your response to help me out.

Thanks,

Rajan Mehta