1

Hello all,

I have used spiceworks and the powershell gallery to advance my powershell skills and it has helped a lot. Now I have an issue. I am having an issue getting data from a csv file full of mailboxes. The goal is to gather the display name and mailbox size in GB, but I am getting the below error. Below is the script I am running and the error I get from running the script. Can someone help me understand what I am doing wrong? Also tbh I do not understand this error. Forgive my ignorance.

Script :

$File = Import-Csv “C:\TotalMailboxes.csv”

Get-MailboxStatistics -identity $File | FL DisplayName, DataBase, ServerName, @{label=”Total Size (KB)”;expression={$_.TotalItemSize.Value.ToGB()}

Error :

Cannot process argument transformation on parameter ‘Identity’. Cannot convert the “System.Collections.ArrayList” value of type “System.Collections.ArrayList” to type “Microsoft.Exchange.Configuration.Tasks.GeneralMailboxorMailUserIdParameter”.

  • CategoryInfo : InvalidData: (:slight_smile: [Get-MailboxStatistics], ParameterBindin…mationException

  • FullyQualifiedErrorId : ParameterArgumentTransformationError,Get-MailboxStatistics

  • PSComputerName : FQDN@domain.com

6 Spice ups
2

try to use a foreach instead direct pipe

$File = Import-Csv "C:\TotalMailboxes.csv"
foreach($mbx in $file){
    Get-MailboxStatistics -identity $mbx | 
    FL DisplayName, DataBase, ServerName, @{label=”Total Size (KB)”;expression={$_.TotalItemSize.Value.ToGB()}
}
2 Spice ups
3

You’re trying to convert an array in the CSV into a single property. You need to loop through it with something like this:

$File = Import-Csv "C:\TotalMailboxes.csv"

$file | foreach {Get-MailboxStatistics -identity $_.identity | select DisplayName, DataBase, ServerName, @{label=”Total Size (KB)”;expression={$_.TotalItemSize.Value.ToGB()}}

This makes the assumption that your parameter is named “identity” other wise you would need to adjust $_.identity to whatever the column heading is named.

2 Spice ups
4

Essentially the error means that you’re trying to use an array when it is expecting a name and it can’t ‘transform’ one data type to another. Other data types it can, like integer/strings, but not an array of strings into a string. Make sense?

Like the others have said, step through the array with a foreach command, then you’ll be able to provide the argument type that it is looking for

5

why are you pulling the info from a csv for the mailboxes, and not just pulling the mailboxes from the server? If you mis-spell anything in the CSV, or have mailbox names that are outdated, you’ll end up with more errors.

Try the report I’m attaching. (rename to .ps1 to use)

It has a lot of options that I have commented out currently, but it will give you a better look at mailbox info breakdowns when you cant figure out why someone’s mailbox is in the GB in size, but they have less than 1000 messages in an inbox.

MBX_Report-SizeAll2013.txt (3.65 KB)

6

According to the script error “ Cannot process argument transformation on parameter ‘Identity’ ”, I tried to modify the value in the parameter “Identity” in the following script and the script helped me get the display name and mailbox size in GB, you could add or modify the entry in the CSV file and the parameter “Identity”, in addition, before you run the script, please confirm that there are no extra objects(Just like “Blank”) in the entries:


<b>Import-CSV
“C:\Mailbox.csv” | foreach{</b>

<b>Get-MailboxStatistics
-Identity $_.DisplayName | FL DisplayName,Database,ServerName,@{label=”Total
Size (KB)”;expression={$_.TotalItemSize.Value.ToGB()}}</b>

**}**

1.jpg2.jpg

7

Sorry for the delayed reply for I have been away for the weekend. @timhetzel ​ That worked sir. Thank you very much. I had to change -Identity $.Identity to -Identity $.PrimarySMTPAddress as that is what I have as the header of the CSV.

@matthart5 ​ Thanks for explaining that. That does make since to me now.

@ianadams2 ​ The reason for the CSV is because these mailboxes are coming from multiple servers and databases within the environment so having a CSV of all the mailboxes is much more helpful.

Thank you also @alexw ​ & @ivan-wang ​

8

You are running this command Get-MailboxStatistics -identity

and THEN filtering what information is displayed. You aren’t specifying any servers or databases in that command, so where they are located is irrelevant, and there isn’t really a need for the csv file, unless you only want results from specific mailboxes, and not your whole exchange environment*. IN which case I still recommend get everything, and then just filter it down in excel afterwards.*

Look at the script I put up as a TXT file, you’ll see it has commented options for server name and database, and a whole bunch of other stuff, and gives you a nice formatted output that goes into excel with zero problems.