Sharepoint – Set-AzWebApp -name "Anything Microsoft and other stuff on the side"

SharePoint tenant rename, why and how?

Posted by Harri Jaakkonen Posted on 03/11/2021 0 Comments

Posted in Azure, Powershell, Sharepoint

Finally, Microsoft finally it’s coming to the public. What went wrong when you chose a name for your tenant? Probably nothing or all. Maybe you had a consultant saying “You won’t even see it when you use custom domain names…

AIP Scanner and how to dig your content

Posted by Harri Jaakkonen Posted on 21/10/2021 0 Comments

Posted in Azure, Azure Information Protection, Compliance, Data Loss Prevention, Onpremise, Sharepoint

What Is AIP scanner? Azure Information Protection Scanner is combination of Azure Information Protection Viewer, SQL DB and Azure App registration. It will discover the data from File shares, SharePoint content and it also has a network discovery functionality (that…

Sharepoint Online recursive permissions.

Posted by Harri Jaakkonen Posted on 23/07/2018 0 Comments

Posted in Office 365, Onedrive, Powershell, Sharepoint

Hi, When You migrate from a local fileshare, You will have a problem with recursive permissions from parent object. Here is script that can scan thru large library (5000+ items) and reset recursive permissions to them.

function Restore-SPOListAllItemsInheritance
{
  
   param (
        [Parameter(Mandatory=$true,Position=1)]
		[string]$Username,
		[Parameter(Mandatory=$true,Position=2)]
		[string]$Url,
        [Parameter(Mandatory=$true,Position=3)]
		[SecureString]$AdminPassword,
        [Parameter(Mandatory=$true,Position=4)]
		[string]$ListTitle
		)
  
  
  
  $ctx=New-Object Microsoft.SharePoint.Client.ClientContext($Url)
  $ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username, $AdminPassword)
  $ctx.Load($ctx.Web.Lists)
  $ctx.Load($ctx.Web)
  $ctx.Load($ctx.Web.Webs)
  $ctx.ExecuteQuery()
  $ll=$ctx.Web.Lists.GetByTitle($ListTitle)
  $ctx.Load($ll)
  $ctx.ExecuteQuery()

  ## View XML
$qCommand = @"
<View Scope="RecursiveAll">
    <Query>
        <OrderBy><FieldRef Name='ID' Ascending='TRUE'/></OrderBy>
    </Query>
    <RowLimit Paged="TRUE">5000</RowLimit>
</View>
"@
## Page Position
$position = $null
 
## All Items
$allItems = @()
Do{
    $camlQuery = New-Object Microsoft.SharePoint.Client.CamlQuery
    $camlQuery.ListItemCollectionPosition = $position
    $camlQuery.ViewXml = $qCommand
 ## Executing the query
    $currentCollection = $ll.GetItems($camlQuery)
    $ctx.Load($currentCollection)
    $ctx.ExecuteQuery()
 
 ## Getting the position of the previous page
    $position = $currentCollection.ListItemCollectionPosition
 
 # Adding current collection to the allItems collection
    $allItems += $currentCollection

     Write-Host "Collecting items. Current number of items: " $allItems.Count


}
 while($position -ne $null)
 

 Write-Host "Total number of items: " $allItems.Count

  for($j=0;$j -lt $allItems.Count ;$j++)
  {
        
      Write-Host "Resetting permissions for " $allItems[$j]["Title"] ".." $allItems[$j]["FileRef"]
      $allItems[$j].ResetRoleInheritance()
      $ctx.ExecuteQuery()
   
  }

 
   

  
  
  }


# Paths to SDK. Please verify location on your computer.
Add-Type -Path "c:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll" 
Add-Type -Path "c:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"

#Enter the data
$AdminPassword=Read-Host -Prompt "Enter password" -AsSecureString
$username="user@tenant.onmicrosoft.com"
$Url="https://tenant.sharepoint.com"
$ListTitle="library or list"


Restore-SPOListAllItemsInheritance -Username $username -Url $Url -AdminPassword $AdminPassword -ListTitle $ListTitle

function Restore-SPOListAllItemsInheritance

{

param (

[Parameter(Mandatory=$true,Position=1)]

[string]$Username,

[Parameter(Mandatory=$true,Position=2)]

[string]$Url,

[Parameter(Mandatory=$true,Position=3)]

[SecureString]$AdminPassword,

[Parameter(Mandatory=$true,Position=4)]

[string]$ListTitle

)

$ctx=New-Object Microsoft.SharePoint.Client.ClientContext($Url)

$ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Username, $AdminPassword)

$ctx.Load($ctx.Web.Lists)

$ctx.Load($ctx.Web)

$ctx.Load($ctx.Web.Webs)

$ctx.ExecuteQuery()

$ll=$ctx.Web.Lists.GetByTitle($ListTitle)

$ctx.Load($ll)

$ctx.ExecuteQuery()

## View XML

$qCommand = @"

<Query>

</Query>

</View>

## Page Position

$position = $null

## All Items

$allItems = @()

Do{

$camlQuery = New-Object Microsoft.SharePoint.Client.CamlQuery

$camlQuery.ListItemCollectionPosition = $position

$camlQuery.ViewXml = $qCommand

## Executing the query

$currentCollection = $ll.GetItems($camlQuery)

$ctx.Load($currentCollection)

$ctx.ExecuteQuery()

## Getting the position of the previous page

$position = $currentCollection.ListItemCollectionPosition

# Adding current collection to the allItems collection

$allItems += $currentCollection

Write-Host "Collecting items. Current number of items: " $allItems.Count

}

while($position -ne $null)

Write-Host "Total number of items: " $allItems.Count

for($j=0;$j -lt $allItems.Count ;$j++)

{

Write-Host "Resetting permissions for " $allItems[$j]["Title"] ".." $allItems[$j]["FileRef"]

$allItems[$j].ResetRoleInheritance()

$ctx.ExecuteQuery()

}

# Paths to SDK. Please verify location on your computer.

Add-Type -Path "c:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll"

Add-Type -Path "c:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll"

#Enter the data

$AdminPassword=Read-Host -Prompt "Enter password" -AsSecureString

$username="user@tenant.onmicrosoft.com"

$Url="https://tenant.sharepoint.com"

$ListTitle="library or list"

Restore-SPOListAllItemsInheritance -Username $username -Url $Url -AdminPassword $AdminPassword -ListTitle $ListTitle

Orginal source for…

Sharepoint Config cache reset.

Posted by Harri Jaakkonen Posted on 23/11/2017 0 Comments

Posted in Onpremise, Powershell, Sharepoint

Hi, Today I found this excellent script for the job. All the credit goes to http://jasonwarren.ca/clearspconfigcache/

<#
.SYNOPSIS
Clear the Configuration Cache in a SharePoint 2010, 2013, or 2016 farm
   
.DESCRIPTION
Clear-SPConfigCache.ps1 will:
 1. Stop the SharePoint Timer Service on all servers in the farm
 2. Delete all xml files in the configuration cache folder on all servers in the farm
 3. Copy the existing cache.ini files as a backup
 4. Clear the cache.ini files and reset them to a value of 1
 5. Start the SharePoint Timer Service on all servers in the farm
 
Clear-SPConfigCache.ps1 will work in either single-server and multi-server farms.
 
Run in an elevated SharePoint Management Shell
 
Author: Jason Warren
 
.LINK
 http://jasonwarren.ca/ClearSPConfigCache ClearSPConfigCache.ps1
  
.EXAMPLE
 .\Clear-SPConfigCache.ps1
  
.INPUTS
None. Clear-SPConfigCache.ps1 does not take any input.
 
.OUTPUTS
Text output that describes the current task being performed.
 
#>
 
 
Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction Stop
$farm = Get-SPFarm
$ConfigDB = Get-SPDatabase | where {$_.Name -eq $Farm.Name}
 
# Configuration Cache is stored in %PROGRAMDATA\Microsoft\SharePoint\Config\[Config ID GUID]
# %PROGRAMDATA% is C:\ProgramData by default, it is assumed it's in the same location on all servers in the farm
#   i.e. if it's X:\ProgramData on one server, it will be X:\ProgramData on the others
# We'll be connecting via UNC paths, so we'll also change the returned DRIVE: to DRIVE$
$ConfigPath = "$(($env:PROGRAMDATA).Replace(':','$'))\Microsoft\SharePoint\Config\$($ConfigDB.Id.Guid)"
 
# Stop the timer service on all farm servers
$TimerServiceName = "SPTimerV4"
foreach ($server in $farm.TimerService.Instances.Server) {
    Write-Output "Stopping $TimerServiceName on $($server.Address)..."
    $service = Get-Service -ComputerName $server.Address -Name $TimerServiceName
    Stop-Service -InputObject $service -Verbose
} # Foreach server
 
 
$TimeStamp = Get-Date -Format "yyyymmddhhmmssms"
 
# Clear and reset the cache on each server in the farm
foreach ($server in $farm.TimerService.Instances.Server) {
 
    Write-Output $server.Address
     
    # build the UNC path e.g. \\server\X$\ProgramData\Microsoft\SharePoint\Config\00000000-0000-0000-0000-000000000000
    $ServerConfigPath = "\\$($server.Address)\$($ConfigPath)"
     
    # Delete the XML files
    Write-Output "Remove XML files: $ServerConfigPath..."
    Remove-Item -Path "$ServerConfigPath\*.xml"
     
    # Backup the old cache.ini
    Write-Output "Backup $ServerConfigPath\cache.ini..."
    Copy-Item -Path "$ServerConfigPath\cache.ini" -Destination "$ServerConfigPath\cache.ini.$TimeStamp"
     
    # Save the value of "1" to cache.ini
    Write-Output "Set cache.ini to '1'..."
    "1" | Out-File -PSPath "$ServerConfigPath\cache.ini"
 
    Write-Output ""
     
} #foreach server
 
#Start the timer service on all farm servers
foreach ($server in $farm.TimerService.Instances.Server) {
    Write-Output "Starting $TimerServiceName on $($server.Address)..."
    $service = Get-Service -ComputerName $server.Address -Name $TimerServiceName
    Start-Service -InputObject $service -Verbose
     
}

.SYNOPSIS

Clear the Configuration Cache in a SharePoint 2010, 2013, or 2016 farm

.DESCRIPTION

Clear-SPConfigCache.ps1 will:

1. Stop the SharePoint Timer Service on all servers in the farm

2. Delete all xml files in the configuration cache folder on all servers in the farm

3. Copy the existing cache.ini files as a backup

4. Clear the cache.ini files and reset them to a value of 1

5. Start the SharePoint Timer Service on all servers in the farm

Clear-SPConfigCache.ps1 will work in either single-server and multi-server farms.

Run in an elevated SharePoint Management Shell

Author: Jason Warren

.LINK

http://jasonwarren.ca/ClearSPConfigCache ClearSPConfigCache.ps1

.EXAMPLE

.\Clear-SPConfigCache.ps1

.INPUTS

None. Clear-SPConfigCache.ps1 does not take any input.

.OUTPUTS

Text output that describes the current task being performed.

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction Stop

$farm = Get-SPFarm

$ConfigDB = Get-SPDatabase | where {$_.Name -eq $Farm.Name}

# Configuration Cache is stored in %PROGRAMDATA\Microsoft\SharePoint\Config\[Config ID GUID]

# %PROGRAMDATA% is C:\ProgramData by default, it is assumed it's in the same location on all servers in the farm

# i.e. if it's X:\ProgramData on one server, it will be X:\ProgramData on the others

# We'll be connecting via UNC paths, so we'll also change the returned DRIVE: to DRIVE$

$ConfigPath = "$(($env:PROGRAMDATA).Replace(':','$'))\Microsoft\SharePoint\Config\$($ConfigDB.Id.Guid)"

# Stop the timer service on all farm servers

$TimerServiceName = "SPTimerV4"

foreach ($server in $farm.TimerService.Instances.Server) {

Write-Output "Stopping $TimerServiceName on $($server.Address)..."

$service = Get-Service -ComputerName $server.Address -Name $TimerServiceName

Stop-Service -InputObject $service -Verbose

} # Foreach server

$TimeStamp = Get-Date -Format "yyyymmddhhmmssms"

# Clear and reset the cache on each server in the farm

foreach ($server in $farm.TimerService.Instances.Server) {

Write-Output $server.Address

# build the UNC path e.g. \\server\X$\ProgramData\Microsoft\SharePoint\Config\00000000-0000-0000-0000-000000000000

$ServerConfigPath = "\\$($server.Address)\$($ConfigPath)"

# Delete the XML files

Write-Output "Remove XML files: $ServerConfigPath..."

Remove-Item -Path "$ServerConfigPath\*.xml"

# Backup the old cache.ini

Write-Output "Backup $ServerConfigPath\cache.ini..."

Copy-Item -Path "$ServerConfigPath\cache.ini" -Destination "$ServerConfigPath\cache.ini.$TimeStamp"

# Save the value of "1" to cache.ini

Write-Output "Set cache.ini to '1'..."

"1" | Out-File -PSPath "$ServerConfigPath\cache.ini"

Write-Output ""

} #foreach server

#Start the timer service on all farm servers

foreach ($server in $farm.TimerService.Instances.Server) {

Write-Output "Starting $TimerServiceName on $($server.Address)..."

$service = Get-Service -ComputerName $server.Address -Name $TimerServiceName

Start-Service -InputObject $service -Verbose

}

Sharepoint 2013/16 and WSS_Logging DB

Posted by Harri Jaakkonen Posted on 08/11/2017 0 Comments

Posted in Onpremise, Powershell, Sharepoint, SQL

Sharepoint gathers usage and health data to database called WSS_Logging. By Default retention period is 14 days. If You want to make it lower, lets say 2 days use the below oneliner for it.

Get-SPUsageDefinition | Set-SPUsageDefinition -DaysRetained 2

1	Get-SPUsageDefinition \| Set-SPUsageDefinition -DaysRetained 2

And then just a quick…

Migrate files to Onedrive with Powershell script.

Posted by Harri Jaakkonen Posted on 06/04/2017 0 Comments

Posted in Office 365, Onedrive, Powershell, Sharepoint

Jos Lieben wrote a really complex script for automating Onedrive For Business provisioning. http://www.lieben.nu/liebensraum/o365migrator/ We have tested it and it works great. It has the following features. We have tested this script and it really works. Here You can download the…

Move Sharepoint database to a different server.

Posted by Harri Jaakkonen Posted on 12/12/2014 0 Comments

Posted in Sharepoint, SQL

I wont write on article on this because I found an excellent ready one. But the situation is that you have to move sharepoint to a different server keeping the sql-server instance name as is. http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=255 Thanks Todd!

Sharepoint 2007 and attaching content database with SQL 2012 R2

Posted by Harri Jaakkonen Posted on 24/10/2014 0 Comments

Posted in Sharepoint, SQL

Today I had to migrate an old wss 3.0 site to Sql 2012 R2. Made backup of the old DB and transfered it to the new server. Then restored it and tried. STSADM –o addcontentdb –url http://ssps001:7242 -databasename _wss_content_old -databaseserver…

CRM 2013 sp1 and a new List component

Posted by Harri Jaakkonen Posted on 12/08/2014 0 Comments

Posted in CRM 2013, Office 365, Onpremise, Sharepoint

Hi again, Today I got in the middle of a problem. CRM client told me: But at the same time Web interface was working correctly. After some investigation i found that CRM for Outlook version have been updated to…

Category: Sharepoint

SharePoint tenant rename, why and how?

AIP Scanner and how to dig your content

Sharepoint Online recursive permissions.

Sharepoint Config cache reset.

Sharepoint 2013/16 and WSS_Logging DB

Migrate files to Onedrive with Powershell script.

Move Sharepoint database to a different server.

Sharepoint 2007 and attaching content database with SQL 2012 R2

CRM 2013 sp1 and a new List component

Subscribe with RSS

Twitter

Archives

Subscribe with RSS

Categories

Twitter

Archives