Share via

Useful Query to check DP status of all the content targeted to a specific DP or multiple DPs

  • Article

select pk.PackageID, pk.Name, ps.InstallStatus, 
case (pk.ObjectTypeID) 
When 2 Then 'Packages'
When 14 Then 'System Upgrade Packages'
When 18 Then 'Golden Images'
When 19 Then 'Boot Images'
When 20 Then 'Task Sequences' 
When 23 Then 'Drivers' 
When 24 Then 'Update Packages' 
When 31 Then 'Applications'
End as Type , DPSI.Name as 'DP Name'  from v_Package pk join v_PackageStatusDistPointsSumm ps
join vSMS_DPStatusInfo DPSI on DPSI.NALPath=ps.ServerNALPath
on ps.PackageID=pk.PackageID where DPSI.Name in ('DP NAMES') order by DPSI.Name