RE: [ActiveDir] exporting group membership

[al_maurer]

If I understand what you want to do correctly, you can parse the contents of individual cells in Excel via the Data -> Text to Columns dropdown dialog.   Al Maurer Service Manager, Naming and Authentication Services IT | Information Technology Agilent Technologies (719) 590-2639; Telnet 590-2639 http://activedirectory.it.agilent.com ----------------------------------------------  "Cry 'Havoc!' and let slip the dogs of war"  - Anthony, in Julius Caesar III i.  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank Abagnale Sent: Saturday, November 26, 2005 5: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: [Activ eDir] 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