Quarries Related to Report making
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-15-2024 02:20 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-15-2024 02:30 AM
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-15-2024 04:21 AM
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