Office 365 Script to Email Mailbox Count

We are getting ready to migrate all of our user 8000 users to o365. I would like to have a automate task run that will email the number of mailbox in o365.

I know i get this information by typing in (Get-Mailbox -resulltsize unlimited).count but how do I display this information in the body of an email that will be sent out every 30 to 60 minutes?
LVL 20
compdigit44Asked:
Who is Participating?
 
Jeremy WeisingerSenior Network Consultant / EngineerCommented:
Put the results in a variable and use it in your email body.

e.g.
$mbxCount = $((Get-Mailbox -resulltsize unlimited).count)
Send-MailMessage -To jd@domain.com -From admin@domain.com -Subject "Mailbox Count" -Body "Number of mailboxes in Office 365: $mbxCount"

Open in new window

You'll need to provide an SMTP server and credentials potentially for that...
https://docs.microsoft.com/en-us/powershell/module/Microsoft.PowerShell.Utility/Send-MailMessage?view=powershell-4.0
0
 
Vasil Michev (MVP)Commented:
As long as you send the message via PowerShell session connected to Exchange Online, you can use the value directly. $((Get-Mailbox -resulltsize unlimited).count) should evaluate to the current number, at the time of sending the message.
0
 
compdigit44Author Commented:
Thanks, how would I input the result of the command in the body of an email set by powershell. For example. Number of mailboxes in Office 365: xxxxx
0
 
Jeremy WeisingerSenior Network Consultant / EngineerCommented:
Glad to help. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.