How to get Report path from content store tables....

[Grim]

Sir Grim,

I hereby bestow on you the title of Honorary Master of IBM Links.

Sweet!

[cccschip]

I believe this is the query (in Oracle) that was desired...

    select cmid, objname, SYS_CONNECT_BY_PATH(o.objname, ' > ') path
    from (
           select obj.CMID CMID, case when obj.cmid = obj.pcmid then null else obj.PCMID end PCMID, nm.name objname
           from CMOBJECTS obj inner join CMOBJNAMES nm on obj.cmid = nm.cmid
           where nm.isdefault = 1
         ) o
    where objname like ''               -- <<<< Your object name here
    start with o.PCMID = 0
    connect by prior o.CMID = o.PCMID

[michal]

sorry to resurrect an old beast, but i'm curious

any way to get at the attached files discussed in this thread?  i cant seem to find them anymore :/
while the audit extension can be used, figuring out what reports in your portal are actually used or not is a chore.

how do i find what reports ARENT used anymore?

i find it rather disappointing that BI cant really audit itself very well.

edit : oooops, after logging in i was able to download the attachment.  sorry.!

Still, if anyone knows of a good way to audit unused reports / packages etc please share....

[mpradeep22]

Thank you Riley for your valuable script. I was able to use it and extend it a bit more to get the report path.

I only used the select statement since I didn't want to create tables. The catch in the code though is that you will need to know the maximum folder level in your system. So for e.g. your public or private folder is level 1 and thereafter it increments for every folder level. Below is what I did after establishing that we have 10 levels of folder in our system.

You will have to filter out the report paths being null to get what you want. To expand the script's scope to even more levels just add additional levels to the the select, from and where clauses (the script is intiuitive for sql folks). Feel free to post if you have any questions!
* Report path.txt (7.42 kB - downloaded 80 times.)

thank you very much subash, for your valuable information..... it helps me alot...

can I get the user name of the particular report in the same query???

Thanks inadvance

[riley.murphy]

Are you asking about the report owner/creator?

[mpradeep22]

Are you asking about the report owner/creator?

Yes Riley..... exactly.

i need to include the owner of the report also into the same querey

Thanks in advance

[stummala]

I have added the package name and author name to the query.

[Ravisha]

I have added the package name and author name to the query.

Why I'm not able to download the attached file?