We have a lot of endusers whith QS and AS rights. I expect that most of them haven't used it at all and those who created their own reports have done so a long time ago. Needless to say, this is a waste of license money. Is there a was for me to find out if they opened QS or AS recently? I know i can query the audit package and search for unsaved reports but that won't tell me everything i need to know.
Group an audit-db usage report by the package used in the query audited; from there deduct if the user is a QS or AS user. A "select timestamp, report-package, user group by timestamp, report-package, user ...." gives a monthly usage overview; you probably know which packages are QS and which are AS specific.
That would only tell me if a report has been executed, it doesn't tell me who created the report.
You didn't say you wanted to know who created the report.
Seems to me that it would be unusual for someone to create a report and not run it.
True, most of the times the person who creates a report is the one who runs it as well, only we do have some departments who's job it is to create reports for other end users. And some of those end users have QS and AS rights as well. Anyway, we don't want to revoke their consumer rights, we just want to revoke the right to create reports in QS and AS from those who don't use it.