Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Kristi Carter

Recommended Posts

  • 9 months later...

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...