Let's SharePoint

March 21, 2019 / Last updated : March 21, 2019 Sethu PowerShell

How to get result sources in SharePoint 2013/2016/2019 using Powershell?

Below are the powershell commands get result sources in SharePoint 2013/2016/2019 using Powershell. Add-PSSnapin Microsoft.SharePoint.PowerShell $ssa = Get-SPEnterpriseSearchServiceApplication $fedman = New-Object Microsoft.Office.Server.Search.Administration.Query.FederationManager($ssa) $searchOwner = Get-SPEnterpriseSearchOwner -Level Ssa $filter = New-Object Microsoft.Office.Server.Search.Administration.SearchObjectFilter($searchOwner) $filter.IncludeHigherLevel = $true $fedman.ListSources($filter,$true) | Select Name, Description, Active, Owner Happy SharePointing 🙂
March 16, 2019 / Last updated : March 16, 2019 Sethu Client Side Object Model

How to delete SharePoint list items before specific date in SharePoint online using Powershell?

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 […]
March 6, 2019 / Last updated : March 6, 2019 Sethu Customization

How to get all site owners in SharePoint Online using Powershell?

Hello SharePointers. Below are the powershell script to get all the site owners of all the SharePoint sites. foreach($site in $sites) { $siteURL = $site.Url $siteOwner = $site.Owner Write-Host $siteURL -ForegroundColor Blue Write-Host $siteOwner -ForegroundColor Blue $siteAdmins = Get-SPOUser -Site $siteURL -Limit All | select LoginName,IsSiteAdmin | ? { $_.ISSiteAdmin } $siteUsers = “” foreach($siteAdmin […]
February 28, 2019 / Last updated : February 28, 2019 Sethu SharePoint 2010

How to create modern page in classic SharePoint site in Office 365/SharePoint Online?

To enable Modern pages in a classic sharepoint site, you need to activate the feature called “Site pages” at the site level. Here are the steps given below Navigate to your SharePoint site.Go to site settings, using Gear menu. On site settings page, select Manage site features from site action sectionActivate Site Page feature by […]
February 22, 2019 / Last updated : February 22, 2019 Sethu Client Side Object Model

How to convert classic page to modern page in SharePoint Online/Office 365 using Powershell ?

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’ } […]
February 20, 2019 / Last updated : February 20, 2019 Sethu Client Object Model

How to report SharePoint list item versions in Office 365/SharePoint online?

Hello SharePointers, Below are Powershell script to get all the version history of all list items in SharePoint online/Office 365. $List = $Ctx.Web.Lists.GetByTitle($ListName) $Ctx.Load($List) $Ctx.ExecuteQuery() $Query = [Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery() $ListItems = $List.GetItems($Query) $Ctx.Load($ListItems) $Ctx.ExecuteQuery() $VersionHistory = @() Foreach ($Item in $ListItems) { write-host “Processing Item:” $item.id -f Yellow #Get all versions of the list item $Versions […]
February 16, 2019 / Last updated : February 16, 2019 Sethu PowerShell

How to export all the webpart in a sharepoint online page using Powershell?

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 […]
February 16, 2019 / Last updated : February 16, 2019 Sethu Client Side Object Model

How to hide hours in SharePoint people picker in SharePoint online ,2010/2013/2016?

Hello SharePointers, Below are the powershell script to hide hours in People picker control in Sharepoint online/2010/2013/2016/2019. <script type=”text/javascript”> $(document).ready(function() { $(“select[id^=’People picker ID’]”).change(function() { $(this).find(“option[value=’4′]”).remove(); }); }); </script> Happy SharePointing 🙂