SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr

SCCM Client Push is connecting to the client and assigned to another primary configuration manager, ConfigMgr. Client push is still confusing when you have an SCCM hierarchy with CAS and Primary servers.

Neil Peterson discussed the Standalone primary server-client push scenario in his post here. However, when you’ve hierarchy with SCCM 2012 CAS and Primaries, the SCCM client push scenario is slightly different.

I stumbled across a scenario where we’ve enabled the client push on an SCCM primary server, and as per the CCM.log, it was trying to connect to the sccm client in another primary site.

In this post, you will get all the details of the SCCM Client Push, which connects the client assigned to Another Primary site. Several factors could be at play when encountering the issue of SCCM Client Push connecting to a client assigned to another primary site.

Patch My PC
Index
SCCM Client Push is Connecting to the Client Assigned to Another Primary?
Why is My Primary Server Trying to Connect to the Clients Assigned to Other Primary Sites?
Why Does the V_CP_Machine View Contain All Machines in the SCCM Hierarchy?
What is the Content of the View “V_CP_Machine”?
How Do I Delete the Client Records from the Client Push Method “V_CP_Machine”?
Where can I Find the Details of the Stored Procedures used for Client Push Installation?
SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr – Table 1

SCCM Client Push is Connecting to the Client Assigned to Another Primary?

Is this normal behavior? How is the ConfigMgr client push enabled in a primary site trying to install a client assigned to another primary site in the hierarchy?

The scenario is “Discovery and the site-wide client push installation method enabled on primary site; however, Site-wide Client push is disabled on other primary sites.”

SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr - Fig.1
SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr – Fig.1

SCCM client push has been enabled on a specific primary server, and the client push account specified in that primary site is trying to connect all the machines listed in the view called “V_CP_Machine“.

V_CP_Machine contains all the discovered resources assigned to the site that do not have a client installed. Client push installation starts and tracks the client’s installation using the Configuration Manager database and no longer creates individual CCR files.

Why is My Primary Server Trying to Connect to the Clients Assigned to Other Primary Sites? 

As mentioned above, in SCCM 2012, client push is not based on individual CCR files. Rather, it is based on the SQL DB view V_CP_Machine. When I checked the V_CP_Machine in my primary server DB, it showed the list of machines (clients) assigned to other primary sites in my hierarchy.

Hence, my primary server is trying to connect to the machines listed in V_CP_Machine.

Why Does the V_CP_Machine View Contain All Machines in the SCCM Hierarchy?

The V_CP_Machine SQL view is related to a table called “ClientPushMachine_G.” This table (Article Name) is part of the Global data replication pattern, and the replication group name is Configuration Data.

You must know that GLOBAL data is replicated all over the hierarchy, so that is why having the same list of machines in V_CP_Machine view all around the SQL DBs(Primary servers and CAS server).

My post, “FAQs Related to SCCM 2012 SQL Database Replication“, explains more details about replication patterns, groups, and article IDs.

What is the Content of the View “V_CP_Machine”?

The table below (SCCM view) shows the “Last Error Code” detail against each client record. These details could be beneficial for troubleshooting SCCM client Push issues.

SCCM client push error codes are nothing but Windows Error codes. Details of Windows error codes are available in the TechNet documentation here.

SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr - Fig.2
SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr – Fig.2
[table caption=”V_CP_Machine” class=”table table-bordered” ai=”1″ width=”400″ colwidth=”150|50|300″ colalign=”left”]
MachineID,Name,LatestProcessingAttempt,LastErrorCode,PushSiteCode,AssignedSiteCode,InitialRequestDate,Description,NumProcessAttempts,ErrorEventCreated,Status
16777479,ACNCMClient,2015-03-06 12:30:41.000, 53, PRI, PRI, 2015-02-27,13:12:56.880, Retry, 169, NULL
[/table]



How Do I Delete the Client Records from the Client Push Method "V_CP_Machine"?

 As mentioned above, the V_CP_Machine SQL view is related to a table called ClientPushMachine_G. You can delete the records from the table if you're in a critical situation. However, directly editing the SCCM SQL DB is not supported. I can see 3 DRS Stored procedures in SQL related to client push.

I hope one is to delete the Client Push Machines, another is to Handle the Unique Key of client push machines, and the third is to upgrade client Push Machines. So, what is DRS? Data replication Service.

SCCM_DRS.spDeleteClientPushMachine_G
SCCM_DRS.spHandleUniqueKeyClientPushMachine_G
SCCM_DRS.spUpsertClientPushMachine_G

SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr - Fig.3
SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr - Fig.3

Where can I Find the Details of the Stored Procedures Used for Client Push Installation?

The stored procedure details are in the CCM.log file. Following are the Stored Procedures I can see in the SCCM 2012 DB related to Client Push.

Stored Procedures I can see in the SCCM 2012 DB related to Client Push
sp_CP_DeleteOldMachine
sp_CP_FindMachineSite
sp_CP_FindResourceSite
sp_CP_GenerateCCRByName
sp_CP_Machine
sp_CP_Query
sp_CP_StatusDetail
sp_CP_StatusDetail_AllSites
sp_CP_StatusPercent
sp_CP_StatusPercent_All
SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr - Table 2
SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr - Fig.4
SCCM Client Push is Connecting to the Client Assigned to Another Primary Configuration Manager ConfigMgr - Fig.4
Getting a new request from queue "Retry" after 100 millisecond delay. $<03-17-2015 22:28:23.073-480><thread=11344 (<span="" class="hiddenSpellError" pre="" data-mce-bogus="1">0x2C50)>
Found CCR "2097909935.ccr" in queue "Retry". $<03-17-2015 22:28:23.073-480><thread=11344 (0x2c50)="">
Execute query exec [sp_CP_GetPushRequestMachine] 2097909935~ $<03-17-2015 22:28:23.223-480><thread=11344 (0x2c50)="">
Successfully retrieved information for machine ACNCLient2 from DB $<03-17-2015 22:28:23.231-480><thread=11344 (0x2c50)="">
Execute query exec [sp_CP_GetPushRequestMachineIP] 2097909935~ $<03-17-2015 22:28:23.231-480><thread=11344 (0x2c50)="">
Execute query exec [sp_CP_GetPushRequestMachineResource] 2097909935~ $<03-17-2015 22:28:23.325-480><thread=11344 (0x2c50)="">
Execute query exec [sp_CP_GetPushMachineName] 2097909935~ $<03-17-2015 22:28:23.346-480><thread=11344 (0x2c50)="">

Resources

SCCM Video Tutorials For IT Pros - HTMD Blog #2 (howtomanagedevices.com)

We are on WhatsApp now. To get the latest step-by-step guides, news, and 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 main focus is on 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.

Leave a Comment

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