RE: [ActiveDir] exporting group membership

[joe]

The group membership comes back as DNs. A single subtree scope LDAP command isn't going to resolve that to display names or samaccountnames, etc. There is something special you can do if writing LDAP API code (or S.DS.Protocols). See response I gave just prior to this one.

 

The output format you are describing isn't CSV, you want a report, not a CSV dump. You will need to write a script or find a tool that will do this. 

 

Expanding group memberships (including primary groups, nested groups, etc) is one of the more painful things to do with AD. 

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank Abagnale
Sent: Saturday, November 26, 2005 7:24 AM
To: ActiveDir@mail.activedir.org
Subject: RE: [ActiveDir] exporting group membership

sorry, when I use the csvde command with it's parameters, it exports the data to CSV.

 

When I open the CSV file, I get the member information listed as:

 

CN=Frank Abagnale,OU=UserAccounts,DC=,DC=intara,DC=com;CN=Mike Richards,OU=UserAccounts,DC=intara,DC=com

 

in one cell.

 

How can I list the member without the full dn being displayed e,g just the display name

thanks

Rick Kingslan <[EMAIL PROTECTED]> wrote:

Excel?

 

Otherwise, I'm not completely clear as to what you're trying to accomplish.

 

Rick

--
Posting is provided "AS IS", and confers no rights or warranties ...
 

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank Abagnale
Sent: Friday, November 25, 2005 10:02 AM
To: Active
Subject: [ActiveDir] exporting group membership

I am trying to export the following fields from Active Directory using CSVDE

 

I ran the following command

CSVDE -F c:\output.csv -d "ou=security groups,ou=INTARA,dc=COM" -r "(objectclass=group)" -l cn,d
escription,member,whencreated,whenchanged,info,managedby,mail

 

This retrieves the information I want, however, the Member tab displays a list of users full DN in one single cell and makes it difficult to overview the member list.

 

How can I display a list of the users in there own individual cells going downwards (if that makes sense) does CSVDE allow this? If not any other tools out there?

---

Yahoo! Music Unlimited - Access over 1 million songs. Try it free.

---

Yahoo! DSL Something to write home about. Just $16.99/mo. or less