Need expertise from a Powershell guru

Hello PowerShell guru,

need from your expertise to pull out a statistic report on emails for a group of users.

found the following report, but just wondering if you would you be able to break this down by month

Get Some Statistics from Mailboxes

https://gallery.technet.microsoft.com/office/b992ae5a-91ea-4910-970e-c8dd29e468ed

 
My exchange organization is Exchange 2013 CU8, with multiple CAS and MBX in a DAG
Jerry SeinfieldAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AmitIT ArchitectCommented:
You can run it once every month. That's what you are looking I guess. I don't see anything scripted to run every week. It is the way you use it and collect the data.
Jerry SeinfieldAuthor Commented:
Hi Amit,

I am not following you,

Are you saying that script above can be run per month, and will show the information requested?

If not,

Do you have a PowerShell script that can be used for this purpose? the information presented on the final spreadsheet must be based per month
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Correct, the script just reports the current standing. You can run it as often as you want. It will not report a delta, only absolute values.
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

Jerry SeinfieldAuthor Commented:
Hi Qlemo,

Since the script above returns all users in Exchange, is there a way to modify this code, and return only a few mailboxes given a CSV input file?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Sure. You'll have to replace the first code line, which gets the mailboxes to process. I'll assume no CSV file but a text file with only the (alias) name on each line, no title.
$listOfMbxs = Get-Content C:\Scripts\ListOfMbxs.txt
$mbxs = Get-Mailbox -ResultSize Unlimited -Filter {RecipientTypeDetails -ne "DiscoveryMailbox"} |
  Where {$_.Alias -notlike "extest_*"} |
  Where ($listOfMbxs -notcontains $_.Alias} |
  Select Identity, PrimarySmtpAddress, EmailAddresses, EmailAddressPolicyEnabled, OrganizationalUnit, UseDatabaseQuotaDefaults, ProhibitSendQuota, ProhibitSendReceiveQuota, IssueWarningQuota, Database 

Open in new window

Jerry SeinfieldAuthor Commented:
Hi Qlemo,

Regarding the stats reports, are the totals for the lifetime of the inboxes or is there a specific start date?
AmitIT ArchitectCommented:
@Jerry,

Sorry, I was away, saw this today. Are you clear, what I am trying to say or you still have doubt.
Jerry SeinfieldAuthor Commented:
no, I need a complete explanation on how this script works, and the results obtained.

Are the total for the lifetime of the inboxes or is there a specific start date?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
The stats are just as they are at that moment - for the lifetime of each acount until now. Such stats cannot be retrieved (directly) for only a week or month or day or whatever, Exchange is not keeping track of that, and so we cannot ask for it.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.