Solved

Logon dates for Microsoft Office 365 Exchange Online user

Posted on 2014-04-07
4
1,582 Views
Last Modified: 2014-04-14
Is it possible to find all of the logon dates for a single Microsoft Office 365/Exchange Online user using powershell?  I see a command to get the last logon date, but I have been asked to provide the first logon date, and all logon dates since.  We migrated about 4 months ago.  

Is there a powershell command or script that will provide this?

Thank you
0
Comment
Question by:TOHIT
  • 2
4 Comments
 
LVL 42

Expert Comment

by:Amit
ID: 39984164
As far as, i know you can find only last logon date. So, chances are rare or impossible to fetch, until MS is maintaining it somewhere....However, you can use mailbox level auditing, that can provide you lot of information, but need to be enabled first.

Check below article for more ref:

https://www.cogmotive.com/blog/office-365-tips/enable-mailbox-auditing-for-office-365-users
0
 
LVL 40

Expert Comment

by:Vasil Michev (MVP)
ID: 39985012
AuditOwner is NOT available in Exchange Online, so you're pretty much left with no option. Open a case with Microsoft and see what they come up with...
0
 

Accepted Solution

by:
TOHIT earned 0 total points
ID: 39988895
Actually Microsoft replied with a powershell command that worked for what I needed. The only problem I had was that it gave me a list of all users for the time frame that I selected, and although it provided the correct dates, all logon times showed as 12:00 a.m., not sure why.  

The command, run from exchange powershell is:

Get-ConnectionByClientTypeDetailReport -StartDate 12/15/2013 -EndDate 03/31/2014 -resultsize Unlimited | Out-GridView

You can change the result size if you want to limit it, and need to customize the startdate and endate.
0
 

Author Closing Comment

by:TOHIT
ID: 39998547
The other comments were helpful, but Microsoft finally responded to a service ticket with the information that I needed.  I posted it here in case anyone else was looking for the information.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This Experts Exchange lesson shows how to use VBA to loop through rows in Excel.  In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data arrives with values missing, code to copy values…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question