Intune: Reporting Part 1 – create basic inventory report directly from Intune Console

I am a ConfigMgr consultant by heart where I have spent most of my IT-career designing and building ConfigMgr Solutions for customers. And everyone that has worked with ConfigMgr knows that you can report on basically anything from the clients managed by ConfigMgr. If you don’t see the data, the reason is probable that the the Agent is not configured to harvest it.

Well for the past 3-4 years I have also been working with Intune where the reporting capabilities has been a bit limited, especially devices managed through mdm, however the reporting has capabilities been greatly improved over the last couple of years. And I was thinking of doing a two-parted blog post to quickly show what you can do in the Azure Intune Console, and when you need something more advanced like PowerBi.

Let’s take take a look at what you can do with the basics.

Start by logging on to the new Azure portal (we will not use the old portal). Then when you have logged in to the portal go to the Intune Blade and then click on devices.

Then move along over to All Devices

It is in this view where you have the possibility to create some “basic reports”.

Here is an example where I have filtered on my Windows Devices that has not checked-in with Intune in over 1 month and I have added the column Encryption to see if the devices is Encrypted.

Then when you export the data you will download a CSV-file in which you can open with Excel for further configuration and adjustments.

Then to separate the tabs mark column A and go to

Choose Delimited and click next.

Choose comma and click next.

On the last screen click finish.

Now, it’s done and you have organized your columns and tables.
!!NB!!: I do not know if it’s a bug or feature, but when you export the data from Intune it includes all columns even though you have just specified a certain set of columns to be exported. I have provided feedback on this on UserVoice and hope to get some feedback soon. Feeback posted here:

This was a quick look at the basic capabilities in Intune. Now, you have more advanced options with Intune Data Warehouse and PowerBi which we will look at in Part 2.

Stay tuned. 🙂

By |2017-11-13T00:23:52+00:00October 31st, 2017|Azure, Enterprise Mobility Suite (EMS)|2 Comments

About the Author:

Marius A. Skovli
Microsoft Enterprise Client Management Evangelist with: 10+ years experience within Microsoft System Management Solutions Extensive experience across Private and Public Sector Passion for Community Driven work, volunteering within Microsoft technology Great belief that sharing experience within fellow peers is key to creating a sustainable society Strong commitment to System Center User Group Norway as co-founder and current leader I am a technology enthusiast working as a consultant for the consultant company CTGlobal. I have always been passionate about IT and have the last 10 + years worked with Management and Automation within Microsoft technology. Back in 2005/6 I started working with System Management Server (SMS) 2003 and have been working with Enterprise Client Management ever since, where i today focus on helping customers design and implement solutions based on System Center Configuration Manager and/or Enterprise Mobility Suite from Microsoft. Other parts of my work consists of speaking and presenting at different events and seminars, doing research and blog about solutions I find and products I work with. I truly believe in a strong community where knowledge and know-how is essential. Creating creative arenas where it is possible for peers to spread the word about new technologies and solutions is key and as an act on this I co-founded System Center User Group Norway ( SCUG is an initiative where we discuss, preach and present new technologies and solutions in the System Center Space from Microsoft. This is a free arena for everybody to join that is interested in/or enthusiastic about Microsoft Cloud Platform (Enterprise Client Management or Cloud and Datacenter). Specialties: System Center Configuration Manager (SCCM2007-SCCM2012), Enterprise Mobility and Intune, Windows and Windows server deployment.


  1. chauffagiste 92 November 7, 2017 at 9:51 - Reply

    j’avais le plaisir de visiter le blog. Bonne continuation

  2. Greg April 4, 2018 at 18:57 - Reply

    thank you for the article Marius, any idea why my Security Patch Level column is empty and the Device Threat Level column shows Unknown. I mean those are like the two most useful pieces of information I wanted to see, the rest is trivial.

Leave A Comment