July 2016 – PhoeNIXBird Networks

[SPS] Update multiple UPA properties using a CSV file

July 30, 2016 Andrei Rachita 0

This script will help you update multiple User Profile Service Application fields using a CSV file as input:

#First load the SharePoint commands 
add-PSSnapIn Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
#Set up the job variables 
$csvfile="c:\temp\usersATTR.csv" 
$mySiteUrl = "http://pbnet-sps:9091/" 
#$upAttribute = "Title" 
#Connect to User Profile Manager service 
$site = Get-SPSite $mySiteUrl 
$context = Get-SPServiceContext $site 
$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context) 
#Create Lists from each item in CSV file 
$csvData = Import-Csv $csvfile 
#Now iterate through the list to update the attribute with new value 
foreach ($line in $csvData)
{ 
    #Check to see if user profile exists U
    if ($profileManager.UserExists($line.NTName)) 
        { 
            #Get user profile and change the value 
            $up = $profileManager.GetUserProfile($line.NTName) 
            $up[$line.PropertyName].Value = $line.PropertyVal 
            $up.Commit() 
        } 
    else 
    { 
        write-host "Profile for user"$line.NTName "cannot be found" 
    } 
} 

#Dispose of site object 
$site.Dispose()

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

#First load the SharePoint commands

add-PSSnapIn Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Set up the job variables

$csvfile="c:\temp\usersATTR.csv"

$mySiteUrl = "http://pbnet-sps:9091/"

#$upAttribute = "Title"

#Connect to User Profile Manager service

$site = Get-SPSite $mySiteUrl

$context = Get-SPServiceContext $site

$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)

#Create Lists from each item in CSV file

$csvData = Import-Csv $csvfile

#Now iterate through the list to update the attribute with new value

foreach ($line in $csvData)

{

#Check to see if user profile exists U

if ($profileManager.UserExists($line.NTName))

{

#Get user profile and change the value

$up = $profileManager.GetUserProfile($line.NTName)

$up[$line.PropertyName].Value = $line.PropertyVal

$up.Commit()

}

else

{

write-host "Profile for user"$line.NTName "cannot be found"

}

#Dispose of site object

$site.Dispose()

The input CSV file looks […]

[SPS] Count the number of items inside a SPSite

July 30, 2016 Andrei Rachita 0

So, here goes:

Add-PSSnapin Microsoft.SharePoint.PowerShell
$ListsInfo = @{}
$TotalItems = 0
$SiteCollection = Get-SPSite "http://intranet.pbnet.pbnet.local/"
ForEach ($Site in $SiteCollection.AllWebs)
{
    ForEach ($List in $Site.Lists)
    {
        $ListsInfo.Add($Site.Url + " - " + $List.Title, $List.ItemCount)
        $TotalItems += $List.ItemCount
        
    }
    $site.Dispose()
}
$SiteCollection.Dispose()
$ListsInfo.GetEnumerator() | sort name | Format-Table -Autosize
Write-Host "Total number of Lists: " $ListsInfo.Count
Write-Host "Total number of ListItems: " $TotalItems

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

Add-PSSnapin Microsoft.SharePoint.PowerShell

$ListsInfo = @{}

$TotalItems = 0

$SiteCollection = Get-SPSite "http://intranet.pbnet.pbnet.local/"

ForEach ($Site in $SiteCollection.AllWebs)

{

ForEach ($List in $Site.Lists)

{

$ListsInfo.Add($Site.Url + " - " + $List.Title, $List.ItemCount)

$TotalItems += $List.ItemCount

}

$site.Dispose()

}

$SiteCollection.Dispose()

$ListsInfo.GetEnumerator() | sort name | Format-Table -Autosize

Write-Host "Total number of Lists: " $ListsInfo.Count

Write-Host "Total number of ListItems: " $TotalItems

[LINUX] Create a dynamic MOTD

July 17, 2016 Andrei Rachita 0

First you will need to install some prerequisites and build the directory structure. So here goes:

# install lsb-release 
apt-get install lsb-release
# install figlet to enable ASCII art
apt-get install figlet
# install update-motd software
apt-get install update-motd
# delete default directory
rm -r /etc/update-motd.d/
# create new directory
mkdir /etc/update-motd.d/
# create dynamic files
touch 00-header ; touch 10-sysinfo ; touch 90-footer
# make files executable
chmod +x /etc/update-motd.d/*
# remove MOTD file
rm /etc/motd.dynamic

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

# install lsb-release

apt-get install lsb-release

# install figlet to enable ASCII art

apt-get install figlet

# install update-motd software

apt-get install update-motd

# delete default directory

rm -r /etc/update-motd.d/

# create new directory

mkdir /etc/update-motd.d/

# create dynamic files

touch 00-header ; touch 10-sysinfo ; touch 90-footer

# make files executable

chmod +x /etc/update-motd.d/*

# remove MOTD file

rm /etc/motd.dynamic

Once the above commands have been executed, we […]

[O365] Disconnect users from services

July 17, 2016 Andrei Rachita 0

OK, so supposedly, one of your users lost his device and you want to ensure he is disconnected from the services before changing any password. […]

[SPS] Run a Dispose Check on a SPS2010 and export results to CSV

July 3, 2016 Andrei Rachita 0

OK, so we have (let’s say) 300+ custom solutions on our SPS2010 environment and want to create a SPDisposeCheck report against them. The report should […]

[SPS] IIS – Wake Up Application Pools using PowerShell

July 3, 2016 Andrei Rachita 0

So here is a script to wake up a specific application pool, if that application pool is not “Started”

 function specificapppool
 
 {
 
 import-module WebAdministration
 
        $appPoolName="SharePoint - 80"
      
       if((Get-WebAppPoolState $appPoolName).Value -ne 'Started')
       {
	      Start-WebAppPool -Name $appPoolName
          
          }
  }
          
while ($true)
{
Start-Sleep -Seconds 10
specificapppool
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

function specificapppool

{

import-module WebAdministration

$appPoolName="SharePoint - 80"

if((Get-WebAppPoolState $appPoolName).Value -ne 'Started')

{

Start-WebAppPool -Name $appPoolName

}

while ($true)

{

Start-Sleep -Seconds 10

specificapppool

}

and in case you want […]