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...
  • TO fix the SMS client GUID issue
    How to fix the SMS client GUID issue 1.If the client status unknown in the SMS console after installing the SMS client (make sure that ...
  • DP Content checking
    --DP content status: use sms SELECT     v_PackageStatusDistPointsSumm.PackageID,                       v_Package.Name, v_PackageStatusDi...