August 2017 – PhoeNIXBird Networks

[SPS 2013] Get a list of all the documents in SPS via PS

August 20, 2017 Andrei Rachita 0

Here goes:

function Get-DocInventory() {
    [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
    $farm = [Microsoft.SharePoint.Administration.SPFarm]::Local
    foreach ($spService in $farm.Services) {
        if (!($spService -is [Microsoft.SharePoint.Administration.SPWebService])) {
            continue;
        }

        foreach ($webApp in $spService.WebApplications) {
            if ($webApp -is [Microsoft.SharePoint.Administration.SPAdministrationWebApplication]) { continue }

            foreach ($site in $webApp.Sites) {
                foreach ($web in $site.AllWebs) {
                    foreach ($list in $web.Lists) {
                        if ($list.BaseType -ne "DocumentLibrary") {
                            continue
                        }
                        foreach ($item in $list.Items) {
                            $data = @{
                                "Web Application" = $webApp.ToString()
                                "Site" = $site.Url
                                "Web" = $web.Url
                                "list" = $list.Title
                                "Item ID" = $item.ID
                                "Item URL" = $item.Url
                                "Item Title" = $item.Title
                                "Item Created" = $item["Created"]
                                "Item Modified" = $item["Modified"]
                                "File Size" = $item.File.Length/1KB
                            }
                            New-Object PSObject -Property $data
                        }
                    }
                    $web.Dispose();
                }
                $site.Dispose()
            }
        }
    }
}
Get-DocInventory | Out-GridView
#Get-DocInventory | Export-Csv -NoTypeInformation -Path C:\Temp\inventory.csv

function Get-DocInventory() {

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")

$farm = [Microsoft.SharePoint.Administration.SPFarm]::Local

foreach ($spService in $farm.Services) {

if (!($spService -is [Microsoft.SharePoint.Administration.SPWebService])) {

continue;

}

foreach ($webApp in $spService.WebApplications) {

if ($webApp -is [Microsoft.SharePoint.Administration.SPAdministrationWebApplication]) { continue }

foreach ($site in $webApp.Sites) {

foreach ($web in $site.AllWebs) {

foreach ($list in $web.Lists) {

if ($list.BaseType -ne "DocumentLibrary") {

continue

}

foreach ($item in $list.Items) {

$data = @{

"Web Application" = $webApp.ToString()

"Site" = $site.Url

"Web" = $web.Url

"list" = $list.Title

"Item ID" = $item.ID

"Item URL" = $item.Url

"Item Title" = $item.Title

"Item Created" = $item["Created"]

"Item Modified" = $item["Modified"]

"File Size" = $item.File.Length/1KB

}

New-Object PSObject -Property $data

}

$web.Dispose();

}

$site.Dispose()

}

Get-DocInventory | Out-GridView

#Get-DocInventory | Export-Csv -NoTypeInformation -Path C:\Temp\inventory.csv

[AD] Get AD Schema Version via PS

August 20, 2017 Andrei Rachita 0

function Get-Active-Directory-Forest-Object ([string]$ForestName, [System.Management.Automation.PsCredential]$Credential)
{    
    #if forest is not specified, get current context forest
    If (!$ForestName)     
    {        $ForestName = [System.DirectoryServices.ActiveDirectory.Forest]::GetCurrentForest().Name.ToString()    
    }        

    If ($Credential)     
    {        
        $credentialUser = $Credential.UserName.ToString()
        $credentialPassword = $Credential.GetNetworkCredential().Password.ToString()
        $adCtx = New-Object System.DirectoryServices.ActiveDirectory.DirectoryContext("forest", $ForestName, $credentialUser, $credentialPassword )
    }    
    Else     
    {        
        $adCtx = New-Object System.DirectoryServices.ActiveDirectory.DirectoryContext("forest", $ForestName)    
    }        

    $output = ([System.DirectoryServices.ActiveDirectory.Forest]::GetForest($adCtx))    

    Return $output
}

function Get-Active-Directory-Forest-Object ([string]$ForestName, [System.Management.Automation.PsCredential]$Credential)

{

#if forest is not specified, get current context forest

If (!$ForestName)

{ $ForestName = [System.DirectoryServices.ActiveDirectory.Forest]::GetCurrentForest().Name.ToString()

}

If ($Credential)

{

$credentialUser = $Credential.UserName.ToString()

$credentialPassword = $Credential.GetNetworkCredential().Password.ToString()

$adCtx = New-Object System.DirectoryServices.ActiveDirectory.DirectoryContext("forest", $ForestName, $credentialUser, $credentialPassword )

}

Else

{

$adCtx = New-Object System.DirectoryServices.ActiveDirectory.DirectoryContext("forest", $ForestName)

}

$output = ([System.DirectoryServices.ActiveDirectory.Forest]::GetForest($adCtx))

Return $output

}

[SPS 2013] Get UPA Sync connections via PS

August 20, 2017 Andrei Rachita 0

Here goes:

<# 
   .SYNOPSIS
      Get the synchronization connections from the User Profile Service Application.

   .DESCRIPTION
      Get the synchronization connections from the User Profile Service Application.


   .PARAMETER OutputFile
      Specifies the name of the file where the output is written to.   

   .EXAMPLE
      PS C:\> .\Get-SyncConnections.ps1 -OutputFile "c:\temp\connections.xml" 
#> 
[CmdletBinding()] 
param(
   [parameter(Position=0,Mandatory=$true,ValueFromPipeline=$false)]  
   [string]$OutputFile)

# Load the SharePoint PowerShell snapin if needed 
if ((Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -EA SilentlyContinue) -eq $null) 
{
   Write-Host "Loading the SharePoint PowerShell snapin..."
   Add-PSSnapin Microsoft.SharePoint.PowerShell
}

$ups = @(Get-SPServiceApplication | ? {$_.TypeName -eq "User Profile Service Application"})[0]

$context = [Microsoft.SharePoint.SPServiceContext]::GetContext($ups.ServiceApplicationProxyGroup,[Microsoft.SharePoint.SPSiteSubscriptionIdentifier]::Default)
$upcm = New-Object Microsoft.Office.Server.UserProfiles.UserProfileConfigManager($context)

$xml = new-object xml
$root = $xml.CreateElement("Connections")
$xml.AppendChild($root) >> $null

# Get AD Connections 
$ADConnections = $upcm.ConnectionManager | ? {$_.Type -eq "ActiveDirectory"} 
foreach ($ADConnection in $ADConnections)
{
   $xeConnection = $xml.CreateElement("Connection")
   $xaConnectionName = $xml.CreateAttribute("Name")
   $xaServer = $xml.CreateAttribute("Server")
   $xaUseSSL = $xml.CreateAttribute("UseSSL")
   $xaSyncAccount = $xml.CreateAttribute("SyncAccount")
   $xaType = $xml.CreateAttribute("Type")

   $xaServer.Value = $ADConnection.Server
   $xaUseSSL.Value = $ADConnection.UseSSL
   $xaSyncAccount.Value = "$($ADConnection.AccountDomain)\$($ADConnection.AccountUsername)"    
   $xaConnectionName.Value = $ADConnection.DisplayName
   $xaType.Value = $ADConnection.Type

   $xeConnection.Attributes.Append($xaSyncAccount) >> $null
   $xeConnection.Attributes.Append($xaUseSSL) >> $null
   $xeConnection.Attributes.Append($xaServer) >> $null
   $xeConnection.Attributes.Append($xaType) >> $null
   $xeConnection.Attributes.Append($xaConnectionName) >> $null

   # Enumerate all NamingContexts
   foreach ($nc in $ADConnection.NamingContexts)
   {
      $xeNamingContext = $xml.CreateElement("NamingContext")
      $xaDistinguisedName = $xml.CreateAttribute("DistinguishedName")
      $xaDomainName = $xml.CreateAttribute("DomainName")
      $xaIsDomain = $xml.CreateAttribute("IsDomain")
      $xaIsConfigNC = $xml.CreateAttribute("IsConfigurationContext")

      $xaDistinguisedName.Value = $nc.DistinguishedName
      $xaDomainName.Value = $nc.DomainName
      $xaIsDomain.Value = $nc.IsDomain
      $xaIsConfigNC.Value = $nc.IsConfigurationNamingContext

      $xeNamingContext.Attributes.Append($xaIsConfigNC) >> $null
      $xeNamingContext.Attributes.Append($xaIsDomain) >> $null
      $xeNamingContext.Attributes.Append($xaDomainName) >> $null
      $xeNamingContext.Attributes.Append($xaDistinguisedName) >> $null
      $xeConnection.AppendChild($xeNamingContext) >> $null

      foreach ($container in $nc.ContainersIncluded)
      {
         $xeIncludedContainer = $xml.CreateElement("IncludedContainer")
         $xaContainerName = $xml.CreateAttribute("DN")
         $xaContainerName.Value = $container
         $xeIncludedContainer.Attributes.Append($xaContainerName) >> $null
         $xeNamingContext.AppendChild($xeIncludedContainer) >> $null
      }

      foreach ($container in $nc.ContainersExcluded)
      {
         $xeExcludedContainer = $xml.CreateElement("ExcludedContainer")
         $xaContainerName = $xml.CreateAttribute("DN")
         $xaContainerName.Value = $container
         $xeExcludedContainer.Attributes.Append($xaContainerName) >> $null
         $xeNamingContext.AppendChild($xeExcludedContainer) >> $null
      }
   }

   $root.AppendChild($xeConnection) >> $null 
} 
$xml.OuterXml > $OutputFile

100

.SYNOPSIS

Get the synchronization connections from the User Profile Service Application.

.DESCRIPTION

Get the synchronization connections from the User Profile Service Application.

.PARAMETER OutputFile

Specifies the name of the file where the output is written to.

.EXAMPLE

PS C:\> .\Get-SyncConnections.ps1 -OutputFile "c:\temp\connections.xml"

[CmdletBinding()]

param(

[parameter(Position=0,Mandatory=$true,ValueFromPipeline=$false)]

[string]$OutputFile)

# Load the SharePoint PowerShell snapin if needed

if ((Get-PSSnapin -Name Microsoft.SharePoint.PowerShell -EA SilentlyContinue) -eq $null)

{

Write-Host "Loading the SharePoint PowerShell snapin..."

Add-PSSnapin Microsoft.SharePoint.PowerShell

}

$ups = @(Get-SPServiceApplication | ? {$_.TypeName -eq "User Profile Service Application"})[0]

$context = [Microsoft.SharePoint.SPServiceContext]::GetContext($ups.ServiceApplicationProxyGroup,[Microsoft.SharePoint.SPSiteSubscriptionIdentifier]::Default)

$upcm = New-Object Microsoft.Office.Server.UserProfiles.UserProfileConfigManager($context)

$xml = new-object xml

$root = $xml.CreateElement("Connections")

$xml.AppendChild($root) >> $null

# Get AD Connections

$ADConnections = $upcm.ConnectionManager | ? {$_.Type -eq "ActiveDirectory"}

foreach ($ADConnection in $ADConnections)

{

$xeConnection = $xml.CreateElement("Connection")

$xaConnectionName = $xml.CreateAttribute("Name")

$xaServer = $xml.CreateAttribute("Server")

$xaUseSSL = $xml.CreateAttribute("UseSSL")

$xaSyncAccount = $xml.CreateAttribute("SyncAccount")

$xaType = $xml.CreateAttribute("Type")

$xaServer.Value = $ADConnection.Server

$xaUseSSL.Value = $ADConnection.UseSSL

$xaSyncAccount.Value = "$($ADConnection.AccountDomain)\$($ADConnection.AccountUsername)"

$xaConnectionName.Value = $ADConnection.DisplayName

$xaType.Value = $ADConnection.Type

$xeConnection.Attributes.Append($xaSyncAccount) >> $null

$xeConnection.Attributes.Append($xaUseSSL) >> $null

$xeConnection.Attributes.Append($xaServer) >> $null

$xeConnection.Attributes.Append($xaType) >> $null

$xeConnection.Attributes.Append($xaConnectionName) >> $null

# Enumerate all NamingContexts

foreach ($nc in $ADConnection.NamingContexts)

{

$xeNamingContext = $xml.CreateElement("NamingContext")

$xaDistinguisedName = $xml.CreateAttribute("DistinguishedName")

$xaDomainName = $xml.CreateAttribute("DomainName")

$xaIsDomain = $xml.CreateAttribute("IsDomain")

$xaIsConfigNC = $xml.CreateAttribute("IsConfigurationContext")

$xaDistinguisedName.Value = $nc.DistinguishedName

$xaDomainName.Value = $nc.DomainName

$xaIsDomain.Value = $nc.IsDomain

$xaIsConfigNC.Value = $nc.IsConfigurationNamingContext

$xeNamingContext.Attributes.Append($xaIsConfigNC) >> $null

$xeNamingContext.Attributes.Append($xaIsDomain) >> $null

$xeNamingContext.Attributes.Append($xaDomainName) >> $null

$xeNamingContext.Attributes.Append($xaDistinguisedName) >> $null

$xeConnection.AppendChild($xeNamingContext) >> $null

foreach ($container in $nc.ContainersIncluded)

{

$xeIncludedContainer = $xml.CreateElement("IncludedContainer")

$xaContainerName = $xml.CreateAttribute("DN")

$xaContainerName.Value = $container

$xeIncludedContainer.Attributes.Append($xaContainerName) >> $null

$xeNamingContext.AppendChild($xeIncludedContainer) >> $null

}

foreach ($container in $nc.ContainersExcluded)

{

$xeExcludedContainer = $xml.CreateElement("ExcludedContainer")

$xaContainerName = $xml.CreateAttribute("DN")

$xaContainerName.Value = $container

$xeExcludedContainer.Attributes.Append($xaContainerName) >> $null

$xeNamingContext.AppendChild($xeExcludedContainer) >> $null

}

$root.AppendChild($xeConnection) >> $null

}

$xml.OuterXml > $OutputFile

#Load PowerShell
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Set Variables
$WebURL = "http://2013.pbnet.pbnet.local:9191"
$DoclibName = "MyDocuments1"
$FilePath = "C:\Temp\MultiDoc"
$Numitems = "50"
$Docname="MyDOC.docx"
$FinalDOCName="Word"

#Create Files in $FilePath

$NumArray = (1..$Numitems)

ForEach

($number in $numArray) {

$FinalPath="$FilePath\$Docname"
$Destination=$filepath+"\"+"$FinalDocName$number.docx"
Copy-Item $FinalPath -Destination $Destination
}


#Connect to SPS
$web = Get-SPWeb -Identity $WebURL
$List= $web.GetFolder($DoclibName)
$Files=$List.Files

$Files

#Get filename from path
$Filename=$FilePath.Substring($FilePath.LastIndexOf("\")+1)

#Load the file into a variable
$FileCollection =Get-ChildItem $FilePath

#Loop though each file in the $FilePath
Foreach ($File In $FileCollection) { 
$File.Name
# Upload it to SharePoint 
$Files.Add($DocLibName +"/" + $File.Name,$File.OpenRead(),$false) 
}
$web.Dispose()

#Load PowerShell

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Set Variables

$WebURL = "http://2013.pbnet.pbnet.local:9191"

$DoclibName = "MyDocuments1"

$FilePath = "C:\Temp\MultiDoc"

$Numitems = "50"

$Docname="MyDOC.docx"

$FinalDOCName="Word"

#Create Files in $FilePath

$NumArray = (1..$Numitems)

ForEach

($number in $numArray) {

$FinalPath="$FilePath\$Docname"

$Destination=$filepath+"\"+"$FinalDocName$number.docx"

Copy-Item $FinalPath -Destination $Destination

}

#Connect to SPS

$web = Get-SPWeb -Identity $WebURL

$List= $web.GetFolder($DoclibName)

$Files=$List.Files

$Files

#Get filename from path

$Filename=$FilePath.Substring($FilePath.LastIndexOf("\")+1)

#Load the file into a variable

$FileCollection =Get-ChildItem $FilePath

#Loop though each file in the $FilePath

Foreach ($File In $FileCollection) {

$File.Name

# Upload it to SharePoint

$Files.Add($DocLibName +"/" + $File.Name,$File.OpenRead(),$false)

}

$web.Dispose()

Month: August 2017

[SPS 2013] Get a list of all the documents in SPS via PS

[AD] Get AD Schema Version via PS

[SPS 2013] Get UPA Sync connections via PS

[SPS2013] Change the SuiteBar text [Branding]

[SPS2013] Provisioning UPA via PowerShell

[SPS] Create multiple files and upload them to SharePoint doclib