We help IT Professionals succeed at work.

get list of enabled active directory users in excel format

itadminhelp
itadminhelp asked
on
186 Views
Last Modified: 2014-08-28
I want to get list of enabled active directory users in excel format

My scenario:-
All user accounts are under 1 OU (Organisational Unit)  called USERS but there are sub  Organisational units (OU) with users based on the location.
Comment
Watch Question

Mark GalvinPrincipal Consultant
CERTIFIED EXPERT

Commented:
Hi

Do you have access to ADUC?
Principal Consultant
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks Mark,

That worked for me. That query above gives me just heading with username, type and Description.
Is there a way i can get heading of Account status, Firstname and lastname ?
Mark GalvinPrincipal Consultant
CERTIFIED EXPERT

Commented:
Thats just the Columns you have showing in ADUC.

In the Window select View --> Add/Remove Columns

Thanks
Mark/

Author

Commented:
Thanks Mark,

One last thing, I didn't find Account Status Tab (Which says whether account his enabled or disabled) . This is the information what auditor wants to see in the excel report. Is there a way i can get that column in the report?
Mark GalvinPrincipal Consultant
CERTIFIED EXPERT

Commented:
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.