In my last post I used used New-Object to create an desirable output when the “Get-Mailbox” cmdlet didn’t meet my needs. If your eyes glazed over trying to read the script, let me make it a bit simpler by focusing on a straight forward example.
Say you need to create a list of user’s mailbox size with their email address. This sounds like a simple request, but what you’d soon find is that mailbox sizes are returned with the Get-MailboxStatistics cmdlet and the email address is not. For that, you need to use another cmdlet, such as Get-Mailbox.
With the New-Object cmdlet, we are able to make a custom output that contains data from essentially wherever we want.
See this example:
$MyObject = New-Object PSObject -Property @{
EmailAddress = $null
MailboxSize = $null
}
In this example, I have created a new object with 2 fields, and saved it as the $MyObject variable.
For now, we’ve set the data to null, as shown below:
The next step is to populate each of those fields. We can write to them one at a time with lines like this:
$MyObject.EmailAddress = (Get-Mailbox mcrowley).PrimarySmtpAddress $MyObject.MailboxSize = (Get-MailboxStatistics mcrowley).TotalItemSize
Note: The variable we want to populate is on the left, with what we want to put in it on the right.
To confirm our results, we can simply type the variable name at the prompt:
Pretty cool, huh?
Ok, so now about that list. My example only shows the data for mcrowley, and you probably need more than just 1 item in your report, right?
For this, you need to use the foreach loop. You can read more about foreach here, but the actual code for our list is as follows:
(I am actually going to skip the $null attribute step here)
$UserList = Get-mailbox -Resultsize unlimited
$MasterList = @()
foreach ($User in $UserList) {
$MyObject = New-Object PSObject -Property @{
EmailAddress = (Get-Mailbox $User).PrimarySmtpAddress
MailboxSize = (Get-MailboxStatistics $User).TotalItemSize
}
$MasterList += $MyObject
}
$MasterList
Finally, if you wanted to make this run faster, we really don’t need to run “get-mailbox” twice. For better results, replace the line:
EmailAddress = (Get-Mailbox $User).PrimarySmtpAddress
With this one:
EmailAddress = $User.PrimarySmtpAddress
Mike Crowley's Whiteboard 
Hi Mike,
If I wanted to return additional data such as DisplayName, Database, ServerName, itemcount, lastlogontime and {$_.TotalItemSize.Value.ToMB()} how would I add this? also how can you export this to a .csv?
thanks
You need to first get that data from somewhere. Once you have worked out the command do to that, you can add fields to the new-psobject block, and then add lines below the $masterobject.whatever section.
Here is how it would look: https://skydrive.live.com/redir.aspx?cid=0c23cb95e1200929&resid=C23CB95E1200929!1258&parid=C23CB95E1200929!475
Thanks Mike this worked great.
I wrote similar script to help plan for mailbox moves that combines results from Get-Mailbox, Get-User, and Get-MailboxStatistics and save the results into a single CSV file.
See my blog post here for another way to do this:
http://blog.jasonsherry.net/2012/04/13/get-mailboxinfo/
For anyone still reading, here is another approach to this report: http://get-exchange.blogspot.com/2009/03/did-you-ever-needed-to-supply-list-of.html
I think i like my mailbox script that I made up myself. Lemmie know what you think ….
Get-Mailbox | Get-MailboxStatistics | FT @{label=”DisplayName”;expression={$_.DisplayName}}, @{label=”Total Items Count”;
Expression={$_.ItemCount}}, @{label=”Storage Limit”;expression={$_.StorageLimitStatus}}, @{label=”TotalStorageSize”;
Expression={$_.TotalItemSize}}, LastLogonTime -autosize
—————————————
Hello,
Thanks for this script, i’m trying to do the same thing with multi organizations environment.
I wrote that :
$MasterList = @()
foreach($User in Get-Organization) {
$MyObject = New-Object PSObject -Property @{
Name = (Get-Mailbox -Organization $Org).displayname
}
$MasterList += $MyObject
}
$MasterList | Export-CSV -Path c:\test.csv -Delimiter “;” -Notype
But my CSV file looks like (no value) :
“Name”
Can you help me ?
Is this a continuation from http://powershellcommunity.org/Forums/tabid/54/aft/8700/Default.aspx ?
Unfortunately I don’t have a multi-tenant org to test this with, so I’m not sure what the output of get-organization is.
At a glance, I wonder where $org is defined. Should that be $user?
One-liner, can be customized to add anything you want:
Get-Mailbox -Identity | Select-Object -Property PrimarySmtpAddress,@{Name=”MailboxSize”;Expression={ $_ | Get-MailboxStatistics | Select-Object -ExpandProperty TotalItemSize }}
the Identity parameter was wiped out form my previous post, but you get the idea 🙂
Thanks, I’m trying to use this as well but I’m a bit confused on your comment about adding more properties from different commands, you wrote “You need to first get that data from somewhere. Once you have worked out the command do to that, you can add fields to the new-psobject block, and then add lines below the $masterobject.whatever section.”.
So if I want to run get-msoluser as my first command, then add in info from get-mailbox, then get-mailboxstatistics, and then get-aduser, how can I do that?
Here is another example. You could use get-aduser in addition to this as well if you wanted.
$MyObject = New-Object PSObject -Property @{
isLicensed = (Get-MsolUser -UserPrincipalName mike@fake.onmicrosoft.com).isLicensed
ProhibitSendQuota = (Get-Mailbox mike@fake.onmicrosoft.com).ProhibitSendQuota}
I’m trying to do something along these lines but a bit trickier. I’m trying to build a list of group names and their email addresses. However, I want this to work for Security groups (acting jointly as distribution groups) and distribution groups. The problem I’m having is if I use “get-adGroupMember” I can get names, but how do I match those names if its a security group? I tried something like the below and of course it wouldn’t work. Gives you an idea though. I am obviously a powershell noob but am trying to figure what I can do with it.
$GroupName=Read-host “Enter Group Name (name must be exact)”
$SavePath=”$Home\desktop\Group by name and email.csv”
Import-Module ActiveDirectory
add-pssnapin Microsoft.Exchange.Management.PowerShell.E2010
Get-DistributionGroupMember $GroupName | sort-object | Select PrimarySmtpAddress
get-ADGroupMember $GroupName | sort-object | select name
Export-CSV -path $SavePath
Write-Host “File saved to:” $SavePath
As you’ve seen, get-ADGroupMember and get-DistributionGroupMember both output arrays of users. I don’t understand what you want the CSV file to look like. What do you want in each column? Also, because Exchange distribution groups are just AD groups anyway, why bother with the Exchange output? Can’t you get whatever you need from get-ADGroupMember?
Ahh, good questions. I haven’t been able to get the email addresses from get-ADGroupMember, as active directory no longer handles email addresses (instead, the exchange management console does, thats why I had the add-pssnapin in there). I’d like to be able to enter the name of distribution or security group and have it give me all the names as well as their primary email address. I’m sure its possible, I just haven’t been able to do it yet (my own lack of knowledge surely to blame).
I’m still unclear on what you want in each row. Can you list the column names you have in mind?
Sure. I want one column to be name, the other to be email address, pulled from either distribution lists OR security groups that act as distribution lists (can be emailed). so a security group called helpers
Smith, John john.smith@whatever.wk
Smith, James james.smith@whatever.wk
Lake, Jane jane.lake@whatever.wk
The names would be the member names, the hard part is linking them to the email addresses (at least so far) when AD has no built in exchange extensions like AD and exchange 2003 did. Sorry if that still doesn’t explain it.
I’m still not following, sorry. This generates an output identical to what you’re asking, but it doesn’t require any custom work: Get-DistributionGroupMember group1 | select DisplayName, PrimarySmtpAddress
Another way to setup custom PS objects here: http://powershell.com/cs/blogs/tips/archive/2014/10/21/creating-newobjects.aspx
Hi !
I tried my best to apply the knowledge found in this blog to my problem without success.
I am checking the mailbox permissions and extended AD permissions (more specifically “send as” by using
Get-MailboxPermission boss1| where {$_.user.tostring() -ne “NT AUTHORITY\SELF” -and $_.IsInherited -eq $false}
and
Get-ADPermission boss1 | Where {$_.ExtendedRights -like “*Send-As*” -and $_.user.tostring() -ne “NT AUTHORITY\SELF”}
The two outputs are typically like this:
User AccessRights
—- ————
secretary1 {FullAccess}
secretary2 {FullAccess}
secretary3 {FullAccess}
User ExtendedRights
—- ————–
secretary1 {Send-As}
secretary2 {Send-As}
secretary3 {Send-As}
Shame on me, I cannot understand how to combine them so that I get an output like this:
User AccessRights ExtendedRights
—- ———— ————–
secretary1 {FullAccess} {Send-As}
secretary2 {FullAccess} {Send-As}
secretary3 {FullAccess} {Send-As}
Thank you in advance!!!
How would you be able to import a csv and have the script scan one particular column for a list of User name?
When I try to use the following it errors out to a pipeline error
$UserList = import-csv c:\istofusers.csv | get-mailbox -resultsize unlimited
two lines, and no resultsize
$UserList = import-csv c:\istofusers.csv
$UserList | get-mailbox
Thank you tremendously for your quick reply, Mr. Crowley!
When I use the following:
$UserList = import-csv c:\ListofUsers.csv
$UserList | get-mailbox
$MasterList = @()
I get this error:
The input object cannot be bound to any parameters for the command either because the command does not take pipeline input or the input and its properties do not match any of the
parameters that take pipeline input.
+ CategoryInfo : InvalidArgument: (@{Name=username,…DriveSize(MB)=}:PSObject) [Get-Mailbox], ParameterBindingException
+ FullyQualifiedErrorId : InputObjectNotBound,Get-Mailbox
send me your script and i can take a look. BTW, I made this post 4+ years ago and don’t use this approach much anymore.
Thank you for your patience!
Which approach would you use in this case?
$UserList = import-csv c:\listofusers.csv
$UserList | get-mailbox
$MasterList = @()
foreach ($User in $UserList) {
$MyObject = New-Object PSObject -Property @{
EmailAddress = $null
MailboxSize = $null
LastSent = $null
}
$ErrorActionPreference = ‘SilentlyContinue’
$MyObject.LastSent = ((Get-TransportServer | Get-MessageTrackingLog -Sender $user.PrimarySmtpAddress | sort timestamp)[-1]).timestamp
$MyObject.EmailAddress = ($User).PrimarySmtpAddress
$MyObject.MailboxSize = (Get-MailboxStatistics $User).TotalItemSize
$ErrorActionPreference = ‘Continue’
$MasterList += $MyObject
}
$MasterList
At last i found my answer. I was searching for this. Thanks a lot. Great post on powershell.
If I have a list of mailboxes in a .txt how do I parse each of it to a Get-MailboxPermission?
I need to get the list of permissions of only that narrowed list but I cannot find a wait to parse it.
I tried: get-content list.txt | Get-MailboxPermission
And it is not being accepted. I´m trying other methods online but no one works… HELP!!!??
Hi @michaelangelos. This is a very old post. Feel free to email me, or perhaps submit this type of question to a community like: https://old.reddit.com/r/PowerShell