Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Logon dates for Microsoft Office 365 Exchange Online user

Posted on 2014-04-07
4
Medium Priority
?
1,712 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 44

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 43

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

Introducing the WatchGuard 420 Access Point

WatchGuard's newest access point includes an 802.11ac Wave 2 chipset, providing the fastest speeds for VoIP, video and music streaming, and large data file transfers. Additionally, enjoy the benefits of strong security as the 3rd radio delivers dedicated WIPS protection!

Question has a verified solution.

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

This article will help to fix the below error for MS Exchange server 2010 I. Out Of office not working II. Certificate error "name on the security certificate is invalid or does not match the name of the site" III. Make Internal URLs and External…
I don't pretend to be an expert at this, but I have found a few things that are useful. I hope that sharing them here will help others, so they will not have to face some rather hard choices. Since I felt this to be a topic of enough importance and…
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

721 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