Re: Export Member from a Security Group

Sorry, I meant replace all instances of ; with ",".

Richard

"Richard Mueller" <rlmueller-NOSPAM@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:eochEBhHHHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
The csvde command places all of the member DN's in one field, enclosed
with quotes because there are embedded commas. The DN's in this field are
delimited by semicolons. One solution would be to open the csv file in a
text editor and replace all instances of ; with ";". Then when the csv
file is imported into Excel, each DN will be in it's own cell.

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net

"Correy" <Correy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7ECE182F-F4E2-4684-AF06-5421B6F278E5@xxxxxxxxxxxxxxxx
Richard, That worked just like you said, but the only problem is that it
puts
all the members in one cell with all of the information I don't need like
this:
CN=MemberName,OU=Users,OU=City,OU=Organization,DC=Domain,DC=DomainName,DC=org;

Is there anyway to get it a little cleaner? I was hoping for one member
name per cell? Is that possible?

Thanks

"Richard Mueller" wrote:

Correy wrote:

Is there a command or utility I can use to export the list of members
contained in a security group to a .cvs file? If so, an example of
the
command would be great!! Or where to get the utility from.

You can use the command line utility csvde, found on any DC. For
example, to
export all members of group with NetBIOS name TestGroup to a file called
report.csv:

csvde -f report.csv -r "(sAMAccountName=TestGroup)" -l member

There is help at the DC command line, or you can search for info on the
Microsoft web site. Another option would be Joe Richards' free utility
adfind available on his web site:

www.joeware.net

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net







.

Relevant Pages

  • Four in 9/11 Plot Are Called Tied to Qaeda in 00
    ... three other future hijackers as likely members of a cell of Al Qaeda ... said, apparently at least in part because Mr. Atta, and the others were in ... A former spokesman for the Sept. 11 commission, Al Felzenberg, confirmed ... American-based "Brooklyn" cell, as one of five such Al Qaeda cells around ...
    (alt.true-crime)
  • Re: CSVDE Multiple group export..
    ... I never even checked the syntax of the command. ... Watch line wrapping: ... Microsoft MVP Scripting and ADSI ...
    (microsoft.public.windows.server.scripting)
  • RE: Looping with Userform
    ... Prior to this section the cursor is ... placed in the first cell of the order section via RANGE.Select. ... Knowing what global variables I need and how to declare them. ... This userform has two command buttons: ...
    (microsoft.public.excel.programming)
  • Re: Command Button "Find"
    ... "Search" on the bottom of each form where they can find members there. ... The popup form is not. ... Allen Browne - Microsoft MVP. ... has command buttons on it that goes to my forms/reports. ...
    (microsoft.public.access.forms)
  • Re: GUI for access 2002
    ... 1.I execute a command button that loads the form with data from a members ...
    (microsoft.public.access.gettingstarted)