Computer objects issue after 1902 > 1910 update

Question

Hi,

Today I updated my SCCM instance from 1902 to 1910. The update was successful. I updated SQL 2012 native client to the recommended version on the SCCM server itself.
I also have a separate SQL server that hosts the main SCCM database - I have not updated the native client version on this and it's still running the same version that the SCCM server was before the update.

I've noticed that any devices imaged after the update register in SCCM, however no client activity populates, they do not get put in query based collections, and Software Centre isn't actively updating/removing apps based on deployments (Even after a manual policy refresh).

I've just installed the hotfix for 1910 hoping this is the fix. I've also just installed the same SQL 2012 native client version on the SQL server.

Any ideas if this will fix the issue, or what the issue could be?

Thank you!

Answer 1

Hi,

Thanks for posting in Microsoft MECM Q&A forum.

1.Have you encountered the SQL Server Native Client version Warning while the SCCM upgrade process? If yes, please refer to below link to determine whether your current version of SQL Server already has support for TLS 1.2 and needs upgrade Microsoft SQL Server 2012 Native Client:
TLS 1.2 support for Microsoft SQL Server

2.SMS_CLIENT_CONFIG_MANAGER component records activities for client push installation, and the related log is ccm.log.
SMS_REST_PROVIDER monitor service health state for the SMS Provider administration service REST API, and the related log is SMS_REST_PROVIDER.log.
SMS_DATABASE_NOTIFICATION_MONITOR records database changes, and the related log is smsdbmon.log.
Please help check above logs to see if there is any detailed information.

Best regards,
Simon

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.