Hello SharePointers, Below are the powershell commands to change the default SharePoint suite logo in SharePoint 2016/2019. $webapp = Get-SPWebApplication “http://ca.krossfarm.com” $webapp.SuiteNavBrandingText = “Central Admin (Dev)” $webapp.Update() Happy SharePointing 🙂
Hello SharePointers, Below are the powershell code to site title, url, last modified date and creation date for a given sharepoint site collection. Get-SPWebApplication | Get-SPSite -Limit ALL | Get-SPWeb -Limit ALL | where { $_.HasUniquePerm -and $_.AssociatedOwnerGroup -ne $null } | foreach { $Title=$_.title;$TTNweburl = $_.Url; $_ ;$SiteCreatedDate=$_.Created; $SiteModifiedDate=$_.LastItemModifiedDate}| Select -ExpandProperty AssociatedOwnerGroup | Select […]
Hello SharePointers, Below are the powershell commands to get the list of List and Document library item counts in SharePoint online using Pnp Powershell . $siteurl = “https://organisation.sharepoint.com/sites/selfservice/” $credentials = Get-Credential Connect-PnPOnline -Url $siteurl -Credentials $credentials $Subsites= Get-PnPSubWebs $ListItemCollection = @() Write-Host “Subsite count is ” $Subsites.Count ” in the site” foreach ($subsite in $Subsites) […]
Hello SharePointers, Below are the power shell commands to restore subsite in a SharePoint online site collection using Pnp Powershell. $URL=”https://yourcompany.sharepoint.com/sites/selfservice/” $title=” KDM Monitor” $credentials=Get-Credential # Connect to SharePoint Online Connect-PnPOnline -Url $URL -Credentials $credentials Get-PnPRecycleBinItem | ? Title -eq $title | Restore-PnPRecycleBinItem Happy SharePointing 🙂
Hello SharePointers, Below are the power shell scripts to enable external sharing in Modern Hub site param ( [Parameter(Mandatory=$true)] [string]$HubSiteUrl, [Parameter(Mandatory=$true)][ValidateSet(“Disabled”,”ExistingExternalUserSharingOnly”,”ExternalUserSharingOnly”,”ExternalUserAndGuestSharing”)] [String]$ExternalSharing ) $HubId = (Get-SPOHubSite -ErrorAction SilentlyContinue | Where {$_.SiteUrl -eq $HubSiteURL}).Id.Guid if ($HubId -eq $null) { Throw “Not a Hub site ” } $sites = Get-SPOSite -Limit All foreach ($site in $Sites) { […]
Hello SharePointers, Below are the Pnp Powershell script to delete SharePoint list items before specific date in SharePoint online using Powershell. Connect-PnPOnline -Url <yourtenant>.sharepoint.com $listName = “EMployee” $items = Get-PnPListItem -List $listName -Fields “Title”,”Created”,”ID”,”GUID” // 30 days is the cut off period $days = (Get-Date).AddDays(-30) foreach($item in $items) { $created = $item[“Created”] Write-Host “Item created […]
Hello Sharepointers, Below are the powershell script to convert classic page to modern page in SharePoint Online/Office 365. $pages = Get-PnPListItem -List sitepages # Loop through over the pages foreach($page in $pages) { if ($page.FieldValues[“FileLeafRef”].StartsWith((“classicpage”))) { # No need to convert modern pages if ($page.FieldValues[“ClientSideApplicationId”] -eq “b6917cb1-93a0-4b97-a84d-7cf49975d4ec” ) { Write-Host ‘Page $page.FieldValues[“FileLeafRef”] is modern,already’ } […]
Below are the power shell script to export all the web part in a SharePoint Page . foreach($item in $items) { $file = $context.Web.GetFileByServerRelativeUrl($Item[“FileRef”]) if($Item[“FileRef”] -eq “/sites/testwebpartpage.aspx”){ $wpManager = $file.GetLimitedWebPartManager([Microsoft.SharePoint.Client.WebParts.PersonalizationScope]::Shared) $context.Load($file) $webparts = $wpManager.Webparts $context.Load($webparts) $context.ExecuteQuery() $ pelement = $XMLFile.CreateElement(“Page”) $ pelement .SetAttribute(“id”, $Item[“ID”]) $ pelement .InnerText = $Item[“FileRef”] $ pelement .AppendChild($PageElement) | Out-Null foreach($webpart […]
Add-PSSnapin Microsoft.SharePoint.Powershell -ea SilentlyContinue $web = get-spweb “https://mysite” $list = $web.lists[“Monster List”] $cquery = New-Object Microsoft.SharePoint.SPQuery $cquery.ViewAttributes = “Scope=’Recursive'” $cquery.RowLimit = 1000 $cquery.ViewFields = “” $cquery.ViewFieldsOnly = $true do { $listItems = $list.GetItems($cquery) $cquery.ListItemCollectionPosition = $listItems.ListItemCollectionPosition foreach($item in $listItems) { Write-Host “Deleting Monster Item – $($item.Id)” $list.GetItemById($item.Id).delete() } } while ($cquery.ListItemCollectionPosition -ne $null) Happy SharePointing […]
Hello SharePointers, Here are the Pnp powershell commands to convert Classic page to modern page in SharePoint using Pnp Powershell in Office 365. Connect-PnPOnline -Url https://mydomain.sharepoint.com/sites/EmpTeamsite ConvertTo-PnPClientSidePage -Identity Mypage.aspx -AddPageAcceptBanner Happy SharePoint Folks!!