Export "managed by" from active directory

[Guest]

Hi,

I need to export a list of all universal distributions groups in a certain
OU with the "managed by" person.
If I navigate to the correct OU, I can sort the type to ge a list of all
universal distribution groups, but I can't add the "managed by" column.
If I set a filter to set specific options for the "managed by" field, I need
to add a username, not present etc.
What I need is a list that I can export to excel with all these users.

If anyone has an idea?

Thanks,

Greg

 

[Tomasz Onyszko]

Hi,

I need to export a list of all universal distributions groups in a certain
OU with the "managed by" person.
If I navigate to the correct OU, I can sort the type to ge a list of all
universal distribution groups, but I can't add the "managed by" column.
If I set a filter to set specific options for the "managed by" field, I need
to add a username, not present etc.
What I need is a list that I can export to excel with all these users.

If anyone has an idea?

csvde -f ou.csv -s <DC> -d "DC=domain,DC=com"
-r"(objectClass=organizationalUnit") -l "distinguishedName,managedBy"

 

[Guest]

Ok, thanks for the info.
But I don't know exactly how to use it!
Could you clarify a bit for me please?

Thanks,

Greg

 

[Tomasz Onyszko]

Ok, thanks for the info.
But I don't know exactly how to use it!
Could you clarify a bit for me please?

CSVDE is command line tool which lets You export some data from AD to
comma separted file. You have to run this command line which I gave You
in my previous post on the DC or workstation connected to domain and as
an output You will get CSV file (ou.csv) with Distinguished name and
managedby values for OUs in domain.

-d switch specifies the base for the search (in this sample it is whole
domain domain.com)

-l switch lets You specify which attributes for OUs You will get in output

-s is a name of a DC to which You want to connect

DCS file can be easily imported to Excel.

 

[Rebecca Chen [MSFT]]

Hi Tomasz ,

I believe Greg has provided very good info. Here, I would like to list the
following articles which address CSVDE for your reference:
Import or export directory objects using csvde
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003R2Beta2/Librar
y/ADAM/e1e94278-87b5-4394-af49-db07143be6f7.mspx

How to use Csvde to import contacts and user objects into Active Directory
http://support.microsoft.com/default.aspx?scid=kb;en-us;327620

Any update, let's get in touch!

Best regards,

Rebecca Chen

MCSE2000 MCDBA CCNA


Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security

=====================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Thread-Topic: Export "managed by" from active directory
thread-index: AcV8prBZnnJBK93RSqSRRfZvG2+7tg==
X-WBNR-Posting-Host: 195.124.18.133
From: "=?Utf-8?B?Z3JlZw==?=" <[email protected]>
References: <[email protected]>

Subject: Re: Export "managed by" from active directory
Date: Wed, 29 Jun 2005 05:33:01 -0700
Lines: 31
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.win2000.active_directory
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.win2000.active_directory:30996
X-Tomcat-NG: microsoft.public.win2000.active_directory

Ok, thanks for the info.
But I don't know exactly how to use it!
Could you clarify a bit for me please?

Thanks,

Greg

 

[Tomasz Onyszko]

Hi Tomasz ,

I believe Greg has provided very good info. Here, I would like to list the
following articles which address CSVDE for your reference:
Import or export directory objects using csvde
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003R2Beta2/Librar
y/ADAM/e1e94278-87b5-4394-af49-db07143be6f7.mspx

How to use Csvde to import contacts and user objects into Active Directory
http://support.microsoft.com/default.aspx?scid=kb;en-us;327620

Any update, let's get in touch!

Hi Rebecca,

I know this that's why I pointed Greg to csvde as a tool.

 

[Rebecca Chen [MSFT]]

Sorry for my incorrect address, Tomasz !

I replied to Greg that you have provided very good info.

Greg, please try csvde to test the result and post back if you have any
udpate.

Best regards,

Rebecca Chen

MCSE2000 MCDBA CCNA


Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security

=====================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

Date: Thu, 30 Jun 2005 09:31:02 +0200
From: Tomasz Onyszko <[email protected]>
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: Export "managed by" from active directory
References: <[email protected]>

<[email protected]>

 

[Tomasz Onyszko]

Sorry for my incorrect address, Tomasz !

not a problem at all