SCCM Client Push Installation Status Using SQL Query | ConfigMgr

2
SCCM Client Push Installation Status Using SQL Query

Let’s check the SCCM Client SCCM Client Push Installation Status Using SQL Query. You can use different methods to install the ConfigMgr client software. I have an article describes client push installation status using SQL query.

Client push installation is one of the easiest methods to install SCCM client on a Windows 10 device. The Client installation process is explained via superflow in the article Troubleshoot SCCM Issues with SuperFlow. Learn how to install SCCM client manually on Windows 10 machine.

Learn more about Client push installation from the following post “Install ConfigMgr Client Using Client Push Installation Method“.

NOTE! – Configuration Manager tries to install the client on all discovered resources. It retries any failures for up to seven days.

SQL Query

Once you have initiated the client push installation method. You can track the status of the client push installation using the following query.

  • Open the SQL Management Studio.
  • Click on the New Query button.
  • Select the CM_MEM database from the drop-down menu.
    • MEM is the ConfigMgr site code.
  • Copy the following SQL query to find the client push status.
  • Click on the Execute button.
Select * from V_CP_MACHINE
SCCM Client Push Installation Status Using SQL Query ConfigMgr
SCCM Client Push Installation Status Using SQL Query ConfigMgr

Results – SCCM Client Push Installation Status Using SQL Query

Following is the result of the SQL query to find out the status of the client Push Installation! The columns highlighted in the first table is important to understand the retry and other things.

DescriptionNumber of Process AttemptsError Event CreatedStatus
Machine IDNameLatest
Processing
Attempt
Last Error CodePush Site
Code
Assigned
Site
Code
Initial
Request
Date
DescriptionNumber of AttemptsError Event CreatedStatus
16777219HTMDSCCM17:41.00HT1HT117:30.7Complete1NULL4
2097152002HTMDWIN1000:52.05HT1HT100:41.9Retry1NULL2
SCCM Client Push Installation Status Using SQL Query ConfigMgr

Stored Procedure for Client Push Method

Let’s understand the stored procedure that are used as part ConfigMgr client push installation method. The following is the list of stored procedures associated with client push installation method.

  • sp_CP_CheckNewAssignedMachine
  • sp_CP_Collection
  • sp_CP_DeleteOldMachine
  • sp_CP_FindMachineSite
  • sp_CP_FindResourceSite
  • sp_CP_GenerateCCRByName
  • sp_CP_GetNewPushMachines
  • sp_CP_GetPushMachineName
  • sp_CP_GetPushRequestMachine
  • sp_CP_GetPushRequestMachineIP
  • sp_CP_GetPushRequestMachineResource
  • sp_CP_Machine
  • sp_CP_Query
  • sp_CP_SetLastErrorCode sp_CP_SetLatest
  • sp_CP_SetPushRequestMachineStatus
  • sp_CP_StatusDetail
  • sp_CP_StatusDetail_AllSites
  • sp_CP_StatusPercent
  • sp_CP_StatusPercent_All
  • sp_CP_UpdateMachineResource
ConfigMgr Client Push Installation Status Using SQL Query SCCM
ConfigMgr Client Push Installation Status Using SQL Query SCCM

Video Recording

Resources

2 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.