Report on Requested Item metric and Requested Item catalog variable

[Prateek Gupta3]

Hi All,

We have a requirement to calculate the metric on Requested item table to calculate time taken between "Opened At" and "Approved/Rejected". This we can calculate using metric definition on approval field i.e. when it changes form Requseted to Approved/Rejected.

Now the ask is, we need a report on this metric instances for a particular catalog item when Type of Request(catalog variable on that item) = Troubleshooting.

Also please suggest if there could be another approach to fulfil the requirement.

Thanks,

Prateek

[Nitin_NOW]

You can always report on Catalog item variables. Please find the below link helpful.

Report on Service Catalog Variables

Please hit correct based on impact of response.

Thanks

[Slawek_Radziewi]

You can use sc_item_option_mtom table for variables and from there you can go to sc_req_item.

[shaik mohammad]

Create report on OOO database view table "sc_req_item_metric". this table contains three tables data. like metric instance, metric definition and RITM table as well. so that you can simply draft the report as per your requirement.