Report Logs Audit

[SS07185@bcbsa.com]

Hey Cognos Gurus-

First, I am not an admin. I am trying to work on a project for my department to upgrade platforms from 8.4 to 10.2.1. As part of this excersize they have asked to find out how many reports we have in Public Folders and My Folders for all users.

A table i am assuming has this information or the admin tools my have this somewhere. We are just trying to understand how many reports are out there and if we can break them out by public and my folders.

How can this be done? Can you help point me somewhere so I can talk to our admin to pull the information?

Is it something I can do as a report author (doubtful)? Is there SQL that you can provide that they can run on the audit database?


Any help would be appreciated.