SQL Query - Get OS Edition, Version and Build number details in SCCM Database

Query:

--Windows Versions details
Select distinct SYS.Netbios_Name0 as HostName, OPSYS.Caption0 as "OS Edition", WSLN.Value as "OS Version", OPSYS.Version0 as "Version No", v_GS_OPERATING_SYSTEM.BuildNumber0 as 'Build Number', OPSYS.CSDVersion0 as "Service Pack"
from v_R_System SYS
join v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID 
JOIN v_FullCollectionMembership FCM on sys.ResourceID = FCM.ResourceID inner join v_gs_operating_system
on SYS.ResourceID=v_GS_OPERATING_SYSTEM.ResourceID
join fn_GetWindowsServicingStates() WSS
on WSS.Build = OPSYS.Version0 and WSS.Branch = SYS.OSBranch01
Join fn_GetWindowsServicingLocalizedNames() WSLN
On WSS.Name = WSLN.Name
--WHERE FCM.CollectionID = 'CMH00015'
order by SYS.Netbios_Name0

Result:

Thank You!

Share