Office 365 whenCreated and whenChanged report. Find user creation date on Office 365.

This reports the created date of every user in your organisation.

$objUsers = get-mailbox -ResultSize Unlimited | select UserPrincipalName 

Foreach ($objUser in $objUsers) 
    {     
        $objUserMailbox = get-user -Identity $($objUser.UserPrincipalName) | select identity, whenCreated, whenChanged

$strUserPrincipalName = $objUser.UserPrincipalName
$strWhenCreated = $objUserMailbox.whenCreated
$strWhenChanged = $objUserMailbox.whenChanged
write-host "$strUserPrincipalName : $strWhenCreated : $strWhenChanged"
    }

Copy and paste it into the PowerShell after connecting and then press enter twice.. Should show you a list of users and their Created time and last modified time.

Hope this helps someone.

This entry was posted in Uncategorized. Bookmark the permalink.

3 Responses to Office 365 whenCreated and whenChanged report. Find user creation date on Office 365.

  1. Ethan says:

    This is great! I needed to find out when some accounts were created and this worked perfectly! Thank you!

  2. can you find this information running a report other then using powershell?

  3. Sorry, that is a question best asked to Microsoft support. I don’t know the answer and your googling would be as good as mine.
    If you are struggling to connect to powershell you should see this page which takes you to the Microsoft documentation on how to connect:
    https://thecomputerperson.wordpress.com/2014/07/27/the-correct-way-to-connect-to-office-365-using-powershell/

Comment on this topic

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s