Win 10–Handy ConfigMgr SQL Query

Here is a quick little SQL query which comes in handy for mapping Win 10 build versions to releases.  All of the additional data is stored inside of a few tabled valued functions in the CM database.

SELECT TOP 100 s.name0, os.Caption0, ss.Build, ln.Value From v_r_System s 
INNER JOIN v_GS_OPERATING_SYSTEM OS on s.ResourceID=os.resourceID 
join (Select * from fn_GetWindowsServicingStates() where branch = 0) ss on os.Version0=ss.Build
join fn_GetWindowsServicingLocalizedNames() ln on ss.Name=ln.Name Where os.Version0 like '10%'

Leave a comment