SQL Script - Device Details

Manufacturer, Model, Serial Number, OS details

Written by Ines

Last published at: January 27th, 2023

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