Quarries Related to Report making

subhadutta23069
Tera Contributor

I want to make one report on catalog item that how often they are used monthly. Which are available for specific user with specific role. Please help.

 

 

 

Thanks,

Subhabrata

2 REPLIES 2

AndersBGS
Tera Patron
Tera Patron

Hi @subhadutta23069 ,

 

You can just report on the sc_req_item table and add a condition for "item is XXX". the "XXX" refers to your defined catalog item. If you then create a times series report, where after you select by month. By doing this, your requirement should be fulfilled.

 

  

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

subhadutta23069
Tera Contributor

Hi @AndersBGS 

there are many catalog item not only one for which I want to get the usage. Also it will be helpful if you can share how to create the times series report