snyperj
asked on
Pull User info from Exchange Server or Active Directory
How can I export the following info from Exchange 2010 into excel
First Name
Last Name
Business Phone
Fax Nbr
Mobile Phone
Email addiress
for every active user?
First Name
Last Name
Business Phone
Fax Nbr
Mobile Phone
Email addiress
for every active user?
Personally I use PowerGUI which is a free download and it will allow you to choose what to export. http://www.quest.com/powergui-freeware/
You need to use powershell from Exchange. here are some commands that dump all kinds of info, you can sort and delete what you do/don't need.
Get-ADObject -filter 'objectclass -eq "user"' -properties * | select | export-csv -NoTypeInformation "c:\ADUsers.csv"
It saves a csv file to the C drive called ADUSERS.csv.
Get-ADObject -filter 'objectclass -eq "user"' -properties * | select | export-csv -NoTypeInformation "c:\ADUsers.csv"
It saves a csv file to the C drive called ADUSERS.csv.
ASKER
The term 'Get-ADObject' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:13
+ Get-ADObject <<<< -filter 'objectclass -eq "user"' -properties * | select | export-csv -NoTypeInformation "c:\ADUser
s.csv"
+ CategoryInfo : ObjectNotFound: (Get-ADObject:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
At line:1 char:13
+ Get-ADObject <<<< -filter 'objectclass -eq "user"' -properties * | select | export-csv -NoTypeInformation "c:\ADUser
s.csv"
+ CategoryInfo : ObjectNotFound: (Get-ADObject:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
Close the PowerShell window, right click it and open as Admin.
Does that work?
Does that work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
No problem. Just had to do this a few weeks ago for a client.