If you are unable to create a new account, please email support@bspsoftware.com

 

Can I see if a report is being run in HTML/CSV/PDF etc using the audit package?

Started by afroman, 11 Jan 2018 04:34:07 PM

Previous topic - Next topic

afroman

I'd like to find out what mode a report is being run in i.e. html, CSV, xlsx etc. I was hoping this capability would be in the audit package but I don't where to look.

If I can do this, I'd also like to be able to see if people are drilling down into further reports. So for example, if someone ran a report in html, then drilled through into another report, then downloaded an excel copy I'd love to be able to link that up and start to see the user journeys.

Let me know if I'm over reaching, or if this is doable.

Thanks for your help.

gera

Perhaps there will be enough ReportOutput() function?
This function returns output format, e.g. 'HTML', 'PDF' etc.

afroman

Thanks for the reply. That's a useful function to know, but it sounds like it can only be used on the report it is included in?

I want to be able to write a report that could for example sort by frequency the output types of all reports run in the last day. Say 100 were run in HTML, 50 in XLSX, 20 in PDF etc.

I think I found almost what I wanted in the audit table COGIPF_VIEWREPORT which has a 'REPORT FORMAT' field. I need the equivalent for the COGIPF_RUNREPORT table, but there doesn't seem to be one which is frustrating... Anyone know where I can get that?

Thanks

afroman

Also I forgot to explain that the COGIPF_VIEWREPORT only has data on report views that have been setup, where as I want to look at all reports being run ideally.

gera

Quote from: afroman on 16 Jan 2018 05:27:55 PM
That's a useful function to know, but it sounds like it can only be used on the report it is included in?
Yes, this function works only in the report.

We store information about the launch of each report in the DB according to the requirements of internal security (user name, launch date and time, output format etc.).
If you follow this path, you will need to add a stored procedure call to each report...

I hope you find a more easy solution for your task.