Get the list of reports in 'My Folder' of users

[Drisya]

Hello All,

Can we get the list of reports in all users 'My Folder'. Probably from Content store!

My requirement is to create a report which displays the the list of reports in 'My Folder' for all users.

Thanks

[RKMI]

Hi,

If you have an audit database/ audit package you can do it. You can create a report where username who has run a report from my folders. Then also create a list of reports executed from their My folders area. *Note: Audit DB will capture the reports which were executed not all the reports listed in their My folder.

Hope this helps.

Thanks,
RK

[Drisya]

Hi,

Thanks for your reply. But the problem with Audit package is, if the object is deleted by user then also it will display in the report.
Secondly, the migration to c10 happened 2 month back, so the audit data is available for 2 months only.

Any other solution?

[Rahul Ganguli]

You can query content store for the list of reprots in user's my folder
I have created such a query  in past

I have t search it, I will get back to you with the query soon

Regards,
Rahul

[Rahul Ganguli]

Hi,

Attached is the query for users with My Folder content.
This query is on Oracle Content Store, you may need to change few syntax if you have other Database.

Hope this was helpful.

Regards,
Rahul

[Drisya]

Thanks Rahul. It helps.

The query is working for me in SQL server. But it displays all the objects directly inside 'My Folder' and not the items inside folders.
I will work more on it and try to retrieve them as well.

[Rahul Ganguli]

I will try from my end too.
This time I will try in SQL sever 2008.

Regards,
Rahul

[murali999]

Hi,
you can list all the reports from users MyFolders easily by using cognos SDK program.

are you having the SDK installation ?

[TheBrenda]

stupid question, but how do i access the script? I see the paperclip but have nothing to click on. I have downloaded scripts from here before but for some reason (late night) i am now unable.

[MFGF]

stupid question, but how do i access the script? I see the paperclip but have nothing to click on. I have downloaded scripts from here before but for some reason (late night) i am now unable.

I can access it with no issues. It's fairly small, so I'm pasting the contents below. Hope this helps! :)

MF.

Code Select Expand

--List of Users with My Folder Contents
with base_query as
(select classid, cmobjects.cmid, cmobjects.pcmid, cmobjnames.name as reportname
from cmobjects , cmobjnames
where cmobjects.cmid = cmobjnames.cmid
--and classid in (10)
and cmobjnames.mapdlocaleid = 24
union
select classid, cmobjects.cmid as cmid, cmobjects.pcmid, cmobjnames.name as reportname
from cmobjects , cmobjnames
where cmobjects.cmid = cmobjnames.cmid
and  cmobjects.cmid in (select distinct cmobjects.pcmid from cmobjects)
and cmobjnames.mapdlocaleid = 24
)
select distinct OW1.name,X.directory_path,Y.directory_path2
from
(
    select base_query.cmid,
    base_query.pcmid,
    base_query.reportname,
    1 as Hlevel,classid,
    base_query.reportname as directory_path
    from base_query where reportname = 'My Folders'
) x
inner join 
(
select cmid,
pcmid,
reportname,
classid,
reportname as directory_path2
from base_query
) y on x.cmid=y.pcmid
left join CMOBJPROPS33 ow1 
    on x.PCMID=OW1.CMID
left join CMOBJPROPS33 ow2 
    on y.PCMID=ow2.CMID
order by OW1.NAME

[Suraj]

If you use BSP Metamanager, there is simple search to find users with My Folders contents.

[TheBrenda]

The script is really helpful, thanks. Realize I am jumping on another post, but, ... any idea how to do something like this for reportnet 1.1.?

[kommireddy]

This is very useful script, thanks to Rahul. Is it possible to query and show reports under sub-folder under My Folders?

[TheBrenda]

Have you tried to substitute "reportname = 'My Folders'" with your folder name?

[Summer]

Even though this is an old post, i still want to thank you MFGF, your script is really helpful. I just need to change mapdlocaleid to work in my environment.

[MFGF]

Even though this is an old post, i still want to thank you MFGF, your script is really helpful. I just need to change mapdlocaleid to work in my environment.

Thanks - but it isn't my script :) It was posted up by Rahul Ganguli so he is the one deserving of your thanks. He posted it as an attachment (which a few people struggled to get access to) so I simply posted the contents directly into the thread. That's the extent of my contribution here.

Cheers, and thanks (for posting up a nice thank-you) :)

MF.

[AnuElza]

Works like a charm! :D