SQL Script - Device Details
Manufacturer, Model, Serial Number, OS details
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