Best Practices for Upgrading to the latest Windows Feature Update

Products

• IT Management Suite
• Client Management Suite
• Software Management Solution
• Patch Management Solution
• Deployment Solution

Issue/Introduction

This article provides the Best Practices for upgrading to the latest Windows Feature update.

Environment

ITMS 8.x

CMS 8.x

DS 8.x

Patch Management 8.x

Resolution

Here is a guide from Symantec on how to utilize Software Management Solution in KB article Upgrading to Windows 10 or upgrading an existing version of Windows 10 using Software Management Solution

Here is a guide how to perform OS Feature Upgrade via Patch Management Solution in KB article Deploying Windows 10/11 feature updates with Patch Management Solution

If your systems have encryption enabled on them, please review this guide, describing proper steps for the upgrade in KB article Upgrade computers encrypted with Symantec Endpoint Encryption to a Windows 10 release 

1. The following SQL Query can be used to list computers with OS details, including the OS Service Channel.

SELECT
  [Resource name] = isnull( os.[Name], item.[Name]),  
  os.[Domain],  
  os.[OS Version],
  CASE
   WHEN os.[OS System Mask] IS NULL THEN os.[OS Name]  
   ELSE dbo.fnSysMask_GetOSNumberNameEx(os.[OS System Mask])  
  END AS 'OS Name'
 from vRM_Network_Resource r   
  JOIN [vRM_Network_Resource_Item] item on item.[Guid] = r.[Guid]  
  LEFT OUTER JOIN Inv_AeX_AC_Identification os on os.[_ResourceGuid] = r.[Guid]   
  LEFT OUTER JOIN [Inv_AeX_AC_Location] lo on lo.[_ResourceGuid] = r.[Guid]  
  GROUP BY os.[OS System Mask], [OS Name],[OS Version],os.[Name], item.[Name] ,[Domain]

Example results:

Resource name	Domain	OS Version	OS Name
CL-Win7-x32	EPM	6.1	Windows 7
CL-W7-x64-01	EPM	6.1	Windows 7
CL-Win8-32	EPM	6.2	Windows 8
CL-Win8-64	EPM	6.3	Windows 8.1
CL-Win10-64	EPM	10.0	Windows 10
CL-Win2k-x64	EPM	6.3	Windows Server 2012 R2
SMP8-1	EPM	6.3	Windows Server 2012 R2
SQL-2012	EPM	6.3	Windows Server 2012 R2
SS-Win2012	EPM	6.3	Windows Server 2012 R2
CL-Win2016-x64	EPM	10.0	Windows Server 2016 (1607)
CL-Win10-32	EPM	10.0	Windows 10 (1803)
VM-100833210		7.4	CentOS Linux 7

2. Attached are documents with details on how to create a report showing the OS Build Number.