Solved

Get-MailboxStatistics cmdlet/script help

Posted on 2013-06-28
1
383 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
[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
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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

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…
This article will help to fix the below errors for MS Exchange Server 2013 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This video discusses moving either the default database or any database to a new volume.

695 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