kwizcom banner advertisement

Limit Search Results to a Specific Content Source in SharePoint 2016

5:30 PM    , ,
Requirement:   HR team wants to setup a dedicated search portal to search a confidential file share. If its SharePoint 2010, we would have created a search scope and added rules to include only that specific content source to it. Now from SharePoint 2013 on wards search scopes has been replaced by result sources. So, lets see how to create a result source to limit search results only from a specific content source in SharePoint 2016. Before starting, I've following things configured already: A content source is created to index the specific file share with name "HR FileShare". Full crawl has been completed already. There is a subsite created with "Basic Search center" template to server as a dedicated search center. How to setup Search Result Source to Limit results to a Content Source? Result Sources can be created on three different levels: Search Service Application, Site collection and Site. For our requirement, lets create it at site level. Here
Limit Search Results to a Specific Content Source in SharePoint 2016 Limit Search Results to a Specific Content Source in SharePoint 2016 Reviewed by Salaudeen Rajack on 5:30 PM Rating: 5

Find All OneDrive Site Collections in SharePoint Online using PowerShell

7:51 PM    , , , ,
Requirement: Get a list of all OneDrive site collections from SharePoint Online. I was asked to get the list of all OneDrive sites to get the usage of OneDrive for Business in our Office 365 tenant. Its bit tricky to find all of your OneDrive site collections and here is how I achieved using Get-SPOSite cmdlet: Find All OneDrive Sites using SharePoint Online Management Shell: Here is the PowerShell script to get all OneDrive site collections in SharePoint Online. $AdminSiteURL="https://crescent-admin.sharepoint.com" #Get Credentials to connect to SharePoint Admin Center $Cred = Get-Credential #Connect to SharePoint Online Admin Center Connect-SPOService -Url $AdminSiteURL –credential $Cred #Get all Personal Site collections and export to a Text file Get-SPOSite -Template "SPSPERS#9" -limit ALL -includepersonalsite $True | Select URL, Owner | Format-table -autosize | Out-string -width 8096 | Out-file C:\temp\OneDriveSites.txt Just change the $AdminSiteURL
Find All OneDrive Site Collections in SharePoint Online using PowerShell Find All OneDrive Site Collections in SharePoint Online using PowerShell Reviewed by Salaudeen Rajack on 7:51 PM Rating: 5

SharePoint Online: Export List Version History to Excel using PowerShell

2:51 PM    , , , , ,
Requirement: Export all versions of SharePoint Online List Items to CSV (Excel) file. PowerShell to Extract and Export List Item's Version History to CSV File: This article assumes you have an existing SharePoint Online list with columns given below. You may have to create and change columns according to your requirement.  #Load SharePoint CSOM Assemblies 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" Function Export-VersionHistory() { param ( [Parameter(Mandatory=$true)] [string] $SiteURL, [Parameter(Mandatory=$true)] [string] $ListName, [Parameter(Mandatory=$true)] [string] $CSVFile ) Try { #Delete the Output report file if exists if (Test-Path $CSVFile) { Remove-Item $CSVFile }
SharePoint Online: Export List Version History to Excel using PowerShell SharePoint Online: Export List Version History to Excel using PowerShell Reviewed by Salaudeen Rajack on 2:51 PM Rating: 5

SharePoint Online: Find and Delete Orphaned Users using PowerShell

4:45 PM    , , , ,
What is "Orphaned Users" in SharePoint Online? In short, Orphaned users are those who deleted from the authentication provider (such as removed from Active Directory when user leaves the organization), and still continue to exist in SharePoint online sites! scanning each user in SharePoint online site collection for orphaned users could take days to complete! Since, Here is my PowerShell script to search for orphan users and delete them. Pr-Requisites: Before using this script, you need to have SharePoint Online Management Shell ( https://www.microsoft.com/en-us/download/details.aspx?id=35588 ) and Azure Active Directory Module ( https://technet.microsoft.com/en-us/library/dn975125.aspx ) installed on your machine! Find Orphan Users in SharePoint Online using PowerShell: This script scans each and every user from the given site collection URL and exports list of orphaned users to a CSV file. #Import SharePoint Online and Azure Online modules Import-Module Micro
SharePoint Online: Find and Delete Orphaned Users using PowerShell SharePoint Online: Find and Delete Orphaned Users using PowerShell Reviewed by Salaudeen Rajack on 4:45 PM Rating: 5

Get-Set OneDrive Site Collection Storage Quota Size using PowerShell

7:43 PM    , , ,
Get OneDrive Site collection Storage Quota Information: To get the storage quota data for a particular OneDrive site, use this PowerShell cmdlet in SharePoint Online Management Shell Get-SPOSite -Identity "https://crescent-my.sharepoint.com/personal/salaudeen_crescent_com" This gets you the currently allocated storage quota data for a single site collection. Get Storage Quota Details of All OneDrive Site collections Use this script in SharePoint Online Management Shell. $AdminSiteURL="https://crescent-admin.sharepoint.com" #Get Credentials to connect to SharePoint Admin Center $Cred = Get-Credential #Connect to SharePoint Online Admin Center Connect-SPOService -Url $AdminSiteURL –credential $Cred #Get all Personal Site collections and export to a Text file $OneDriveSites = Get-SPOSite -Template "SPSPERS#9" -Limit ALL -includepersonalsite $True $Result=@() # Get storage quota of each site Foreach($Site in $OneDriveSites) { $Result += New-O
Get-Set OneDrive Site Collection Storage Quota Size using PowerShell Get-Set OneDrive Site Collection Storage Quota Size using PowerShell Reviewed by Salaudeen Rajack on 7:43 PM Rating: 5

Get All SharePoint Online Site Collections Inventory using PowerShell

12:37 PM    , , ,
Requirement: Get all site collections inventory in SharePoint Online using PowerShell PowerShell to Get All SharePoint Online Site Collections Inventory: Import-Module Microsoft.Online.SharePoint.Powershell -DisableNameChecking #Config Parameters $AdminSiteURL="https://crescent-admin.sharepoint.com" $ReportOutput="C:\Temp\SPOStorage.csv" #Get Credentials to connect to SharePoint Admin Center $Cred = Get-Credential #Connect to SharePoint Online Admin Center Connect-SPOService -Url $AdminSiteURL –Credential $Cred #Get All site collections $SiteCollections = Get-SPOSite -Limit All Write-Host "Total Number of Site collections Found:"$SiteCollections.count -f Yellow #Array to store Result $ResultSet = @() #Loop through each site collection and retrieve details Foreach ($Site in $SiteCollections) { Write-Host "Processing Site Collection :"$Site.URL -f Yellow #Get site collection details $Result = new-object PSObject $Resu
Get All SharePoint Online Site Collections Inventory using PowerShell Get All SharePoint Online Site Collections Inventory using PowerShell Reviewed by Salaudeen Rajack on 12:37 PM Rating: 5

SharePoint Online: Add Site Column to List using PowerShell

3:42 AM    , , , ,
Requirement: Add an existing site column to SharePoint list or library using PowerShell. How to Add a Site Column to SharePoint Online List? Site columns in SharePoint provides great re-usability without having to recreate same columns multiple times! Once created at top level site, we can utilize them to store metadata in any number of lists and libraries under the hierarchy. To add a site column to SharePoint list, follow these steps: Go to List Settings >> Under Columns, Click on "Add from existing site columns" link. From the available site columns, pick the required site column(s) and click on Add button. Click OK to save your changes. Add Site Column to List or Library with PowerShell: #Load SharePoint CSOM Assemblies 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\
SharePoint Online: Add Site Column to List using PowerShell SharePoint Online: Add Site Column to List using PowerShell Reviewed by Salaudeen Rajack on 3:42 AM Rating: 5

How to Add a Custom Tile to SharePoint 2016 App Launcher

1:50 PM    ,
Requirement: Add new tile to App Launcher in SharePoint Online. How to Add a Custom Tile to SharePoint 2016 App Launcher? We wanted to place a new tile in SharePoint 2016 app launcher for support center site, as an end-user usability improvement. SharePoint 2016 Feature Pack 1 brought us the capability to add new tile to app launcher. Here is how you can customize SharePoint 2016 App launcher. Step 1: Enable the "Custom Tiles" feature in SharePoint 2016 with PowerShell: Use this PowerShell script to enable custom tiles feature.  Enable-SPFeature -Identity CustomTiles -Url "http://intranet.crescent.com" -Force This creates a new list "Custom Tiles" in the given web application's root site collection. Step 2: Create new Tile in "Custom Tiles" list Once the feature is activated, navigate to: http://intranet.crescent.com/Lists/Custom%20Tiles/AllItems.aspx URL and add a new entry with desired URL and image for tile for your custom t
How to Add a Custom Tile to SharePoint 2016 App Launcher How to Add a Custom Tile to SharePoint 2016 App Launcher Reviewed by Salaudeen Rajack on 1:50 PM Rating: 5

SharePoint Online: Grant Permission to List Item using PowerShell

7:03 PM    , , ,
Permissions are hierarchical in SharePoint from Top Site collection till the List Item level. To set unique permissions on list items, you need to configure permissions on item level. Here is how: How to Grant Access to Individual List Items in SharePoint Online? Got a business requirement to grant permissions at List item level. To set explicit permissions on SharePoint online list items, we need to break the permission inheritance first (stop inheriting permissions) and then add user or group to the List Item. Go to your SharePoint Online list or library >> Select the Item to which you want to provide unique permissions.  Click on "Shared With" button from the ribbon. On the Shared With page, click Advanced. On the Permissions tab, in the Inheritance group, click Stop Inheriting Permissions button. Confirm the prompt. Now, from the ribbon, click on "Grant Permissions." button. In the Share dialog box, enter names, email addresses. Click the Show
SharePoint Online: Grant Permission to List Item using PowerShell SharePoint Online: Grant Permission to List Item using PowerShell Reviewed by Salaudeen Rajack on 7:03 PM Rating: 5

Create Search Service Application in SharePoint 2016 Multi-Server Farm using PowerShell

3:02 PM    , , , ,
The Search Service Application in SharePoint provides search functionality, as its name implies. We have to use PowerShell scripts to configure search service application from SharePoint 2013 on wards as there is no user interface to configure the Search topology from SharePoint Central Admin - although we can create new search service application instance. Configuring SharePoint 2016 Search Service Application for Multi-Server Farm: While my earlier article addresses How to create search service application in SharePoint 2013 - Single Server farm , for Standalone SharePoint 2013 or SharePoint 2016 installations, In a production environment we may have to distribute and load balance search components to different servers in a multi-server farm. Here is the proposed Farm search topology in high level: I've the below servers in my SharePoint 2016 environment using Shared MinRoles: Web Front End + Distributed Cache Servers - 2 Application + Search Servers - 2 Since w
Create Search Service Application in SharePoint 2016 Multi-Server Farm using PowerShell Create Search Service Application in SharePoint 2016 Multi-Server Farm using PowerShell Reviewed by Salaudeen Rajack on 3:02 PM Rating: 5
Powered by Blogger.