Richard

Got the script to run no errors occour.
However no CSV is generated, nor output made.

Paul

"PK" wrote:

> Hi Richard
>
> The "H" represents the current year of students. Eg next year will be "I"
> the groups are always 4 digits long EG I301 H508
>
> Heres the over all of what i need to acomplish.
> my -I commmands are a little over anxious and were in use for other quiries
> testing.
>
> In this instance i realy only need forename (LDAP= givenName) to be
> generated to the .csv it should automatically go in coloum B as DN ocupies
> column (A by default it seems).
> then i need to delete Column A
> and run a formula against the remainig data.
> so i can generate first 3 letters of forename in lowercase and that is all
> that is left in my .csv file
>
> This will then be used in conjunction with a password generator to output:
>
> 2 numbers and a special caracter.
> then auto save this as a .txt file.
>
> My developers have written an app which will import the data left over to a
> field in AD and resep the password aswell
>
> Thanks for all your assistance im learning loads powerfull tools..!
> Paul
>
> "Richard Mueller [MVP]" wrote:
>
> > You can prompt in vb or VBScript. The trick is how to prompt for multiple
> > values. Do you always prompt for 4 values, or keep prompting until the user
> > enters a blank? Do you assume the parent container/OU of the groups? Do you
> > prompt for Common Name or just a 3 digit number and append "H" to it. An
> > example could be (not tested):
> >
> > ' Prompt for group names and construct the filter.
> > strCN = ""
> > strFilter = "(|"
> > Do
> > strCN = InputBox("Enter Common Name of a group or Cancel", "Test")
> > If (strCN <> "") Then
> > strFilter = strFilter & "(memberOf=cn=" & strCN _
> > & ",ou=mygp,dc=mydom,dc=co,dc=uk)"
> > End If
> > Loop While strCN <> ""
> >
> > strFilter = strFilter & ")"
> >
> > ' Use the WshShell object to run the csvde command.
> > If strFilter <> "(|)" Then
> > Set objShell = CreateObject("Wscript.Shell")
> > strCmd = "%comspec% /c csvde c:\get-group\GroupMembers.csv -r " &
> > strFilter
> > strCmd = strCmd & " -l
> > sAMAccountName,givenName,physicalDeliveryOfficeNam e,memberOf "
> > strCmd = strCmd & "-SERVER.DOM.co.uk"
> > objShell.Run strCmd
> > End If
> >
> > --
> > Richard Mueller
> > Microsoft MVP Scripting and ADSI
> > Hilltop Lab - http://www.rlmueller.net
> > --
> >
> > "PK" <PK@discussions.microsoft.com> wrote in message
> > news:2F8920ED-31C0-403A-A615-A348A5A8CF45@microsoft.com...
> > > Rich can this be built in to VB some how..?
> > >
> > > with like a window to promps for group numbers..?
> > >
> > > other than that works a charm
> > >
> > > "Richard Mueller [MVP]" wrote:
> > >
> > >> Paul wrote:
> > >>
> > >> > I got the below to work ok, ( I can also export the entire OU)
> > >> >
> > >> > csvde -f C:\Get-Group\GroupMembers.csv -r
> > >> > "memberOf=cn=H050,ou=mygp,dc=mydom,dc=co,dc=uk " -l
> > >> > "sAMAccountName,givenName,physicalDeliveryOfficeNa me,memberOf"
> > >> > -SERVER.DOM.co.uk
> > >> >
> > >> > But i need to export all members of just 4 groups (from the same OU)
> > >> > Not
> > >> > just H050 ie i need to include H051 H052 H053 also..
> > >> >
> > >> > Any options \ideas.
> > >> >
> > >>
> > >> The syntax for the filter would be (watch line wrapping):
> > >>
> > >> -r
> > >> "(|(memberOf=cn=H050,ou=mygp,dc=mydom,dc=co,dc=uk) (memberOf=cn=H051,ou=mygp,dc=mydom,dc=co,dc=uk)(me mberOf=cn=H052,ou=mygp,dc=mydom,dc=co,dc=uk)(membe rOf=cn=H053,ou=mygp,dc=mydom,dc=co,dc=uk))"
> > >>
> > >> Wildcards are not allowed and you must specify the full distinguished
> > >> names.
> > >> The "|" (pipe symbol) is the "OR" operator.
> > >>
> > >> --
> > >> Richard Mueller
> > >> Microsoft MVP Scripting and ADSI
> > >> Hilltop Lab - http://www.rlmueller.net
> > >> --
> > >>
> > >>
> > >>
> >
> >
> >