Question:

How to get a list of shared reports from the WF repository that includes the following 

• User Id who shared the report

• User ID and/or Group the report was shared with

• Domain Name for report

• Report Title

• Report Name

Solution:

Step 1: Create an Adapter get access to your WebFOCUS repository

Video tutorial shows you how to create an Adapter for the WebFOCUS repository - https://www.youtube.com/watch?v=ONtMB9ND1Qk&t=60s

Step 2: Below is the procedure code to get to the shares from WF_REPOSOBJ as it exposed the SHARES column in the  UOA_RESOUCES using Join.

JOIN CLEAR *
JOIN OBJNAME IN WF_REPOSOBJ TO NAME IN UOA_RESOURCES AS JOIN1
JOIN ID IN WF_REPOSOBJ TO ID IN UOA_PRIVATESHARES AS JOIN2
TABLE FILE WF_REPOSOBJ
PRINT *
WHERE PRT_PATH CONTAINS 'adminsuser'
WHERE RECORDLIMIT EQ 500
END