SCCM query to find out packages selected Copy the content in this package to a package share on distribution Points

The following query will provide details of SCCM package Copy the content in this package to a package share on distribution Points is selected on package share settings;

******************************************************************
SELECT ContentID, ServerName, ServerPath, SiteCode, Version, URL, UpdateTime 
FROM ContentDPMap
WHERE(URL LIKE '\\%')
******************************************************************
More SCCM custom reports can be found here