filter out specific project related users/Reports from Audit DB/Package

[satyajit.igate@gmail.com]

Hi,
My requirement: i have 10 number of different projects in Cognos 10.2 prod env. For each project there are separate users. i want to filter only my users/reports which belongs to my project from the all 10 projects available. and i want to achieve thru audit package/db as i don't have a separate table for all my users and theirs details.

so the problem here is: when i use user_name/report_name query-item from the runreport query-subject of Audit package, it lists out all the users/reports from all 10 projects who recently ran the report. is there any way where only our project users/reports can be filtered out? pls reply and let me know for any additional query.

[New_Guy]

Hi,
Do the users from all projects use the same packages and same reports or does your project has a separate folder where they run the reports from? If that is the case you can use the folder path and package name as filters and get the desired results.

If the above is not the case, you can use the user id's of the users that are in your project and use them in the filter. How many users are in your project?

Good luck
New guy

[satyajit.igate@gmail.com]

Thanks for your reply. to answer your questions-

Do the users from all projects use the same packages and same reports or does your project has a separate folder where they run the reports from?
Ans: No. all projects donot use same package and same reports. yes i have a separate folder.

If that is the case you can use the folder path and package name as filters and get the desired results.
Ans: I tried that in the filter to hard code all the package names(around 20) in the filter, but still it doesnot list out all my 500+ users who are active in Cognos, it just returns the user names who all recently ran/view the report.

If the above is not the case, you can use the user id's of the users that are in your project and use them in the filter. How many users are in your project?
Ans: yes that can be done, but there are 500+ users and every week there is add/delete to the user list. If i implement this one then i have to change the code every time, once there is new user add or existing user delete.

Pls suggest something else.

[New_Guy]

Hi,
If the users from your project are running the reports from a separate folder then you should get the right audit information, if you are using the folder/package path in the filter. Are you using any filter on the timestamp if not add a filter on the timestamp and check? Can you ask the users that you are not seeing on the audit report to confirm if they are actually running any reports or not?
And also please confirm with your Audit Database DBA's if they are maintaining the historical data or not, or is there any data retention rule.
Can you check if we can get the user names in a query based on the their identity(by using a macro) and we can use it in a filter for the actual query that you are reporting on?

Good luck
New guy