Export O365mailbox last login to csv

%3CLINGO-SUB%20id%3D%22lingo-sub-2169062%22%20slang%3D%22en-US%22%3EExport%20O365mailbox%20last%20login%20to%20csv%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2169062%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20trying%20to%20export%20my%20tenant%20mailbox%20last%20login%20details%20to%20CSV%20but%20somehow%20last%20login%20details%20are%20pulled%20wrongly%20by%20script%20which%20I%20was%20used.%3C%2FP%3E%3CP%3EAnyone%20can%20help%20me%20out%20how%20to%20pull%20mailbox%20last%20login%20to%20csv%20for%2030%20thousand%20mailboxes%20and%20it's%20a%20time%20consuming%20task.%3C%2FP%3E%3CP%3EI%20was%20going%20through%20this%20article%20explained%20about%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20guide%20me%20how%20to%20export%20mailbox%20last%20login%20and%20never%20logged%20mailboxes%20from%20last%2090%20days%20to%20csv%20as%20I%20am%20not%20expert%20in%20scripting%20or%20write%20a%20PowerShell%20command.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20really%20appreciated.%3C%2FP%3E%3CP%3EAnand%20Sunka%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2169062%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%20Mailbox%20last%20login%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello Everyone,

 

Currently trying to export my tenant mailbox last login details to CSV but somehow last login details are pulled wrongly by script which I was used.

Anyone can help me out how to pull mailbox last login to csv for 30 thousand mailboxes and it's a time consuming task.

I was going through this article explained about the same.

 

Can someone guide me how to export mailbox last login and never logged mailboxes from last 90 days to csv as I am not expert in scripting or write a PowerShell command.

 

 

Any help really appreciated.

Anand Sunka

 

1 Reply

The Graph API doesnt include any Exchange-related operations currently, so your best option is to use the Outlook activity report: https://docs.microsoft.com/en-us/graph/api/reportroot-getmailboxusagedetail?view=graph-rest-1.0