Avatar of jamorlando
jamorlandoFlag for United States of America asked on

Exporting AD Contacts with Powershell

Hi,
I'm currently trying to migrate our company's 1000+ mail contacts from Exchange into a contacts list in Sharepoint.

I need specific data from Active Directory for each contact which goes beyond what the Get-MailContact cmdlet can do.  I need info like Company, phone number...etc...

I downloaded Quest's tools, but it seems like their cmdlets are only for users, not contacts.

Any ideas?
Active DirectoryPowershell

Avatar of undefined
Last Comment
jamorlando

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
KenMcF

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Joseph Daly

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
jamorlando

@KenMcF, thanks, I will try to tweak this to my needs

@xxdcmast, wow, never heard of the csvde.exe command, but that's pretty sweet that you can do this kind of thing from the command prompt instead of powershell.  If I can't get Ken's solution to work I'll check this out.

@Akhater, I see company, and phone, but what about an attribute like "Address" which is stored in AD?
Akhater

you mean StreetAddress?

get-contact -resultsize unlimited | select-object name,Phone,company,streetaddress

again try with on one conact get-contact contactname | fl  and you will be able to find all properties
ASKER
jamorlando

Actually Ken, when I run
Get-QADObject -type contact -Identity bjones | fl

I don't see an attribute for address either.  Is there a way to do this from quest?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Akhater

here are the address attributes in get-contact


StreetAddress
PostOfficeBox
City
StateOrProvince
PostalCode
CountryOrRegion
KenMcF

Try it with -includedproperties *

Get-QADObject -type contact -Identity bjones -includedproperties * | fl *
ASKER
jamorlando

Thanks ... I got this figured out.  I'm going to give you guys all credit, cause all 3 of you were very helpful.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.