How to Export AD in CSV and filter

I want to export a list of active employees from Active Directory.  Also is there a way I could filter the export such that only Active Employees with a phone number are printed?
LVL 2
amigan_99Network EngineerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

CorinTackNetwork EngineerCommented:
In Active Directory, if you right-click on an OU, you can choose to export that OU into a CSV. You can then open that CSV with Excel on any computer, and filter the results however you want.
0
amigan_99Network EngineerAuthor Commented:
So I tried this and it sort of worked.  The problem is that the columns that got exported was a small subset of data.  For example the phone number did not get exported.  Is there a way I can get the phone number included in the output??
0
CorinTackNetwork EngineerCommented:
The information that is exported is what you have displayed in Active Directory at the time. Anything you want to export, you'll need to add the column with that information to your AD display, then do the export again.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
amigan_99Network EngineerAuthor Commented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server OS

From novice to tech pro — start learning today.