Jerry Seinfield
asked on
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
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
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.
ASKER
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
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
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.
ASKER
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?
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?
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
ASKER
Hi Qlemo,
Regarding the stats reports, are the totals for the lifetime of the inboxes or is there a specific start date?
Regarding the stats reports, are the totals for the lifetime of the inboxes or is there a specific start date?
@Jerry,
Sorry, I was away, saw this today. Are you clear, what I am trying to say or you still have doubt.
Sorry, I was away, saw this today. Are you clear, what I am trying to say or you still have doubt.
ASKER
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?
Are the total for the lifetime of the inboxes or is there a specific start date?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.