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
> >> --
> >>
> >>
> >>
>
>
>