Where could I find within the Repository Tables or the Resou...

[Kristi Carter]

Where could I find within the Repository Tables or the Resource Analyzer Tables where to identify anything that has been shared and who it has been shared within under the My Content area

[Manoj Chaurasia]

Kristi

This is an excellent question and I cant find anything in the repository that relates to sharing. Resource Analyzer is only about report execution so it doesnt have it either. I think this is a question for techsupport.

[Kristi Carter]

Thanks Chuck for looking. I have already tried tech support, but did not get a resolution. Hoping that someone else has come across this and can provide some insight.

[Debra Waybright]

@kristi.carter Did you ever get a resolution to this I find myself now in a position where I also need to get this data. I see there are some tables in 8203 that seem to have the data if I can figure out how to link them together.

[Kristi Carter]

Unfortunately there was no resolution and not a way to do this.

[Debra Waybright]

Bummer. I played a bit with the UOA tables but was unable to get a complete list. It sure seems like there should be a way to do this.

[Kristi Carter]

I agree. I wish there was. Maybe if either of us do figure out a way, we can keep each other posted.

Thanks,

Kristi

[Martin Yergeau]

I dont know if this will work for you, but it seems to list the shared content and people shared with

SELECT R.[NAME] AS 'FexName',

CASE WHEN SHAREIDTYPE = 'U' THEN 'User' ELSE 'Group' END AS 'SharingType',

CASE WHEN SHAREIDTYPE = 'U' THEN U.DESCRIPTION ELSE 'All' END AS 'SharedWith'

FROM [dbo].[uOA_RESOURCES] R

INNER JOIN [dbo].[uOA_PRIVATESHARES] PS

ON R.ID = PS.PRIVATEID

LEFT JOIN [dbo].[uOA_USERS] U

ON PS.SHAREID = U.ID

WHERE PS.SHAREDATE IS NOT NULL

[Debra Waybright]

MartinY:

 

SELECT R.[NAME] AS FexName, CASE WHEN SHAREIDTYPE = U THEN User ELSE Group END AS SharingType, CASE WHEN SHAREIDTYPE = U THEN U.DESCRIPTION ELSE All END AS SharedWith FROM [dbo].[uOA_RESOURCES] R INNER JOIN [dbo].[uOA_PRIVATESHARES] PS ON R.ID = PS.PRIVATEID LEFT JOIN [dbo].[uOA_USERS] U ON PS.SHAREID = U.ID WHERE PS.SHAREDATE IS NOT NULL

 

 

Martin,

Thanks for that! It got me a much more complete list than the SQL I was trying did!

[Kristi Carter]

Awesome - Thanks. I will give it a try and see how it goes.