Thursday, July 9, 2015

query to see package status in numbers

SELECT
DPSI.Name, DPSI.NumberInstalled, DPSI.NumberInProgress, DPSI.NumberErrors, DPSI.NumberUnknown
FROM
vSMS_DPStatusInfo DPSI
WHERE (
DPSI.NumberErrors > 0 OR
DPSI.NumberInProgress > 0 OR
DPSI.NumberUnknown > 0
)



and name like '%XXX%'
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SCCM to Tanium

SCCM transition Options: of course intune otherwise  Deployment, Patching - Tanium Image - Tazier Inventory - Tanium Remote Control - Zoom  ...

  • Pull Dp concept
    When a package is distributed to a PullDP, DistMgr creates a PkgXferMgr job and added to the queue. - PkgXferMgr processes the job and cre...
  • DP Content checking
    --DP content status: use sms SELECT     v_PackageStatusDistPointsSumm.PackageID,                       v_Package.Name, v_PackageStatusDi...
  • PowerShell script to check WDS Service status against of List of servers.
    Below is a PowerShell script, this will list WDS Service status against of List of servers. $InPutComputersList = get-content "c:\M...