How to report all incidents that had an outage record end time in the last 24hrs.

[incidentguy]

Since much of our environment is outsourced, we actually get service restoration times reported back to us by vendors hours after service is actually restored.   Especially where the service was in a country where it was off hours for the local office when service was restored.   Therefore the time we change the STATE of a ticket to resolved is not reflective of the actual restore time.  

I want to be able to run a report showing all incidents we resolved in the last 24hrs, and the only place we accurately record that time is in the outage records (OUTAGE END) for the CI's.   Is there a way I could run a report that show all incident numbers that had outage record end times in the last 24hours?   (We do not use the actual end filed in our forms)

[gyedwab]

Is it possible that you don't have access to the field due to ACL's? The field is out of box on the Outage [cmdb_ci_outage] table and it's called End [end]. I'm assuming you can dot-walk to the outage table for the Begin [begin] field?

[klemmyjb]

Is the Duration on the Outage table the actual time of the outage or just the timestamps from the ticket?