Fetch a report for Variable details associated with RITM

vidyajadhav
Tera Contributor

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

5 REPLIES 5

Sanjay191
Kilo Patron

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.

Sanjay191_1-1784643650880.png



Sanjay191_2-1784643661987.png



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
Tera Patron

@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! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

@Ankur Bawiskar 
Not able to find content on given link

 

@vidyajadhav 

see this

How to bring the catalog variables to the list view of the RITM as it holds the OOB fields. 

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

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader