SharePoint 2013 批量导入、删除帐号

删除一个group里所有的帐号：

cls

###########################

# "Enter the site URL here"

$SITEURL = "http://xxx/IT"

# "Name of Site group from which users have to be removed"

$SITEGROUP = "Portal Information Technology Visitors"

###########################

$site = new-object Microsoft.SharePoint.SPSite ( $SITEURL )

$web = $site.OpenWeb()

"Web is : " + $web.Title

$oSiteGroup = $web.SiteGroups[$SITEGROUP];

"Site Group is :" + $oSiteGroup.Name

$oUsers = $oSiteGroup.Users

foreach ($oUser in $oUsers)

{

    "Removing user : " + $oUser.Name

    $oSiteGroup.RemoveUser($oUser)

}

######################################################################################################

批量导入帐号：

###########################################################################################

#

# Title: Add-SPUser_Group.ps1

#

# Description: Adds a group of users to a SharePoint group via an answer file

#

# URL: http://techchucker.wordpress.com/2013/09/17/addbulkspusergroups/

#

# Author: Matt Anderson

# Created: 9-13-2013

#

##########################################################################################

#Region Action Function

#Action taken via user input based on menu option chosen

Function Action ($result)

{

    if ($result -eq "A")

    {

        AnswerCreate

    }

    if ($result -eq "B")

    {

    }

    if ($result -eq "?")

    {

        clear

        #Opens Default Internet browser and navigates to the below site that holds the instructions for this program

        Start-Process -FilePath "http://techchucker.wordpress.com/2013/09/17/addbulkspusergroups/"

    }

}

#endRegion

#Region PressKey Function

#User must enter any key to continue

Function PressKey

{

    Write-Host "Press any key to continue..." -ForegroundColor Black -BackgroundColor White

    $x = $Host.UI.RawUI.ReadKey("NoEcho,IncludeKeyUp,AllowCtrlC")

    return clear

}

#endRegion

#Region WebInput Function

#Function to request web input from user

Function WebInput

{

    $inpWeb = Read-Host "Enter the URL of the site to add users to a group"

    return $inpWeb

}

#endRegion

#Region GroupInput Function

#Function to request SharePoint Group input from user

Function GroupInput

{

    $inpGroup = Read-Host "Enter the SharePoint Group ID to add users to"

    return $inpGroup

}

#endRegion

#Region AnswerCeate Function

#Function to take answer file and add multiple users to SharePoint Group

Function AnswerCreate

{

    clear

    #Imports user inputted answer file

    $userList = Import-Csv ($answerFile = Read-Host "Enter path to Answer File (e.g. c:\filename.csv)")

    $web = WebInput

    $group = GroupInput

    Write-Output $userList

    PressKey

    #Iterates through each record storing variables and executing user add

    ForEach ($user in $userList)

    {

        $validateUser = $null

        $LANID = $user."LANID"

        $validateUser = Get-SPUser -Identity $LANID -Web $web -ErrorAction SilentlyContinue #This will throw an error if the user does not exist

        if($validateUser -eq $null)

        {

            Write-Host $LANID "does not exist"

            New-SPUser -UserAlias $LANID -Web $web -group $group

            Write-Host $LANID "created and added to " $group

        }

        else

        {

            #Adds user/s to the SharePoint group

            Set-SPUser -Identity $LANID -Web $web -Group $group

            Write-Host $LANID "has been added to "$group

        }

    }

}

#endRegion

#Region Menu Function

#Function to display the menu for the program

Function Menu

{

    Write-Host "Add Users to SP Groups in Bulk`n`n" -ForegroundColor Black -BackgroundColor White

    Write-Host "Choose the action you would like to perform shown below.`n`n"

    Write-Host "    A    -    Add users in bulk using Answer File`n"

    Write-Host "    ?    -    Program Help`n"

    Write-Host "    Exit    Exits this program`n`n"

}

#endRegion

#Region Program Actions

$ErrorActionPreference="SilentlyContinue"

Stop-Transcript | out-null

$ErrorActionPreference = "Continue"

$logPath = Read-Host "Enter log path (c:\Logs)"

$date = Get-Date -UFormat %y%m%d.%H.%M.%S

$logFile = "\" + $date + "_AddUserGroup.txt"

Start-Transcript -path $logPath$logFile -append

do

{

    clear

    Menu

    $result = Read-Host "Enter your selection"

    if($result -ne "exit")

    {

        Action $result

        #Write-Host "Would you like to return to the main menu?`n`n"

        #$confirm = Confirm ($inp = Read-Host "Enter Y or N")

        $confirm = $True

    }

    else

    {

        $confirm = $false

    }

}

while($confirm -eq $True)

Stop-Transcript

#endRegion

帐号放到一个csv文件里，如下图：

执行步骤：

1. 运行上面的ps1脚本，输入log的path：

2. 输入A：

3. 输入site url和group id：

4. 输入帐号列表的csv文件：