Identify Users With Reports in 'My Folders'

[gronhoffga]

Happy Friday,
I have taken over for a previous Cognos admin/modeler and will be switching from the 12+ packages that he was using to one master package. The only problem is that my user base is really large and some of them have copied reports to their 'My Folders' and set custom parameters. So what I am wondering if there is any custom report or query that I can run that will tell me users that have reports saved, that way I won't need to spend two weeks looking through everyones profiles just to find maybe 20 people. I don't think this is possible but if anyone out there knows any way of doing this you would seriously make my day...

Thanks in advance

g

[tupac_rd]

Not the best of solutions, but for each package you could do a 'Find Report dependencies' from Framework Manager for all of Content Store....

[redmist]

Another imperfect method could be to look at use the Audit package and filter on Report Path's that have 'My Folder' in it.

[gronhoffga]

Another imperfect method could be to look at use the Audit package and filter on Report Path's that have 'My Folder' in it.

Pure genius!!!! I used the audit package and did what you suggested (I also added a prompt to get a more detailed report), set it to render in PDF and BAM! got the output I needed...

thanks redmist

g

[redmist]

just an FYI for those trying to get the report names and locations from Audit.
I came across this formula in IBM KB to extract the names

SUBSTR([Audit].[COGIPF_EDITQUERY].[QUERY NAME],
instr([Audit].[COGIPF_EDITQUERY].[QUERY NAME],'''',1,1)+1,
instr([Audit].[COGIPF_EDITQUERY].[QUERY NAME],'''',1,2) -
instr([Audit].[COGIPF_EDITQUERY].[QUERY NAME],'''',1,1)-1)

SUBSTR([Audit].[COGIPF_EDITQUERY].[QUERY PATH] ,
instr( [Audit].[COGIPF_EDITQUERY].[QUERY PATH] ,'''',1,1)+1,
instr( [Audit].[COGIPF_EDITQUERY].[QUERY PATH],'''',1,2) -
instr( [Audit].[COGIPF_EDITQUERY].[QUERY PATH],'''',1,1)-1)