Avatar of aucklandnz
aucklandnzFlag for New Zealand

asked on 

Export User List

Hi,
Hi,

Im using exchange 2010SP1
i need to get a list of all users with mailboxes and their all email aliases, and current mailbox size and export it csv file

What command would do the trick ?

Thanks

Exchange

Avatar of undefined
Last Comment
aucklandnz
Avatar of aucklandnz
aucklandnz
Flag of New Zealand image

ASKER

i forgot to add that i will need Email Group user belongs to aswell.

Cheers  
ASKER CERTIFIED SOLUTION
Avatar of oferam
oferam
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of aucklandnz
aucklandnz
Flag of New Zealand image

ASKER

Thanks it helped (no group membership tho.

do you know by anychance how to get list of mailboxes that have forwarding enabled and its forwarding email address
SOLUTION
Avatar of agriesser
agriesser
Flag of Austria image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of aucklandnz
aucklandnz
Flag of New Zealand image

ASKER

thanks,

go do i run above script ? do i have to save it as ?
Avatar of agriesser
agriesser
Flag of Austria image

You can just copy and paste it into the exchange management shell (hit return twice after the paste has finished and the prompt still shows ">>".

The script will output the CSV directly onto the powershell console, you can use the Export-CSV cmdlet instead of ConvertTo-Csv to save it to a file. To do that, just replace the last line with:

$csv | Export-Csv -FilePath c:\path\to\file.csv

You can also save it as a .ps1 file and run it directly from the exchange management shell.
Avatar of aucklandnz
aucklandnz
Flag of New Zealand image

ASKER

thanks for your reply

i get an error :

Export-Csv : A parameter cannot be found that matches parameter name 'FilePath'.
At line:25 char:28
+ $csv | Export-Csv -FilePath <<<<  c:\file.csv
    + CategoryInfo          : InvalidArgument: (:) [Export-Csv], ParameterBindingException
    + FullyQualifiedErrorId : NamedParameterNotFound,Microsoft.PowerShell.Commands.ExportCsvCommand
Avatar of agriesser
agriesser
Flag of Austria image

Sorry, it's just "-Path" and not "-FilePath".
Avatar of aucklandnz
aucklandnz
Flag of New Zealand image

ASKER

Thanks a lot !!!
Exchange
Exchange

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

213K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo