Here are the Best Practices for upgrading to the latest Windows Feature update.
Here is a guide from Symantec on how to utilize Software Management Solution to perform upgrade - KB 178784
Here is a guide how to perform OS Feature Upgrade via Patch Management Solution - KB 184951
If your systems have encryption enabled on them, please review this guide, describing proper steps for the upgrade - KB 179017
Also, please review the following guide to know what to do, in case if your upgrade runs into problems - KB 163060
1. 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.