Solved

Remove groups from users different groups from different users. File as this.

Posted on 2008-10-03
11
214 Views
Last Modified: 2012-05-05
Hi,

Remove groups from users different groups from different users. File as this.

I have a txt file as
Username,Group1,Group3
Username1,Groups3,Group4
Username2,Group6,Group1

So when script run has to query the first name and remove just these groups next to the users.
So each user may have different groups for each. Any way of doing this.

Regards
Sharath
0
Comment
Question by:bsharath
  • 6
  • 5
11 Comments
 
LVL 5

Expert Comment

by:si_shamil
ID: 22639019
Are you have an Active Directory environment or you just want it for Local computer?
0
 
LVL 11

Author Comment

by:bsharath
ID: 22639760
Its an Active directory environment
0
 
LVL 5

Expert Comment

by:si_shamil
ID: 22640586
Use this script, save it to "DeleteFromGroup.vbs"
Note: Runt it from command line!!!

Usage: cscript //NoLogo DeleteFromGroup.vbs --usersfile <file_path>
Example: cscript //NoLogo DeleteFromGroup.vbs --usersfile users.txt
'===============================================================================

' Script Name  : DeleteFromGroup.vbs

' Usage Syntax : cscript.exe //NoLogo DeleteFromGroup.vbs --usersfile <file_path>

' Author       : Alex Simenduev, PlanetIT.WS (http://www.planetit.ws)

' Version      : 1.0.1

' LastModified : 5/10/2008

' Description  : Removes users from groups by parsing a users text file.

'                Users file syntax: <USERNAME>.<GROUP[,GROUP[,...]]>

'                Example:

'                         user1, group1, group2

'                         user4, group8, group2, group3, group10

'===============================================================================

Option Explicit
 

' Global Variables

Dim gsUsage : gsUsage = "Usage: " & Wscript.ScriptName & " --usersfile <file_path>"

Dim gsFile, goFile, gsLine, gaSplitedLine, gsUser, gsGroup, gsUserDN, gsGroupDN
 

' Parse Command Line arguments

If Wscript.Arguments.Count = 2 Then

    If Lcase(Wscript.Arguments.Item(0)) = "--usersfile" Then

        gsFile = Wscript.Arguments.Item(1)

    Else

        Wscript.Echo gsUsage

        Wscript.Quit    

    End If

Else

    Wscript.Echo gsUsage

    Wscript.Quit

End If
 

Wscript.Echo "Opening Users file ('" & gsFile & "')..."

If openUserFile(gsFile) Then

    While Not goFile.AtEndOfStream

        gsLine = goFile.ReadLine

        

        ' Skip empty lines

        If gsLine <> "" Then

            gaSplitedLine = Split(gsLine, ",")

            If Ubound(gaSplitedLine) = 0 Then

                Wscript.Echo "Line '" & gsLine & "' cannot be parsed, skipping..."

            Else

                gsUser = Trim(gaSplitedLine(0))

                gsUserDN = GetUserDN(gsUser)

                

                Dim i : For i = 1 to Ubound(gaSplitedLine)

                    gsGroup = Trim(gaSplitedLine(i))

                    gsGroupDN = GetGroupDN(gsGroup)

                    

                    If gsUserDN <> "" AND gsGroupDN <> "" Then

                        Wscript.StdOut.Write "Removing user '" & gsUser & "' from '" & gsGroup & "' group..."

                        If removeUserFromGroup(gsUserDN, gsGroupDN) Then Wscript.Echo "Sucsess."

                    End If

                Next

            End If

        End If

    Wend

    

    goFile.Close

End If
 

'===============================================================================

' Function Name  : openUserFile(pFileName)

' Return value   : Boolean (True or False)

' Author         : Alex Simenduev, www.planetit.ws

' Date           : 04/10/2008

' Description    : Opens a file with user/group info

'===============================================================================

Function openUserFile(pFileName) : openUserFile = False : On Error Resume Next 

    Dim objFSO  : Set objFSO = CreateObject("Scripting.FileSystemObject")

    

    If objFSO.FileExists(pFileName) Then

        Set goFile = objFSO.OpenTextFile(pFileName)

        If Err.Number = 0 Then openUserFile = True

    Else

        Wscript.Echo "File '" & pFileName & "' not exists."

    End If

    

    Set objFile = Nothing

    Set objFSO = Nothing

End Function
 

'===============================================================================

' Function Name  : removeUserFromGroup(pUserDN, pGroupDN)

' Return value   : Boolean (True or False)

' Author         : Alex Simenduev, www.planetit.ws

' Date           : 04/10/2008

' Description    : Removes a given user from given group

'===============================================================================

Function removeUserFromGroup(pUserDN, pGroupDN) : removeUserFromGroup = False : On Error Resume Next

    Dim objGroup    : Set objUser = GetObject("LDAP://" & pUserDN)

    Dim objUser     : Set objGroup = GetObject("LDAP://" & pGroupDN)    
 

    If objGroup.IsMember(objUser.AdsPath) Then

        objGroup.Remove(objUser.AdsPath)

        If Err.Number = 0 Then removeUserFromGroup = True

    Else

        Wscript.Echo "Failed (not member of '" & objGroup.cn & "')."

    End If
 

    Set objGroup = Nothing

    Set objUser = Nothing

End Function
 

'===============================================================================

' Function Name  : getUserDN(pUserName)

' Return value   : String of Distinguished Name

' Author         : Alex Simenduev, www.planetit.ws

' Date           : 04/10/2008

' Description    : Gets the Distinguished Name from the given user name

'===============================================================================

Function getUserDN(pUserName) : getUserDN = "" : On Error Resume Next

    Dim objRootDSE  : Set objRootDSE = GetObject("LDAP://RootDSE")

    Dim strDomainDN : strDomainDN = objRootDSE.Get("defaultNamingContext")
 

    Dim strBase     : strBase	= "<LDAP://" & strDomainDN & ">;"    

    Dim strFilter   : strFilter	= "(&(objectCategory=person)(objectClass=user)(sAMAccountname=" & pUserName & "));"

    Dim strAttrs    : strAttrs	= "distinguishedName;"

    Dim strScope    : strScope	= "subtree"
 

    Dim objConn     : Set objConn = CreateObject("ADODB.Connection")

    objConn.Open "Provider=ADsDSOObject;"
 

    Dim objRS       : Set objRS = objConn.Execute(strBase & strFilter & strAttrs & strScope)

    If Err.Number <> 0 Then

        ' Query failed

        Wscript.Echo "User name lookup for '" &  pUserName & "' failed, error number: " & Err.Number

        Exit Function

    End If

    

    ' Query succeeded

    If objRS.RecordCount = 0 Then

        WScript.Echo "User '" & pUserName & "' not found."

    Else

        objRS.MoveFirst

        getUserDN = objRS.Fields("distinguishedName")

    End If
 

    Set objRS = Nothing 

    Set objConn = Nothing

    Set objRootDSE = Nothing

End Function
 

'===============================================================================

' Function Name  : getGroupDN(pUserName)

' Return value   : String of Distinguished Name

' Author         : Alex Simenduev, www.planetit.ws

' Date           : 04/10/2008

' Description    : Gets the Distinguished Name from the given group name

'===============================================================================

Function getGroupDN(pGroupName) : getGroupDN = "" : On Error Resume Next

    Dim objRootDSE  : Set objRootDSE = GetObject("LDAP://RootDSE")

    Dim strDomainDN : strDomainDN = objRootDSE.Get("defaultNamingContext")
 

    Dim strBase     : strBase	= "<LDAP://" & strDomainDN & ">;"    

    Dim strFilter   : strFilter	= "(&(objectCategory=group)(cn=" & pGroupName & "));"

    Dim strAttrs    : strAttrs	= "distinguishedName;"

    Dim strScope    : strScope	= "subtree"
 

    Dim objConn     : Set objConn = CreateObject("ADODB.Connection")

    objConn.Open "Provider=ADsDSOObject;"
 

    Dim objRS       : Set objRS = objConn.Execute(strBase & strFilter & strAttrs & strScope)

    If Err.Number <> 0 Then

        ' Query failed

        Wscript.Echo "Group name lookup for '" &  pGroupName & "' failed, error number: " & Err.Number

        Exit Function

    End If

    

    ' Query succeeded

    If objRS.RecordCount = 0 Then

        WScript.Echo "Group '" & pGroupName & "' not found."

    Else

        objRS.MoveFirst

        getGroupDN = objRS.Fields("distinguishedName")

    End If
 

    Set objRS = Nothing 

    Set objConn = Nothing

    Set objRootDSE = Nothing

End Function

Open in new window

0
 
LVL 11

Author Comment

by:bsharath
ID: 22640612
Thank U... Will this work for groups that are on the root Domain?
0
 
LVL 5

Expert Comment

by:si_shamil
ID: 22640635
No it will work for domain that running user belongs to.
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 11

Author Comment

by:bsharath
ID: 22640664
Can you add the case to remove the groups no matter which domain they are.

I have users who are a member of a group in the local domain and the root domain too....
0
 
LVL 5

Expert Comment

by:si_shamil
ID: 22640701
The script is not an issue, it can be changed to work with all Forest easily. The issue is your txt file.
If you have group in local domain with same name that in root doamin, then it is impossible to know what group you meant when specified in the TXT file.

0
 
LVL 11

Author Comment

by:bsharath
ID: 22640724
It works perfect on a local Domain....
Thank U
Can you add the functionality to remove groups even if the user is a member in the root domain
0
 
LVL 11

Author Comment

by:bsharath
ID: 22640729
No i will no way have that senario.... The groups are unique.
Only case we need to think is if the groups name is "India" then it has to remove just "India" not groups as "India1" or "1_India"

Only if found exact match then remove...
0
 
LVL 5

Accepted Solution

by:
si_shamil earned 500 total points
ID: 22640755
OK, up to you, if you do have similar names across domains, then script may remove wrong group from the user.

Regarding the group name, it will search only for exact name, so don't worry

Here is a changed script.
'===============================================================================

' Script Name  : DeleteFromGroup.vbs

' Usage Syntax : cscript.exe //NoLogo DeleteFromGroup.vbs --usersfile <file_path>

' Author       : Alex Simenduev, PlanetIT.WS (http://www.planetit.ws)

' Version      : 1.0.1

' LastModified : 5/10/2008

' Description  : Removes users from groups by parsing a users text file.

'                Users file syntax: <USERNAME>.<GROUP[,GROUP[,...]]>

'                Example:

'                         user1, group1, group2

'                         user4, group8, group2, group3, group10

'===============================================================================

Option Explicit

 

' Global Variables

Dim gsUsage : gsUsage = "Usage: " & Wscript.ScriptName & " --usersfile <file_path>"

Dim gsFile, goFile, gsLine, gaSplitedLine, gsUser, gsGroup, gsUserDN, gsGroupDN

 

' Parse Command Line arguments

If Wscript.Arguments.Count = 2 Then

    If Lcase(Wscript.Arguments.Item(0)) = "--usersfile" Then

        gsFile = Wscript.Arguments.Item(1)

    Else

        Wscript.Echo gsUsage

        Wscript.Quit    

    End If

Else

    Wscript.Echo gsUsage

    Wscript.Quit

End If

 

Wscript.Echo "Opening Users file ('" & gsFile & "')..."

If openUserFile(gsFile) Then

    While Not goFile.AtEndOfStream

        gsLine = goFile.ReadLine

        

        ' Skip empty lines

        If gsLine <> "" Then

            gaSplitedLine = Split(gsLine, ",")

            If Ubound(gaSplitedLine) = 0 Then

                Wscript.Echo "Line '" & gsLine & "' cannot be parsed, skipping..."

            Else

                gsUser = Trim(gaSplitedLine(0))

                gsUserDN = GetUserDN(gsUser)

                

                Dim i : For i = 1 to Ubound(gaSplitedLine)

                    gsGroup = Trim(gaSplitedLine(i))

                    gsGroupDN = GetGroupDN(gsGroup)

                    

                    If gsUserDN <> "" AND gsGroupDN <> "" Then

                        Wscript.StdOut.Write "Removing user '" & gsUser & "' from '" & gsGroup & "' group..."

                        If removeUserFromGroup(gsUserDN, gsGroupDN) Then Wscript.Echo "Sucsess."

                    End If

                Next

            End If

        End If

    Wend

    

    goFile.Close

End If

 

'===============================================================================

' Function Name  : openUserFile(pFileName)

' Return value   : Boolean (True or False)

' Author         : Alex Simenduev, www.planetit.ws

' Date           : 04/10/2008

' Description    : Opens a file with user/group info

'===============================================================================

Function openUserFile(pFileName) : openUserFile = False : On Error Resume Next 

    Dim objFSO  : Set objFSO = CreateObject("Scripting.FileSystemObject")

    

    If objFSO.FileExists(pFileName) Then

        Set goFile = objFSO.OpenTextFile(pFileName)

        If Err.Number = 0 Then openUserFile = True

    Else

        Wscript.Echo "File '" & pFileName & "' not exists."

    End If

    

    Set objFile = Nothing

    Set objFSO = Nothing

End Function

 

'===============================================================================

' Function Name  : removeUserFromGroup(pUserDN, pGroupDN)

' Return value   : Boolean (True or False)

' Author         : Alex Simenduev, www.planetit.ws

' Date           : 04/10/2008

' Description    : Removes a given user from given group

'===============================================================================

Function removeUserFromGroup(pUserDN, pGroupDN) : removeUserFromGroup = False : On Error Resume Next

    Dim objGroup    : Set objUser = GetObject("LDAP://" & pUserDN)

    Dim objUser     : Set objGroup = GetObject("LDAP://" & pGroupDN)    

 

    If objGroup.IsMember(objUser.AdsPath) Then

        objGroup.Remove(objUser.AdsPath)

        If Err.Number = 0 Then removeUserFromGroup = True

    Else

        Wscript.Echo "Failed (not member of '" & objGroup.cn & "')."

    End If

 

    Set objGroup = Nothing

    Set objUser = Nothing

End Function

 

'===============================================================================

' Function Name  : getUserDN(pUserName)

' Return value   : String of Distinguished Name

' Author         : Alex Simenduev, www.planetit.ws

' Date           : 04/10/2008

' Description    : Gets the Distinguished Name from the given user name

'===============================================================================

Function getUserDN(pUserName) : getUserDN = "" : On Error Resume Next

    Dim objRootDSE  : Set objRootDSE = GetObject("LDAP://RootDSE")

    Dim strDomainDN : strDomainDN = objRootDSE.Get("defaultNamingContext")

 

    Dim strBase     : strBase	= "<LDAP://" & strDomainDN & ">;"    

    Dim strFilter   : strFilter	= "(&(objectCategory=person)(objectClass=user)(sAMAccountname=" & pUserName & "));"

    Dim strAttrs    : strAttrs	= "distinguishedName;"

    Dim strScope    : strScope	= "subtree"

 

    Dim objConn     : Set objConn = CreateObject("ADODB.Connection")

    objConn.Open "Provider=ADsDSOObject;"

 

    Dim objRS       : Set objRS = objConn.Execute(strBase & strFilter & strAttrs & strScope)

    If Err.Number <> 0 Then

        ' Query failed

        Wscript.Echo "User name lookup for '" &  pUserName & "' failed, error number: " & Err.Number

        Exit Function

    End If

    

    ' Query succeeded

    If objRS.RecordCount = 0 Then

        WScript.Echo "User '" & pUserName & "' not found."

    Else

        objRS.MoveFirst

        getUserDN = objRS.Fields("distinguishedName")

    End If

 

    Set objRS = Nothing 

    Set objConn = Nothing

    Set objRootDSE = Nothing

End Function

 

'===============================================================================

' Function Name  : getGroupDN(pUserName)

' Return value   : String of Distinguished Name

' Author         : Alex Simenduev, www.planetit.ws

' Date           : 04/10/2008

' Description    : Gets the Distinguished Name from the given group name

'===============================================================================

Function getGroupDN(pGroupName) : getGroupDN = "" : On Error Resume Next

    Dim objRootDSE  : Set objRootDSE = GetObject("LDAP://RootDSE")

    Dim strDomainDN : strDomainDN = objRootDSE.Get("defaultNamingContext")

 

    Dim strBase     : strBase	= "<GC://" & strDomainDN & ">;"    

    Dim strFilter   : strFilter	= "(&(objectCategory=group)(cn=" & pGroupName & "));"

    Dim strAttrs    : strAttrs	= "distinguishedName;"

    Dim strScope    : strScope	= "subtree"

 

    Dim objConn     : Set objConn = CreateObject("ADODB.Connection")

    objConn.Open "Provider=ADsDSOObject;"

 

    Dim objRS       : Set objRS = objConn.Execute(strBase & strFilter & strAttrs & strScope)

    If Err.Number <> 0 Then

        ' Query failed

        Wscript.Echo "Group name lookup for '" &  pGroupName & "' failed, error number: " & Err.Number

        Exit Function

    End If

    

    ' Query succeeded

    If objRS.RecordCount = 0 Then

        WScript.Echo "Group '" & pGroupName & "' not found."

    Else

        objRS.MoveFirst

        getGroupDN = objRS.Fields("distinguishedName")

    End If

 

    Set objRS = Nothing 

    Set objConn = Nothing

    Set objRootDSE = Nothing

End Function

Open in new window

0
 
LVL 11

Author Comment

by:bsharath
ID: 22640762
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have published numerous articles here at Experts Exchange that present programs/scripts written in a language called AutoHotkey. Each of those articles has a brief paragraph describing where to download the product and how to install it. I have al…
This article will show, step by step, how to integrate R code into a R Sweave document
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
The viewer will learn how to dynamically set the form action using jQuery.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now