Get Details from the Content Store Regarding Schedules

[chrispie]

Hi there,
I really hope you can assist. I need to create a Cognos report providing details of all schedules and containing the following information:
Schedule Name
Schedule Path
Step Name
Step Path
Schedule Type (report, job, etc)
Schedule Status
Schedule Owner
Next Run Date
Last Run Date
Last Run Duration

I am having trouble finding the Last Run Duration and I can't use the Audit database because it doesn't seem to contain all the information that I need

Thanks very much in advance
Regards,
Chrispie