Hello I need information about users in specific database, and only First Name, Last Name, E-mail, Department using EMC. This One works well, but I cannot get Department, why ? : Get-Mailbox -ResultSize unlimited -Database "DB1" | Select-Object DisplayName,PrimarySmtpAddress,Department How to get department info ?

Hi Department is not a property of the mailbox so it is not returned by Get-Mailbox. You need to run Get-User for this instead. Try this: Get-Mailbox -ResultSize unlimited -Database "DB1" | Select-Object DisplayName,PrimarySmtpAddress,@{expression={(Get-User $_.name).Department}} Cheers, Steve

This one is not working. EMC retunrs : DisplayName PrimarySmtpAddress (Get-User $_.name).Department ----------- ------------------ -----------------------------

It should return the correct values, just the label needs to be set. Try this: Get-Mailbox -ResultSize unlimited -Database "DB1" | Select-Object DisplayName,PrimarySmtpAddress,@{label="Department";expression={(Get-User $_.name).Department}}

Works fine for me, the only thing I would do is tidy it up with a corrected label: get-mailbox -ResultSize Unlimited -database "DB1" | Select-Object DisplayName,PrimarySmtpAddress,@{label="Department";expression={(Get-user $_.name).Department}} Are you sure your department fields are populated? Also, if you could paste the command you are using that yields a blank result.

Yes, department fields are populated, I tried with FirstName, LastName, but the same. Looks like EMC cannot read data from AD, it can get only data from fields that are listed when you tipe "Select-Object *". the same: get-mailbox -ResultSize Unlimited -database "DB1" | Select-Object DisplayName,PrimarySmtpAddress,@{label="Department";expression={(Get-user $_.name).Department}} EMC retunrs : DisplayName PrimarySmtpAddress Department ----------- ------------------ ----------------------------- data data empty

I've just tried this on another system and sometimes it starts completing the department column about half way through the results. The lines before that are blank and I don't know what would cause this.

I just saw the same thing, the pipeline does not seem to execute the expression command for a while.... well, the only workaround I can think of is to use the trusty dusty foreach method, it takes a while to run, but it works: $Mailboxes=Get-Mailbox -ResultSize Unlimited -Database "DB1" $report=@() foreach ($mailbox in $mailboxes) { $ReturnedObj=New-Object PSObject $ReturnedObj | Add-Member NoteProperty -Name "Display Name" -Value $Mailbox.DisplayName $ReturnedObj | Add-Member NoteProperty -Name "Primary Email" -Value $Mailbox.PrimarySmtpAddress $ReturnedObj | Add-Member NoteProperty -Name "Department" -Value $(Get-User $mailbox.name).Department $Report+=$ReturnedObj } $Report #Uncomment below to export to CSV #$Report | Export-CSV ".\FileName.CSV" -NoTypeInformation

Yes I think you are on to something there. I just broke the command in two and it returns all the values: $mbx = Get-Mailbox -ResultSize unlimited -Database "DB1" $mbx | Select-Object DisplayName,PrimarySmtpAddress,@{label="Department";expression={(Get-User $_.name).Department}}

This works too: Get-Mailbox -ResultSize unlimited -Database "DB1" -OutBuffer 500 | Select-Object DisplayName,PrimarySmtpAddress,@{expression={(Get-User $_.name).Department}} Adjust the value of OutBuffer depending on your environment and the number of objects returned.

Nice Steve, I will remember that one.

Hi Krieghoff Did you try those Command above? They works fine on my Exhange. If it works, Please Mark Steve's post As Answer and finish this thread CheersZi Feng TechNet Community Support