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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to determine if someone uses QS at all

Started by Ty Clabbers, 22 May 2008 05:54:52 AM

Previous topic - Next topic

Ty Clabbers

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.

raro

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.

Ty Clabbers

That would only tell me if a report has been executed, it doesn't tell me who created the report.

almeids

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.

Ty Clabbers

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.