• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 37
  • Last Modified:

Excel 2016 import data from Active Diretory

Excel 2016 import data from Active Diretory

How do I limit import to an OU (and subs OUs)
0
mikeydk
Asked:
mikeydk
  • 3
1 Solution
 
Jian An LimSolutions ArchitectCommented:
your question is vague.

you want to import data from Active directory to Excel
what data you are looking for?
0
 
mikeydkAuthor Commented:
Would like to import users.

Samaccountname, DIsplayname, CN, extensionattribute1.
0
 
Jian An LimSolutions ArchitectCommented:
first, you need to run this on domain controller that have active directory powershell

import-module activedirectory
get-aduser -Properties samaccountname,displayname,cn,extensionattribute1 -filter * -searchbase "OU=ac,DC=domain,DC=local" | select samaccountname,displayname,cn,extensionattribute1 | export-csv c:\temp\activeuser.csv -NoTypeInformation

then you can open the csv file in excel
0
 
Jian An LimSolutions ArchitectCommented:
provide the exact command for the result
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now