Share via

Check for free Disk Space available on Distribution Point

  • Article

Query showing available Disk Space on Distribution Point

Here is an easy query to check for the available Disk Space on Distribution Point. This query will show you if Disk Space > 500 MB.

select distinct  pkg.Name, pkg.Version,pkg.SourceSize/1024 as  "Size in MB", Pkg.SourceDate, COUNT(status.PackageID) as  "DP Count" from  smspackages pkg join  v_PackageStatus status on pkg.PkgID=status.PackageID
where status.Type=2 and pkg.SourceSize/1024>500 and pkg.PackageType=0
group by  pkg.Name,pkg.Version,pkg.SourceSize/1024,pkg.sourcedate
having COUNT(status.packageid)>50
order by  pkg.sourcedate desc

http://c.statcounter.com/9828603/0/83e3093d/0/