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 https://portal.azure.com (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: https://microsoftintune.uservoice.com/forums/291681-ideas/suggestions/32083999-all-columns-is-included-when-you-export-data-from


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:00 October 31st, 2017|Azure, Enterprise Mobility Suite (EMS)|1 Comment

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 (www.scug.no). 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.

One Comment

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

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

Leave A Comment