This content has been marked as final. Show 2 replies
You can check PTPAGEGADGETS to see if a particular portlet ID is referenced by a page. Also, before you delete the portlet, you may want to go into the web service and on the Main Settings page disable the portlet with a message that it will be deleted, as well as where to contact you if someone still uses it and wishes to keep it around.
I use the following query to see what portlets are where:
SELECT communities.NAME AS COMMUNITYNAME, pages.NAME AS PAGENAME, gadgets.NAME AS PortletName
FROM PTPAGEGADGETS pagegadgets LEFT JOIN PTPAGES pages ON pagegadgets.PAGEID=pages.OBJECTID INNER JOIN PTGADGETS gadgets ON pagegadgets.GADGETID=gadgets.OBJECTID INNER JOIN PTCOMMUNITIES communities ON pages.FOLDERID = communities.FOLDERID
ORDER BY communities.NAME, pages.NAME ASC,gadgets.name asc
Hope this helps!