possible to enumerate groups with csvde?

[kokser]

Hello

Currently I am running this command:

csvde -f test.csv -r "(&(objectClass="User")(objectCategory="person"))" -l "name, samaccountname, mail, homedirectory, homedrive, scriptPath"

Is there a way to also enumerate the groups (and OU's?) that every member is in?

 

[kokser]

ALso, is it possible to make it NOT enumerate DN?

 

[kokser]

Oh, and is it possible to only enumerate enabled accounts? Or just exclude disabled?

 

[kokser]

Or alternatively!

Make another csvde where objectclass is group. Easy enough. But I can't figure out how to enumerate the members of every group and OU.

 

[kokser]

Finally figured out how to do it. HOWEVER, it also lists computers now?? I can't quite figure out how to not enumerate them.

Working code:

csvde -f test.csv -r "(|(objectclass="group")(objectclass="user"))

This will also enumerate computers for some reason.

What I've tried:

csvde -f test.csv -r "(!(|(objectclass="group")(objectclass="user"))(objectclass="computer"))"

and some variations

csvde -f test.csv -r "(!(|(objectclass="group")(objectclass="user"))(objectclass!="computer"))"

csvde -f test.csv -r "(&(|(objectclass="group")(objectclass="user"))(objectclass!="computer"))"

And none of them work. Any help appreciated

 

[kokser]

Figured it out again

csvde -f test.csv -r "(&(|(objectclass="group")(objectclass0"user"))(!objectclass="computer"))"

Now I just need hlep to figure out how I can enumerate the members of every group!

 

[kokser]

or alternatively, enumerate the groups that every member is in.

 

[kokser]

I changed to ldifde instead now.

ldifde -f test.txt -r objectclass=group -l "name, member"

How come it also enumerates DN and changetype?

 

[kokser]

Forget that, I went back to excel, but still with ldifde.

ldifde -f test2.csv -r objectclass0group -l "member"

The output is just a bit weird (same thing happens in .txt)
See attachment

 

[kokser]

I decided to go back to txt.

This is what I've got so far:

H:\>ldifde -f test2.txt -d "OU=RKO_Test, DC=AdvizorIT, DC=local" -r objectclass=user -l "name, initials, mail, memberof, homedrive, scriptpath, homedirectory"

But due to unknown reasons, it outputs something called CHANGETYPE and DN.

dn: CN=test,OU=tes_Test,DC=test,DC=local
changetype: add
initials: test
memberOf: CN=test_Test,OU=test_Test,DC=test, DC=local
name: test test
homeDirectory: \\test\test$\test
homeDrive: V:
scriptPath: testscript
mail: test@test.net