To export Device Manager information to a spreadsheet:
From Device Manager, click Device fleet at the top.
Click Export device table.
The downloaded spreadsheet will contain the following information for each device in your fleet:
Serial number
Status
Group
Device type
OS version of the device