October 2019 – PhoeNIXBird Networks

[SPO] Delete sitecolumns using PNP PowerShell

October 19, 2019 Andrei Rachita 0

So, here goes:

Connect-PnPOnline -Url https://pbnettest.sharepoint.com/sites/columnstest -UseWebLogin

$field=Get-PnPField -Group "PBNET Columns"

foreach ($item in $field.InternalName)
{
Remove-PnPField -Identity $item -Force -Verbose
Write-Host "Removed Field: $item"
}

1

2

3

4

5

6

7

8

9

Connect-PnPOnline -Url https://pbnettest.sharepoint.com/sites/columnstest -UseWebLogin

$field=Get-PnPField -Group "PBNET Columns"

foreach ($item in $field.InternalName)

{

Remove-PnPField -Identity $item -Force -Verbose

Write-Host "Removed Field: $item"

}

[SPO] Remove comments on modern SharePoint Site

October 6, 2019 Andrei Rachita 0

So, here goes:

function Remove-Comments
{
param (
  [Parameter(Mandatory=$true,Position=1)]
		[string]$Username,
		[Parameter(Mandatory=$true,Position=2)]
		$AdminPassword,
        [Parameter(Mandatory=$true,Position=3)]
		[string]$Url
)

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

    try
    {
        $ctx.ExecuteQuery()
    } 
    catch [Net.WebException] 
    {            
        Write-Host $Url " failed to connect to the site" $_.Exception.Message.ToString() -ForegroundColor Red
    }

  $web = $ctx.Web  
  $ctx.Load($web)
  $ctx.ExecuteQuery()

  $web.CommentsOnSitePagesDisabled = $true
  $web.Update()
  $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" 

# Insert the credentials and the name of the admin site
$Username="admin@tenant.onmicrosoft.com"
$AdminPassword=Read-Host -Prompt "Password" -AsSecureString
$Url="https://pbnettrn1.sharepoint.com/sites/commsite"


Remove-Comments -Username $Username -AdminPassword $AdminPassword -Url $Url

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

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

function Remove-Comments

{

param (

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

[string]$Username,

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

$AdminPassword,

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

[string]$Url

)

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

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

try

{

$ctx.ExecuteQuery()

}

catch [Net.WebException]

{

Write-Host $Url " failed to connect to the site" $_.Exception.Message.ToString() -ForegroundColor Red

}

$web = $ctx.Web

$ctx.Load($web)

$ctx.ExecuteQuery()

$web.CommentsOnSitePagesDisabled = $true

$web.Update()

$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"

# Insert the credentials and the name of the admin site

$Username="admin@tenant.onmicrosoft.com"

$AdminPassword=Read-Host -Prompt "Password" -AsSecureString

$Url="https://pbnettrn1.sharepoint.com/sites/commsite"

Remove-Comments -Username $Username -AdminPassword $AdminPassword -Url $Url

[MS Teams] – Get all teams sites using PowerShell

October 6, 2019 Andrei Rachita 0

OK, so you want to get an overview on all the MS Teams sites in your teant. Note: Get-PnPTenantSite doesn’t include the team sites. So, […]