RE: [ActiveDir] exporting group membership

[Frank Abagnale]

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