Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Option Explicit
Dim aCon, aCMD,aRst,sResultText,Grps,MemberList
Set aCon = CreateObject("ADODB.Connection")
Set aCmd = CreateObject("ADODB.Command")
aCon.provider="ADsDSOObject"
aCon.Open
aCmd.ActiveConnection = aCon
'******************************************************************************
'******************************************************************************
'CUSTOMIZE THE NEXT TWO LINES
aCmd.CommandText="<LDAP://CN=Users,DC=YourComany,DC=com>;" & "(objectClass=group);name,SamAccountName"
dom = "YourDomainName"
'******************************************************************************
'******************************************************************************
Set aRst = aCmd.Execute()
Do While Not aRst.EOF
sResultText = sResultText & aRst.Fields("samAccountName") & vbCrLf
'WScript.Echo aRst.Fields("samAccountName") & vbCrLf
MemberList=RetrieveUsers(dom,aRst.Fields("samAccountName"))
'WScript.Echo Memberlist
sResultText = sResultText & memberlist & vbCrLf & "************************************" & vbCrLf
aRst.MoveNext
Loop
'Wscript.Echo sResultText
Set fso = CreateObject("Scripting.FileSystemObject")
Set ts = fso.CreateTextFile (dom & "DomainGroupUsers.txt", ForWriting)
ts.write sResultText
MsgBox "Done"
'*****************************************************************************************
'*****************************************************************************************
Function RetrieveUsers(domainName,grpName)
dim dom
dim grp
dim GrpObj
dim mbrlist
dim mbr
'-------------------------------------------------------------------------------
' *** Enumerate Group Members ***
'-------------------------------------------------------------------------------
grp = grpName
' Build the ADSI query and retrieve the group object
Set GrpObj = GetObject("WinNT://" & domainName & "/" & grp & ",group")
' Loop through the group membership and build a string containing the names
for each mbr in GrpObj.Members
mbrlist = mbrlist + " " &mbr.name + vbCrLf
Next
'The next line returns mbrlist back up to the main body
RetrieveUsers=mbrlist
End Function