Device Details

Manufacturer, Model, Serial Number, OS details

Written by Ines

Last published at: February 23rd, 2021

Query Description:

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

Powershell alternative (slower method): Export Device Details


Query Results:

Image_2021-02-23_13-02-16.png

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