SCCM Package Clean Up activity? When you Build SCCM in your Environment, you create lot of packages to deploy onto clients But later sometime, you get updated versions for it or no more in use.
Packages which are not in use resides in Database and occupies disk space on the source server as well on the Distribution Points.
As SCCM admin guy, you should look at package clean up activity once in year or so depends on the requirement.
For Packages which has no advertisements, look here http://eskonr.com/2012/10/sccm-report-software-distribution-packages-with-no-advertisements/
Use this report to list packages which are not used recently for 1 year based and it is filtered with its advertisement status. This will not get the packages which are used in Task Sequences.
If you have any packages which are not used for 1 year but still if they are part of Task Sequence, you won’t see the results.
A.AdvertisementName AS [Advertisement Name],
A.PresentTime AS Created,
MAX(CAS.LastStatusTime) AS [Last Time Used],
(SELECT COUNT(PkgID) FROM vPkgStatusSummaryDistPts WHERE PkgID = p.PackageID) AS [No of DP]
INNER JOIN v_Advertisement A ON P.PackageID = A.PackageID
INNER JOIN v_ClientAdvertisementStatus CAS ON A.AdvertisementID = CAS.AdvertisementID
(CAS.LastStateName != 'Accepted - No Further Status')AND
p.PackageID NOT IN (SELECT ReferencePackageID FROM v_TaskSequenceReferencesInfo) and p.Packagetype=0
(MAX(CAS.LastStatusTime) IS NOT NULL)
AND datediff(mm,MAX(CAS.LastStatusTime),getdate()-365) > 0