Because we want to able filter by these Admin categories to show the number of them i think he want that.
the raw report is with only show the complete pakage;
select pk.name, psu.PackageID, psu.ServerNALPath as 'DistributionPoint' , psu.InstallStatus as 'status'
from v_PackageStatusDistPointsSumm psu inner join SMSPackages pk
on psu.PackageID=pk.PkgID
where psu.InstallStatus like 'Package Installation complete'
order by pk.Name asc
But we will be satisfied with the package name, pk id, site code of dp, pk size, pk status (failed,pending,complete) and the admin categories and order by admin categories.