How to create a Microsoft Office 365 Login Report

As an IT admin, you may have to create a Microsoft Office 365 login report to find out which user accounts are active. With this report, you will be able to identify inactive accounts and remove them, so your environment is not cluttered. You can learn more about offboarding here.

There are a few ways to create a Microsoft Office 365 login report. For example, you can use Microsoft Office 365 audit logs to do this kind of report. We will look at a few methods so you can decide which is best for your circumstances. The first method is the Microsoft Entra Admin Center.

You will now want to add a filter to your results by going to the filter button next to the search window. This will enable you to remove any disabled accounts as they should not be in the report. To do this, add the filter “account enabled” and click on the value “yes”. This will give you a list of all your enabled accounts.

With a large environment, you will have difficulty seeing all the accounts due to pagination issues. Also, you will have a lot of information that you don’t need and user accounts like service accounts or shared mailboxes which will also be included in your results. You may choose to export this data by going to the “download users” button at the top but if there are a lot of users, it will take some time to download. You will also waste time downloading other properties that are not important to you.

To get a clean and accurate report, you will need to do some manual cleanup to remove the unnecessary properties, and sort on the dates of the last sign-in.

Note that the Sign-in Logs (also accessible from the main Admin Center reports) lists detailed sign-in activity events for a maximum of 30 days. Therefore, it’s not ideal for creating a report on the last sign-in date per user.

The first step is to filter out all the blocked/disabled accounts by going to the sign-in status column and unchecking the blocked accounts.

This will provide you with a list of only the enabled accounts. Now, select all your accounts and click on additional info on the menu at the top. This will automatically give you the information about when these user accounts last signed in.

You can now select the User Purpose property and any other user property to add their column to your grid view. The User Purpose property lets you know the mailbox type.

Now you will filter out all the shared mailboxes and rooms by unchecking them in the dialog box.

If you need non-interactive sign-in information, you can now also add that information to your report. Finally, you can now sort the information by last sign in date from the ribbon or by right-clicking on the column header.

With this view created, you can export it to Excel where you will have a clean spreadsheet with only the information you want included.

You can also save this view for future use. Simply give your view a name and you will be able to use it again as often as you want. If you want to be organized, you can even schedule the report to run every week or month, depending on your requirements.

Once your Microsoft 365 environment is cleaned up by removing inactive accounts, you may want to take a look at your licenses and find which ones may be unused. This is how one user saved a lot of money by identifying under-utilized licenses. As the above examples show, there are a few ways to get your Microsoft Office 365 login report, but not all of them will give you all the information you need, and some will take longer than others. sapio365 is a great software tool that allows you to accomplish many tasks in less time. Discover how using sapio365 to handle typical Microsoft 365 administration can save you hours of time every single day.