Go Back   TechArena Community > Technical Support > Computer Help > Windows Server > Windows Server Help
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Export Group membership using script\CSVDE

Windows Server Help


Reply
 
Thread Tools Search this Thread
  #1  
Old 05-10-2007
PK
 
Posts: n/a
Export Group membership using script\CSVDE

Dear All,

Been working on this a whole and im hitting a dead end and need a little help.

I need to either export Group Membersip, (including several LDAP attributes
as below)

CSVDE -f e:\adusers.csv -r objectCategory=person -d
"OU=myOU,DC=MyDomain,dc=co,dc=uk" -l
"userPrincipalName,sAMAccountName,WhenCreated"

This CSVDE script runs through and returns the specified attributes for the
entire OU (myOU), i need to output the same information in the same format
but by Group.

Ideally however id like to output all users within the OU which created in
the last 7 days (but i dont know if this is possible).

Paul


Reply With Quote
  #2  
Old 06-10-2007
Richard Mueller [MVP]
 
Posts: n/a
Re: Export Group membership using script\CSVDE

Paul wrote:

>
> Been working on this a whole and im hitting a dead end and need a little
> help.
>
> I need to either export Group Membersip, (including several LDAP
> attributes
> as below)
>
> CSVDE -f e:\adusers.csv -r objectCategory=person -d
> "OU=myOU,DC=MyDomain,dc=co,dc=uk" -l
> "userPrincipalName,sAMAccountName,WhenCreated"
>
> This CSVDE script runs through and returns the specified attributes for
> the
> entire OU (myOU), i need to output the same information in the same format
> but by Group.
>
> Ideally however id like to output all users within the OU which created in
> the last 7 days (but i dont know if this is possible).


You can export all groups in the OU and their memberships. That may be the
same thing as your request. Use "-r (objectCategory=group)" and "-l
sAMAccountName,member"

This will output sAMAccountName of all groups in the OU, and Distinguished
Names of all members. You cannot retrieve any other attributes of the
members without a more complicated command (if at all).

To output all users created since 20070928000000.0Z (Sept. 28, 2007, at
00:00:00 UTC) use:

-r
"(&(objectCategory=person)(objectClass=user)(whenCreated>=20070928000000.0Z))"

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--


Reply With Quote
  #3  
Old 08-10-2007
PK
 
Posts: n/a
Re: Export Group membership using script\CSVDE

Hi Richard,

Yes have amended as your recomendation and it works fine.

csvde -f C:\Get-Group\report.csv -r
"(&(objectCategory=person)(objectClass=user)(whenCreated>=20071008000000.0Z))" -l userPrincipalName,sAMAccountName -s saturn.lcbt.co.uk

However i only need Accounts created in a specific OU how would i configure
this..?
Because when i insert "OU=myOU,DC=MyDomain,dc=co,dc=uk" it all stops working
again...!

Thanks for all you help,
Paul

"Richard Mueller [MVP]" wrote:

> Paul wrote:
>
> >
> > Been working on this a whole and im hitting a dead end and need a little
> > help.
> >
> > I need to either export Group Membersip, (including several LDAP
> > attributes
> > as below)
> >
> > CSVDE -f e:\adusers.csv -r objectCategory=person -d
> > "OU=myOU,DC=MyDomain,dc=co,dc=uk" -l
> > "userPrincipalName,sAMAccountName,WhenCreated"
> >
> > This CSVDE script runs through and returns the specified attributes for
> > the
> > entire OU (myOU), i need to output the same information in the same format
> > but by Group.
> >
> > Ideally however id like to output all users within the OU which created in
> > the last 7 days (but i dont know if this is possible).

>
> You can export all groups in the OU and their memberships. That may be the
> same thing as your request. Use "-r (objectCategory=group)" and "-l
> sAMAccountName,member"
>
> This will output sAMAccountName of all groups in the OU, and Distinguished
> Names of all members. You cannot retrieve any other attributes of the
> members without a more complicated command (if at all).
>
> To output all users created since 20070928000000.0Z (Sept. 28, 2007, at
> 00:00:00 UTC) use:
>
> -r
> "(&(objectCategory=person)(objectClass=user)(whenCreated>=20070928000000.0Z))"
>
> --
> Richard Mueller
> Microsoft MVP Scripting and ADSI
> Hilltop Lab - http://www.rlmueller.net
> --
>
>
>

Reply With Quote
  #4  
Old 08-10-2007
Richard Mueller [MVP]
 
Posts: n/a
Re: Export Group membership using script\CSVDE

Use the -d switch to specify the root or "base" of the search:

-d "ou=MyOU,dc=MyDomain,dc=co,dc=uk"

You can get syntax help (with a few examples) at a command line on a DC
with:

csvde -?

--
Richard Mueller
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net
--

"PK" <PK@discussions.microsoft.com> wrote in message
news:C5BD4C5F-DB7B-4726-9DFD-1E3A2DDFC39E@microsoft.com...
> Hi Richard,
>
> Yes have amended as your recomendation and it works fine.
>
> csvde -f C:\Get-Group\report.csv -r
> "(&(objectCategory=person)(objectClass=user)(whenCreated>=20071008000000.0Z))"
> -l userPrincipalName,sAMAccountName -s saturn.lcbt.co.uk
>
> However i only need Accounts created in a specific OU how would i
> configure
> this..?
> Because when i insert "OU=myOU,DC=MyDomain,dc=co,dc=uk" it all stops
> working
> again...!
>
> Thanks for all you help,
> Paul
>
> "Richard Mueller [MVP]" wrote:
>
>> Paul wrote:
>>
>> >
>> > Been working on this a whole and im hitting a dead end and need a
>> > little
>> > help.
>> >
>> > I need to either export Group Membersip, (including several LDAP
>> > attributes
>> > as below)
>> >
>> > CSVDE -f e:\adusers.csv -r objectCategory=person -d
>> > "OU=myOU,DC=MyDomain,dc=co,dc=uk" -l
>> > "userPrincipalName,sAMAccountName,WhenCreated"
>> >
>> > This CSVDE script runs through and returns the specified attributes for
>> > the
>> > entire OU (myOU), i need to output the same information in the same
>> > format
>> > but by Group.
>> >
>> > Ideally however id like to output all users within the OU which created
>> > in
>> > the last 7 days (but i dont know if this is possible).

>>
>> You can export all groups in the OU and their memberships. That may be
>> the
>> same thing as your request. Use "-r (objectCategory=group)" and "-l
>> sAMAccountName,member"
>>
>> This will output sAMAccountName of all groups in the OU, and
>> Distinguished
>> Names of all members. You cannot retrieve any other attributes of the
>> members without a more complicated command (if at all).
>>
>> To output all users created since 20070928000000.0Z (Sept. 28, 2007, at
>> 00:00:00 UTC) use:
>>
>> -r
>> "(&(objectCategory=person)(objectClass=user)(whenCreated>=20070928000000.0Z))"
>>
>> --
>> Richard Mueller
>> Microsoft MVP Scripting and ADSI
>> Hilltop Lab - http://www.rlmueller.net
>> --
>>
>>
>>



Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Windows Server > Windows Server Help
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Export Group membership using script\CSVDE"
Thread Thread Starter Forum Replies Last Post
CSVDE code to export without DN attribute LucasYew Windows Software 4 24-04-2009 09:29 AM
Exporting member of a particular group using csvde Graham Active Directory 8 27-03-2008 06:01 PM
csvde export, excluding specific OU's. Vicious Active Directory 10 27-08-2007 06:30 PM
Group membership login script Wooody Small Business Server 1 26-02-2007 04:38 PM
Active Directory Users with Group Membership Export to Excel IJAYA Window 2000 Help 1 18-05-2006 01:31 AM


All times are GMT +5.5. The time now is 11:02 PM.