Support Tip: Changes in All devices list and reporting in Intune

[Intune_Support_Team]

We announced a few months ago that a new reporting framework was coming to Intune and now we’ve revamped the All devices list as part of what we announced. There is now an improved searching, sorting and filtering experience in the All devices list with better performance. 

As part of the work to make this new improved feature possible, there are a few changes we’ve had to make and a few issues we’re working on that we’d like you to be aware of:  

•  All device list exports will now be delivered in a .zip file format containing a single .csv file. If you have been using automation to export data from the All devices list, you can update those scripts to include extracting data from a .zip file. The Expand-Archive cmdlet can extract files from a specified zipped archive file to a specified destination folder. 

• We’ve received reports of the last check-in datetime not being understandable in Excel.   The .csv export has a space between the date and time instead of a comma and is now shown in UTC format.  The .csv format for the Last Check-in is “YYYY-MM-DD HH:MM:SS.sssssss”, for example  "2020-03-08 17:10:10.4438071". In Excel, you can change the column cell format to display Date and time in the format you desire. 

• There was an issue with all columns being exported regardless of filter selection in the new reports. Now if you select 5 columns of data to be exported, only those 5 columns will show in your report. 

• Reports from the new All devices list are missing two columns – “Device action” and “AzureAD registered”. We’ll update the post when this issue is fixed. 

• In the column for OS, Android enterprise is not subcategorized and MacOS is broken down to Mac OS X and OS X only. This issue is now being fixed to add more granularity to categories. 

• The values for Compliance evaluation are being updated to match in the console and in reporting. The value in reports which shows as “Unknown” will be changed to “Not evaluated” to match the value in the console UI.  

We’ll keep updating this post as some of these bugs are fixed. Let us know if you have any questions!  

[MaxM]

Another nice addition is the "Showing X to Y of Z records" summary at the top of the list!

Thank you! These changes are very much welcome!

There's another small issue though: When exporting a filtered list (eg. Jailbroken=Yes) the export file contains all device records rather than only the filtered list of devices. The same issue occurs when exporting lists from the "By platform" devices area, such as only "macOS devices."

[Jan Bakker]

Suggestion: It would be nice if your previous selected columns would be remembered. Now it's being reset at each session.

Question: Is there a PowerShell command to trigger this specific export feature? 

Thanks.

[JamesHeathcote]

Please can you add Total Physical RAM as a column, it is visible in Hardware properties.  We need to ensure all our devices are the same spec, some upgrades have been performed and on the old Silverlight portal it was easy to find this information.  It's great you added Model and Make to the columns, as well as free space and total storage, but RAM is also needed by organisations.

Kind regards

[Intune_Support_Team]

@MaxM, we've followed up with engineering, and this has been fixed. If you're still experiencing this behaviour, could you private message us with additional details for us to investigate?

@Jan Bakker, the ability to save columns is in the backlog. Though we don't have an exact ETA to share at this time, it's coming!

Regarding PowerShell, could you expand on this suggestion over on our UserVoice?

@JamesHeathcote, thanks for the feedback! Additional device inventory properties will be available using the Intune Data Warehouse, and the following properties (Including memory) will be exposed via the devices collection with the 2003 Intune Service release:

• Storage capacity
• Memory capacity
• Office 365 version
• Device model