No. of Ritms generated

[servicenow14710]

hello developers,

 I need to calculate how many ritms have been generated by a particular requester/user in a catalog item. Any help is appreciated. 

Thanks!

[swathisarang98]

Hi @servicenow14710 ,

You can create a report or simply open "sc_req_item" (sc_req_item.LIST) table in that you can bring Requested for and in the filed value you can add the user name for which you are trying to extract data and if needed you can filter date range aswell,

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[servicenow14710]

Hi @swathisarang98 : 

Not just filter this has to be for particular catalog item. Thanks!

[Zach Koch]

Just add the field, Item, to your filter and choose the catalog item you want to filter on.

[swathisarang98]

Hi @servicenow14710 ,

You can add your item name aswell in the list view,

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang