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 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 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
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 to understand the retry and other things.
Description | Number of Process Attempts | Error Event Created | Status |
Machine ID | Name | Latest Processing Attempt | Last Error Code | Push Site Code | Assigned Site Code | Initial Request Date | Description | Number of Attempts | Error Event Created | Status |
---|---|---|---|---|---|---|---|---|---|---|
16777219 | HTMDSCCM | 17:41.0 | 0 | HT1 | HT1 | 17:30.7 | Complete | 1 | NULL | 4 |
2097152002 | HTMDWIN10 | 00:52.0 | 5 | HT1 | HT1 | 00:41.9 | Retry | 1 | NULL | 2 |
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
Video Recording
Resources
- How to Perform SCCM AD Discovery Install SCCM Client
- Windows Firewall and port settings for clients in Configuration Manager
- ConfigMgr Client push installation
Hi Anoop,
i required all SCCM from basic Videos for a fresher as well as experience
Thanks
It’s already there isn’t it Free SCCM Training – Episodes – HTMD Community https://www.youtube.com/playlist?list=PL67vGzo-INWMBo3KlARUHIU2kPyRc1gw1 via @YouTube