How to create report based on ticket history log

[ClaudiaSilva]

Hi,

I need to create a report based on some ticket fields (more specific for incident tickets).

I verify two tables: sys_audit and sys_history_set, but I cannot join them to make a report.

Is there a way to create it?

See the example of report that I need (image attached).

Thank you!!

[Slava Savitsky]

Hi Claudia,

Instead of reporting on sys_audit, consider using Metrics:

Metric Definition Support - ServiceNow Wiki

[Anurag Tripathi]

Totally agree with Salva....

[Slava Savitsky]

Have you had any success with metrics or any other means?