Hello,I need to get only the Firstname and lastname of the users in a list.I need to distinct the Firstname of the lastname (diff column)Any idea?

Not much to go on, but assuming the list is users.txt, and using Exchange 2007 EMSgc list.txt |% {get-user $_ | select firstname,lastname}

On Fri, 18-Dec-09 14:58:01 GMT, Graiggoriz wrote:>Hello,I need to get only the Firstname and lastname of the users in a list.I need to distinct the Firstname of the lastname (diff column)Any idea? get-mailbox -resultsize unlimited | get-user | selectfirstname,lastnameYou can pipe the results of the select cmdlet to export-csv if youwant the data in that format.---Rich MatheisenMCSE+I, Exchange MVP--- Rich Matheisen MCSE+I, Exchange MVP

And, assuming the "list" is a Distribution Group: Get-DistributionGroupMember <List Name> |Get-User |Select-Object firstname, lastnameKarlhttp://unlockpowershell.wordpress.com

Thanks you all for your input.That command gave me what I was expected --> get-mailbox -resultsize unlimited | get-user | selectfirstname,lastnameThough, I would like to get only user with the attribute 10 = INDIA when I add that command | Where {$_.CustomAttribute10 -like "INDIA"} It doesn't work.Any idea how I could make it work??Thanks

Sorry I meant to get/add in the below command the PrimarySmtpAddress??I already got the command: get-mailuser -resultsize unlimited | where {$_.CustomAttribute10 -like "INDIA"} | get-user | select firstname, lastname, displaynameThanks in advance for your help

Try get-recipient instead of get-mailuser, and don't do the pipe through get-user:get-recipient -resultsize unlimited | where {$_.CustomAttribute10 -like "INDIA"} | select firstname,lastname,displayname,primarysmtpaddress