Need help with package report

I am interrested in a report that would show all advertisements that are not advertised or used in a Task Sequence or Software Update deployments.  This would help me to find packages that aren't being used to help free space on DPs.
 
I feel that I am close with the following but feel I am missing something or not creating efficiently.  Any help would be appriciated.
 
SELECT DISTINCT
                      v_Package.Name AS C062, v_Package.Description, v_Package.SourceSite, v_Package.PackageID,
                      v_Advertisement.AdvertisementID, v_TaskSequencePackage.Name AS 'TSName',
                      CASE v_Package.Packagetype WHEN 0 THEN 'Software Distribution Package' WHEN 3 THEN 'Driver Package' WHEN 4 THEN 'Task Sequence Package' WHEN 5 THEN
                       'Software Update Package' WHEN 6 THEN 'Device Settings Package' WHEN 7 THEN 'Virtual Package' WHEN 257 THEN 'Image Package' WHEN 258 THEN 'Boot Image Package'
                       WHEN 259 THEN 'OS Install Package' END AS PackageType
FROM         v_Package LEFT OUTER JOIN
                      v_TaskSequencePackage ON v_Package.PackageID = v_TaskSequencePackage.PackageID LEFT OUTER JOIN
                      v_Advertisement ON v_Package.PackageID = v_Advertisement.PackageID LEFT OUTER JOIN
                      v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID
WHERE     (v_Advertisement.AdvertisementID IS NULL) AND (v_TaskSequencePackage.Name IS NULL) AND (v_Package.PackageType = '0')
ORDER BY C062

 
Yes, I know this is an old post, I’m trying to clean up older posts that are unanswered.
Did you ever figure this out?
 
After my quick look at this query and the query look fine.