Posted by Eswar Koneti on October 3rd, 2012
Today I was looking at Packages to see how many packages are created without any distribution Points added. This might help you in identifying whether these packages are really needed to be in SCCM or
archive them. This below report will help you in achieving this.
select PackageID,Name,Version,SourceDate from v_Package where PackageID not in (select packageid from v_PackageStatusDistPointsSumm)
Note : Some packages might use just command line (script based) and they do not have any distribution Points . Double Verify them before you take any action)