How to query the groups a NT domain user belongs to from an excel cvs

[fkane17]

dim dom,un,ls,user
Set WshShell = WScript.CreateObject("WScript.Shell&quot
Set WshEnvironment = WshShell.Environment("Process&quot
dom = WshEnvironment.item("USERDOMAIN&quot
un = WshEnvironment.item("USERNAME&quot
ls = right(WshEnvironment.item("LOGONSERVER&quot,len(WshEnvironment.item("LOGONSERVER&quot) -2)


Set user = GetObject("WinNT://" & dom & "/" & ls & "/" & un)

WScript.Echo "Login Script: " & User.LoginScript
WScript.Echo "Profile: " & User.Profile
WScript.Echo "PasswordExpirationDate: " & User.PasswordExpirationDate
WScript.Echo "HomeDirectory: " & User.HomeDirectory

WScript.Echo "Groups: "

for each Group in User.Groups
WScript.Echo vbtab & Group.name
next

WScript.Echo "LastFailedLogin: " & User.LastFailedLogin

I wrote the code above to check the groupmembership for a user on a particular domain.
I want to check the groupmembership of 300 users.

I have an excel spreadsheep which contain the list of users and the domain they are member.

I am new to wsh scripting. How to I have the script read from the excel file the user id the domain and write the group the user belongs to ?

 

[mrmovie]

open the csv file as a text stream, or open it as a recordset using ADO.
or put the above code into an excel macro and run it from within excel. all the above code will work within VBA. output your results to additional rows/col in the excel spreadsheet/csv file

 

[fkane17]

Thank you mrmovie