Solved

Get-MailboxStatistics cmdlet/script help

Posted on 2013-06-28
1
378 Views
Last Modified: 2013-07-08
Hey Guys, I am looking to create a script that will run every Monday morning and email to a distribution list.

But first, what would the script or cmdlet syntax need to be to export just these fields into a CSV?

DisplayName
Title
Department
Office
Enabled
Expires
Last Mailbox Logon
MailboxSizeMB
Type
ServerName
Database
ItemCount
PrimarysmtpAddress

On a side note, is it possible to also export the "Device model: iPad2C2" if they have a device syncing with EAS?
0
Comment
Question by:GCTTechs
1 Comment
 
LVL 9

Accepted Solution

by:
bharrington83 earned 500 total points
ID: 39284779
Write your output of this get string to a file, say C:\body.txt.  Then use the procedure here: http://blogs.msdn.com/b/rkramesh/archive/2012/03/16/sending-email-using-powershell-script.aspx to write the email.  Make sure to set $msg.body = Get-Content C:\YOURFILENAME.txt
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now