Hi Richard,
Yes have amended as your recomendation and it works fine.
csvde -f C:\Get-Group\report.csv -r
"(&(objectCategory=person)(objectClass=user)(whenC reated>=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 ,
Paul
"Richard Mueller [MVP]" wrote:
> Paul wrote:
>
> >
> > Been working on this a whole and im hitting a dead end and need a little
> > .
> >
> > 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)(whenC reated>=20070928000000.0Z))"
>
> --
> Richard Mueller
> Microsoft MVP Scripting and ADSI
> Hilltop Lab - http://www.rlmueller.net
> --
>
>
>