Let’s quickly find out whether SCCM secondary server hotfix installation status with a SQL query. It’s not very easy to find out whether ConfigMgr secondary server got the latest hotfix installed or not.
Introduction
Before getting to the details of the SQL query that can help you to find out the status of hotfix installation, let’s understand the real issue here.
You can check the version of Configuration Manager sites from the console itself. However, the issue is hotfix installation never changes the build & Rev version numbers so there is no option to find out whether the latest hotfix is installed on the secondary server or not.
- \Administration\Overview\Site Configuration\Sites
The site server build and rev version numbers change when you upgrade SCCM from 2006 to 2010. You can read more about ConfigMgr Version Numbers | Major Minor Build Rev of SCCM.
Check Status of Secondary Server Hotfix Installation
Now, let’s find out the way to check the status of secondary server hotfix installation using SQL query.
- Open the SQL Management Studio.
- Connect your Database Engine.
- Right Click on your database CM_XXX and click on ‘New Query’
- Copy the following SQL query to find the status of the SCCM secondary server hotfix installation status.
- Click on the Execute button.
NOTE! – HS0 is a secondary site code. You need to replace this with your own secondary site code.
select dbo.fnGetSecondarySiteCMUpdateStatus ('HS0')
- If the return value is 1, that means hotfix is installed successfully.
Resources
- SCCM Secondary Server Installation Failed Error | ConfigMgr | Fix
- List of prerequisite checks for Configuration Manager
- Add SCCM Server Computer Account to SQL Login Sys Admin Access
Author
Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management 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. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…
Hi Anoop, what about Update Status value=3 ?
It’s always 3 at my sites and i cannot find any information about it…
Thank you and best regards!