Re: User Reporting

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Johan Arwidmark (johan.please_respond_to_forum.arwidmark_at_lutteman.se)
Date: 05/01/04 

Date: Sat, 01 May 2004 12:58:56 +0200

You can use csvde to export to a comma-separated file and then import
to excel

To export all user and computer accounts
csvde -m -f user-and-computer-list.csv -r "(objectClass=user)" -p
Subtree -l samAccountName

To export all only user accounts
csvde -m -f user-list.csv -r
"(&(objectClass=user)(objectCategory=person))" -p Subtree -l
samAccountName

You can limit your search to a specific OU or Domain using -d

Example:
-d "ou=Sales,dc=lcab,dc=net"

regards
Johan Arwidmark

Windows User Group - Nordic
http://www.wug-nordic.net

On Fri, 30 Apr 2004 21:57:07 -0700, "Steve"
<anonymous@discussions.microsoft.com> wrote:

>Is there anything in AD that will allow me to printout or
>export a report of what users are in AD. I know about the
>export on each OU and the whole domain but that gives me
>computers as well. I only want to a specific report that
>only lists users within the domain.

Relevant Pages

  • Re: CSVDE import failed
    ... sAMAccountName NT name of user TestUser ... The cn attribute must be unique in the container/ou, while sAMAccountName ... Ran CSVDE on the DC logged in as Administrator ...
    (microsoft.public.windows.server.active_directory)
  • Re: Exporting information from AD
    ... Or use the csvde command ... To export all user and computer accounts ... samAccountName ... >I need to export user login Id's from my Active Directory to a test file. ...
    (microsoft.public.win2000.active_directory)
  • Re: Export Group Memberships
    ... If the same can be achieved using csvde. ... If adfind can be used from an admin PC and target to a DC and provide ... I am trying to export a specific AD groups memberships. ... What can we do to get the members samAccountName ...
    (microsoft.public.windows.server.active_directory)