Fetch a report for Variable details associated with RITM

[vidyajadhav]

Hi All,

Can someone please help to fetch the report for Variable name. I tried from the List view but there variable column is not available. I need to fetch the data where how many RITM got created for the particular role mentioned in RITM under the variable.

User request is below:-

We need to assess which roles are being used by RHDS because we are planning to decommission the service and need to identify the dependencies.

Please supply a report of service requests for the RHDS service over the last 12 months.

a spreadsheet would be good with each request being a line item showing brief description of the request and which role was affected. This is the most important part because we need to know how many requests against a role to see if it is active. See screenshots for clarity. Any queries please let us know. Thanks

[Sanjay191]

Hi @vidyajadhav 

Yes, it is possible to include catalog variables in an RITM report.

In the Choose Columns section, expand Variables, then select the relevant Catalog Item. After that, choose the required variable (for example, Role). Once selected, the variable will be available as a column in the report and can also be used in the report conditions to filter the results.

This allows you to generate the desired report showing the required RITMs along with the selected variable values.

Please refer to the screenshot below for reference.

If you found my response helpful and it answered your question, please consider marking it as the accepted solution and giving it a thumbs up. It helps others in the community find the solution more easily.

Thank you!

[Ankur Bawiskar]

@vidyajadhav 

check this

How to populate the SR Variables in the RITM List View? 

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

[Tanushree Maiti]

Hi @vidyajadhav 

Refer: youtube.com/watch?v=xZIMd0AurkQ

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

Also you can check it:

Refer : Showing RITM variable, in the list view of a report that is referencing sysapproval_approver table 

Table	Order	Variable prefix	Where clause
sc_item_option_mtom	100	mtom
sc_item_option	200	op	op_sys_id=mtom_sc_item_option
sc_req_item	300	ritm	ritm_sys_id=mtom_request_item
sysapproval_approver	400	app	app_document_id=ritm_sys_id