Hello Everyone,
I have created a dashboard containing 6 reports based on the Requested Item (sc_req_item) table.
For catalog items, we have a Service Owner field, and we need to share the following information with each respective Service Owner on a monthly basis:
- Number of RITMs created in the last month (count)
- Count of SLA-breached RITMs
- CSAT score
- Automation level of the catalog item
The challenge is that we have over 400 Service Owners, and around 65,000 to 70,000 RITMs are created monthly in production.
We need to send each Service Owner their related RITM counts and SLA breach details every month. What would be the best way to implement this? Has anyone tackled a similar requirement or have any suggestions?
@SANDEEP DUTTA @Ravi Gaurav @Ankur Bawiskar
Thanks,
Sattar
