Query Description:

Show Manufacturer, Model, Serial and OS details of all devices in the environment.

Query Results:

Query:

select distinct DE.DeviceName, DI.DeviceId, FO.FolderName, DI.Manufacturer, DI.Model, DI.SerialNumber, DI. OperatingSystemName, DI.OperatingSystemVersion from DeviceInventory DI
inner join Devices DE on DI.DeviceId = DE.DeviceId
 inner join Folders FO on DE.FolderId =FO.FolderId
 order by DE.DeviceName