Solved

Logon dates for Microsoft Office 365 Exchange Online user

Posted on 2014-04-07
4
1,636 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 43

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 41

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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Unified and professional email signatures help maintain a consistent company brand image to the outside world. This article shows how to create an email signature in Exchange Server 2010 using a transport rule and how to overcome native limitations …
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

751 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