SQL Query : All Win10 Machines with User Details / OS Ver / OS LangID

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