SCCM Client Push Installation Status Using SQL Query | ConfigMgr

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

Client push installation is one of the easiest methods to install the 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 the SCCM client manually on a Windows 10 machine.

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

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

Patch My PC
Index
SQL Query
Results – SCCM Client Push Installation Status Using SQL Query
Stored Procedure for Client Push Method
Video Recording
SCCM Client Push Installation Status Using SQL Query | ConfigMgr – Table 1

SQL Query

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

First, Open the SQL Management Studio and click the New Query button. Then, select the CM_MEM database from the drop-down menu. MEM is the ConfigMgr site code.

Adaptiva
  • 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 - Fig.1
SCCM Client Push Installation Status Using SQL Query | ConfigMgr – Fig.1

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 are important for understanding the retry.

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 – Table 2

Stored Procedure for Client Push Method

Let’s understand the stored procedures that are used as part of the ConfigMgr client push installation method. The following is the list of stored procedures associated with the 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
SCCM Client Push Installation Status Using SQL Query | ConfigMgr - Fig.2
SCCM Client Push Installation Status Using SQL Query | ConfigMgr – Fig.2

Video Recording

The video below provides a step-by-step tutorial on installing clients.

SCCM Client Push Installation Status Using SQL Query | ConfigMgr – Video guide

Resources

We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

Author

Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.

2 thoughts on “SCCM Client Push Installation Status Using SQL Query | ConfigMgr”

Leave a Comment

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