I am trying to create a monthly rule to automatically generate Problems based on Incident and SR trends.
For example I would run a query selecting the top 10 incidents that took longest to resolve, then from these 10 results I would create 10 Problems with 'NEW' status.
Another example would be to query a list of the top 5 most recurring incidents per Service, then create 5 corresponding problems.
The problem is (no pun intended), how do I do that in TSRM 7.2.1 without writing a custom class?
- Escalations won't work because they run against a single record.
- Cron tasks require a java class.
- Don't know much about Automation Scripting or it's capabilities, could be an option.
Is something like this feasible in TSRM without Java customization?