Hi all,

We are using 8.0.07 and have Resource Analyzer and I'm looking for a way to identify reports that have been shared. Our users can share with specific people or groups and can also share universally. I've been searching all over trying to find the field or table in the RA tables that would have this designation but cannot find anything. Does this 'flag' exist? Is there a way to identify if and/or how the report is shared?

Thanks!

This message has been edited. Last edited by: TomS.,

You need to look in WF tables and not in RA tables. RA table will be maintained by WF server. Sharing details will be available in the table maintained by WF Client.

Check in below tables.
SELECT * FROM UOA_PRIVATESHARES;
SELECT * FROM UOA_RESOURCES;
SELECT * FROM UOA_USERS;

Thanks,
Ram

Hard to find a needle when you're looking in the wrong hay stack...

Thanks Ram, thats right were the information was.