Hi community , I want to build a query to know reports that ran at most 1 time during each month of the last for months (monthly report during 4 month )
I m using the audit package .
Thank you
Since nobody replied yet I´ll give it a shot, if anybody has an actual solution I need it too ;-)
'At most 1' is hard. A <=1 filter on #runs (counting Timestamps from Run Reports) will only give you a set of reports that ran exactly one time. There's no record of reports with zero runs.
To add at least something extra, you might use a seperate query that gathers every existing[Report name], and outer join your way to add reports that 'have been run some time in the past but not this month'.
Reports that have never been run at all are simply not available in Audit as far as I know. To get at those you'd need access to the actual content store db.
Regards,
Steve
Thank you "ImSteve" for your reply