SQL Query : All Devices with W10 Build Version

Simple query to return the different W10 versions you may have in your environment.

SELECT dbo.System_DATA.Name0
   ,dbo.Operating_System_DATA.MachineID
   ,[Caption00]
   ,[BuildNumber00]
   ,[Version00]
FROM dbo.Operating_System_DATA
   JOIN dbo.System_DATA on Operating_System_DATA.MachineID = dbo.System_DATA.MachineID
WHERE Caption00 like '%Windows 10%'
order by Name0

Related posts

Leave a Comment