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

Related posts

Leave a Comment