Many customers asked whether the automator is involved in our ITRP_reporting solution or not. No. We use our PowerShell framework to populate the SQL database. Right now, this is the most efficient and effective technology for that purpose.
Audit records can not be exported by using the ITRP standard export functionality. Audit data need to be exported via the API. This is the newest capability of our reporting solution.
For what purpose do you need the audit records?
How often have tickets changed assignments / Service Instances?
If your Service Desk follows a “Capture, structure, solve or assign (change the Service Instance in ITRP)” approach, it tells you how well the Service Desk performs in terms of narrow the issue down to the root cause, when they structure the ticket
How often has a ticket being touched?
Depending on detailed data this could be an indicator of working not efficient or people are simply not trying to solve the ticket in one go.
Easy to generate standard dashboards
Our PowerShell framework normalizes the database automatically, including the audit tables. Based on that easy to use structure it is easy to generate dashboards in PowerBI or another tool of your choice instantly.