Hello,
I need to make a BAQ that tells me which user(s) ran a report. This is what I have so far. The report in question has the word “Extract” on it, so I used that for my Filter Value. Nothing populates, though. I would appreciate help figuring out where I went wrong. Thank you.
WhoRanTheReport.baq (18.8 KB)
What did you join on? I think you could get this information directly from the SysTask table, as long as you document your task descriptions. You can filter the systask table for just task type = Report, then filter by the Task Description.
I don’t think you need the ice.report table. In fact, I don’t see any way to link it if you did need it.
Good luck!
@mlp @NateS is correct that the SysTask table has the submituser who ran the report, unless it is in a process set and then it is the user who built the process set not anyone who submitted it as a task. Also the SysTask table is cleared based on the archive value when a report is submitted. No archive is a couple of days I think.
Hello, thank you for replying.
I got as far as filtering it by Task Type = Report and doing say %Sales% for the other criteria, but it populates only to 4/4/23 and 1147 rows… with no more records to return. Does the system only keep it for about a month it looks like?
