Solved

Logon dates for Microsoft Office 365 Exchange Online user

Posted on 2014-04-07
4
1,675 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 42

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Enabling the Skype for Business Meeting Scheduler in Hybrid OWA
Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

623 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