Use this query to list all Windows 10 devices including the user, the OS version and the OS language ID. SELECT DISTINCT dbo.v_R_System.Name0 AS MachineName, dbo.v_R_System.User_Domain0 AS UserDomain, dbo.v_R_System.User_Name0 AS UserName, dbo.vSMS_R_System.operatingSystemVersion0 AS OSVersion, dbo.v_GS_OPERATING_SYSTEM.OSLanguage0 FROM dbo.v_R_System INNER JOIN dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID INNER JOIN dbo.v_GS_OPERATING_SYSTEM on dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_R_System.ResourceID INNER JOIN dbo.vSMS_R_System ON dbo.v_R_System.Name0 = dbo.vSMS_R_System.Name0 WHERE vSMS_R_System.Operating_System_Name_and0 like ‘%Workstation 10%’ order by v_R_System.Name0 Sample Output
Read More