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

[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