Sign in with
Sign up | Sign in
Your question

Export "managed by" from active directory

Last response: in Windows 2000/NT
Share
June 29, 2005 6:29:08 AM

Archived from groups: microsoft.public.win2000.active_directory (More info?)

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
Anonymous
June 29, 2005 4:43:57 PM

Archived from groups: microsoft.public.win2000.active_directory (More info?)

greg wrote:
> 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"

--
Tomasz Onyszko
http://www.w2k.pl
June 29, 2005 4:43:58 PM

Archived from groups: microsoft.public.win2000.active_directory (More info?)

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" wrote:

> greg wrote:
> > 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"
>
> --
> Tomasz Onyszko
> http://www.w2k.pl
>
Related resources
Anonymous
June 29, 2005 6:55:37 PM

Archived from groups: microsoft.public.win2000.active_directory (More info?)

greg wrote:
> 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.

--
Tomasz Onyszko
http://www.w2k.pl
Anonymous
June 30, 2005 9:54:32 AM

Archived from groups: microsoft.public.win2000.active_directory (More info?)

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/WindowsSer...
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==?=" <greg@news.postalias>
>References: <C7C31216-E6DC-42E5-9234-637560BFFCAF@microsoft.com>
<urYe3dJfFHA.3124@TK2MSFTNGP12.phx.gbl>
>Subject: Re: Export "managed by" from active directory
>Date: Wed, 29 Jun 2005 05:33:01 -0700
>Lines: 31
>Message-ID: <3DC04AEA-8611-4303-B26B-452D4AD0C5EC@microsoft.com>
>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" wrote:
>
>> greg wrote:
>> > 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"
>>
>> --
>> Tomasz Onyszko
>> http://www.w2k.pl
>>
>
Anonymous
June 30, 2005 1:31:02 PM

Archived from groups: microsoft.public.win2000.active_directory (More info?)

Rebecca Chen [MSFT] wrote:
> 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/WindowsSer...
> 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.


--
Tomasz Onyszko
http://www.w2k.pl
Anonymous
June 30, 2005 1:31:03 PM

Archived from groups: microsoft.public.win2000.active_directory (More info?)

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 <T.Onyszko_nospam_@w2k.pl>
>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: <C7C31216-E6DC-42E5-9234-637560BFFCAF@microsoft.com>
<urYe3dJfFHA.3124@TK2MSFTNGP12.phx.gbl>
<3DC04AEA-8611-4303-B26B-452D4AD0C5EC@microsoft.com>
<IwkD2gTfFHA.1336@TK2MSFTNGXA01.phx.gbl>
>In-Reply-To: <IwkD2gTfFHA.1336@TK2MSFTNGXA01.phx.gbl>
>Content-Type: text/plain; charset=ISO-8859-2; format=flowed
>Content-Transfer-Encoding: 7bit
>Message-ID: <OTpQsWUfFHA.3904@TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.win2000.active_directory
>NNTP-Posting-Host: tide75.microsoft.com 213.199.128.149
>Lines: 1
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.win2000.active_directory:31028
>X-Tomcat-NG: microsoft.public.win2000.active_directory
>
>Rebecca Chen [MSFT] wrote:
>> 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/WindowsSer...
>> 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.
>
>
>--
>Tomasz Onyszko
>http://www.w2k.pl
>
Anonymous
June 30, 2005 3:14:49 PM

Archived from groups: microsoft.public.win2000.active_directory (More info?)

Rebecca Chen [MSFT] wrote:
> Sorry for my incorrect address, Tomasz !

not a problem at all

--
Tomasz Onyszko
http://www.w2k.pl
!