DB Query to know the shared assets with Sites

3607075

Hi,

I want to know using SQL query or table names, to find for below assets which are shared with other sites.

1) Blogs

2) CSElements

3) Templates

Thanks,

Santosh 

Nirav Varma

table is AssetPublication which holds the information. for more details: https://docs.oracle.com/middleware/1221/wcs/admin/GUID-5C024B52-32D1-4394-BA96-CD8BB33E1A6C.htm#WBCSA585