SharePoint Online: User Permissions Audit Report for a Site Collection using PnP PowerShell

September 25, 2019    , , , ,
Requirement: Need a report to audit SharePoint Online site collection permissions. SharePoint Online: User Permissions report in a Site Collection using PnP PowerShell Auditing SharePoint Online Site permissions is critical for security as misconfigured permissions may enable users to access to data that they should not have access to. So, regular auditing of SharePoint permissions is crucial to minimizing the risk of data leaks and compliance violations. As there are no out of the box ways to generate permissions report, we can utilize PowerShell get list of effective permissions for your SharePoint site collections. This PowerShell script generates permission report on all objects such as SharePoint Online Site collection and its subsites, lists and libraries, folders and list items which has unique permissions on the given site collection. It scans through following securables: Site collection administrators group Given site collection and sub-sites with unique permissions
Read More
SharePoint Online: User Permissions Audit Report for a Site Collection using PnP PowerShell SharePoint Online: User Permissions Audit Report for a Site Collection using PnP PowerShell Reviewed by Salaudeen Rajack on September 25, 2019 Rating: 5

SharePoint Online: Change Site Collection URL using PowerShell

September 18, 2019    , , ,
Requirement: Change Site Collection URL in SharePoint Online How to Change the Site URL in SharePoint Online? Previously, We had to create a new site collection and run a migration tool to copy all contents from old site to new site. Well, not anymore! To change the URL of the existing SharePoint Online site, follow these steps: Login to Modern SharePoint Admin Center >>  Click on "Active Sites" under "Sites" section Select the site collection you want to rename and open its properties pane. Click on "Edit" link next to site URL. Provide a new URL and hit "Save" button. You'll be prompted to enter the new name for the site. You'll get a progress message next, saying: "Updating site address". Wait for it to turn "Updated Site Address". That's all! Your site collection is renamed now! changing site URL can be done either through the SharePoint Admin Center or with PowerShell. Let's see how
Read More
SharePoint Online: Change Site Collection URL using PowerShell SharePoint Online: Change Site Collection URL using PowerShell Reviewed by Salaudeen Rajack on September 18, 2019 Rating: 5

SharePoint Online: Apply Modern Theme using PowerShell

July 30, 2019    , , ,
Requirement: Change the site theme in SharePoint Online How to apply theme in SharePoint Online? In SharePoint Online, Themes are responsible for colors in various elements of the site. There are set of default site themes available for selection. You can also add your own custom theme to SharePoint Online. To set a theme in SharePoint Online modern sites, Open your SharePoint Online site where you want to change the theme >> Click on the "Settings" gear icon. In the "Settings" menu, click on "Change the Look" Under themes, Select your desired theme (out of the box or custom theme) and click the "Save" button. The colors on themes can be further customized by clicking on the "Customize" button. This changes the theme for the site. Any user with Design or Full Control permission level have the ability to change site themes. Here is my other post on adding a modern theme using PowerShell in SharePoint Online: How to Ad
Read More
SharePoint Online: Apply Modern Theme using PowerShell SharePoint Online: Apply Modern Theme using PowerShell Reviewed by Salaudeen Rajack on July 30, 2019 Rating: 5

Migrate SharePoint 2010 Document Libraries to SharePoint Online using PowerShell

June 16, 2019    , , , , , ,
Requirement: Migrate Document Libraries from SharePoint 2010 to SharePoint Online. How to Migrate SharePoint 2010 Document Libraries to SharePoint Online? The idea is: Export all document libraries from SharePoint On-premises to local drive, export metadata of each document to a CSV file and then Import them to SharePoint Online. Before we begin, Please note, this is not a full fledged migration script which can migrate metadata, security, version history, etc. This script only copies document libraries with its file-folders and metadata "Created by", "Created On", "Modified By", "Modified On" to SharePoint Online. You need 3rd party migration tools if you want migrate all missing pieces! Step 1: Export SharePoint On-Premises Document Library As a first step, Login to any of your SharePoint On-premises web front end server and run the below PowerShell script to export either a single document library or all document libraries from ShareP
Read More
Migrate SharePoint 2010 Document Libraries to SharePoint Online using PowerShell Migrate SharePoint 2010 Document Libraries to SharePoint Online using PowerShell Reviewed by Salaudeen Rajack on June 16, 2019 Rating: 5

SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell

May 19, 2019    , ,
Requirement: Change Classic Experience to Modern Experience and Modern UI to Classic in SharePoint Online. How to Activate Modern Experience from Classic? The modern experience in SharePoint Online lists and libraries is faster, mobile friendly and easier to use.  It brings new functionalities and components, However, some features can only be used in the classic experience. So, you may need to switch between modern UI and classic experience in SharePoint Online. To enable modern experience in SharePoint Online, use the link "Exit classic Experience" at the bottom left corner. This turns ON modern experience. To disable modern experience and switch back to classic in SharePoint Online use the link "Return to Classic SharePoint" PowerShell to Switch Between Modern Experience and Classic Experiences To enable modern experience, we have to disable classic experience feature and to disable modern experience we should re-enable the classic experience feature
Read More
SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell SharePoint Online: Change UI to Modern Experience or Classic Experience using PowerShell Reviewed by Salaudeen Rajack on May 19, 2019 Rating: 5

SharePoint Online: Find Duplicate Files using PowerShell

April 23, 2019    , ,
Requirement: Find Duplicate Documents in SharePoint Online. When multiple people from different teams work together, there is a huge possibility for duplicate content in SharePoint. People may have uploaded a same document to different libraries or even different folders in document libraries. So, How to find duplicate documents in SharePoint Online? SharePoint Online: Find Duplicate Documents using PowerShell - File Hash Method Lets find duplicate files in a SharePoint Online document library by comparing File hash. #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" #Parameters $SiteURL = "https://crescenttech.sharepoint.com" $ListName ="Documents" #Array to Results Data $DataCollection = @()
Read More
SharePoint Online: Find Duplicate Files using PowerShell SharePoint Online: Find Duplicate Files using PowerShell Reviewed by Salaudeen Rajack on April 23, 2019 Rating: 5

How to Get Office 365 Group Members using PowerShell?

April 07, 2019    ,
Requirement: Get Members of Office 365 Group using PowerShell How to Get Office 365 Group Members? To get a list of members in Office 365 group from Microsoft 365 admin center, Login to the Microsoft 365 Admin Center site: https://admin.microsoft.com Expand Groups and Click on Groups link in the left navigation.  Groups page lists all groups in your Office 365 tenant. Pick the desired group to list users in group. This opens the group's details page which lists group members PowerShell to Get Group Members in Office 365: Here is the Office 365 PowerShell get group members #Get Credentials to connect $Credential = Get-Credential #Create the session $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ ` -Credential $Credential -Authentication Basic -AllowRedirection #Import the session Import-PSSession $Session -DisableNameChecking #Get all Members of Office 365 Group Get-Unifie
Read More
How to Get Office 365 Group Members using PowerShell? How to Get Office 365 Group Members using PowerShell? Reviewed by Salaudeen Rajack on April 07, 2019 Rating: 5

How to Configure Document ID Service Feature in SharePoint Online?

March 27, 2019    , ,
What is Document ID Service in SharePoint Online? Document ID service in SharePoint Online automatically generates and assigns a unique number to each document which can be used to locate that document anywhere within the site collection. Once the uploaded document gets a unique number, a URL is also formed by this unique ID. So, we can use it to quickly find a document within the SharePoint Online site collection even when the document is moved to another location within the same site collection, as the document ID and URL  properties of the document don't change. How to Configure Document ID Feature in SharePoint Online? The Document ID Service is a feature that needs to be activated in SharePoint to provide unique IDs to documents in a site collection. To configure the Document ID Service, do the following: Navigate to the site collection Root >> Click on the "Settings" icon >> Site Information >> View all site settings. On the Site Settings p
Read More
How to Configure Document ID Service Feature in SharePoint Online? How to Configure Document ID Service Feature in SharePoint Online? Reviewed by Salaudeen Rajack on March 27, 2019 Rating: 5

PnP PowerShell: Connect-PnPOnline using AppID and AppSecret

March 26, 2019    ,
Requirement: Connect to SharePoint Online using PnP PowerShell Connect-PnPOnline with AppID and AppSecret I have a PnP PowerShell script scheduled in the Windows Task scheduler that runs for every 5 minutes. I need the script to connect to SharePoint Online unattended. Although I can store user name and passwords in the script, I don't want to do that as the passwords are regularly updated by our company policy. How to Connect to SharePoint Online using PnP PowerShell AppID and AppSecret?  The App method of authenticating allows us to run scripts without prompting username and password . Here are the steps to create a new app in SharePoint Online: Step 1: Register a SharePoint App Principal Register a new app in the app registry. Say, you need to connect to SharePoint Online site "https://tenant.sharepoint.com/sites/marketing", Navigate to the URL: https://tenant.sharepoint.com/Sites/Marketing/_layouts/15/AppRegNew.aspx , and register a new app principal: Clic
Read More
PnP PowerShell: Connect-PnPOnline using AppID and AppSecret PnP PowerShell: Connect-PnPOnline using AppID and AppSecret Reviewed by Salaudeen Rajack on March 26, 2019 Rating: 5

SharePoint Online: How to Delete a List Template using PowerShell?

March 26, 2019    , ,
Requirement: Delete list template in SharePoint Online How to delete a list template SharePoint Online? To remove a list template in SharePoint Online, do the following: Login to your SharePoint Online site collection (List templates are scoped at site collection level) >> Click on Settings >> Site Settings On Site Settings Page, Click on "List Templates" under Web Designer Galleries (https://Tenant.sharepoint.com/sites/SiteURL/_catalogs/lt/Forms/AllItems.aspx) Select the list template to delete and click on "Delete Document" from the ribbon Confirm the prompt to delete custom list template in SharePoint Online. SharePoint Online: PowerShell to Delete List Template #Load SharePoint Online 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.
Read More
SharePoint Online: How to Delete a List Template using PowerShell? SharePoint Online: How to Delete a List Template using PowerShell? Reviewed by Salaudeen Rajack on March 26, 2019 Rating: 5

SharePoint Online: How to Change the Header Banner Image in Modern Site Pages?

March 24, 2019    ,
Requirement: Change the Header Banner Image in Modern Site Pages How to Change the Header Background image in SharePoint Online Site Page? Here is how to change the default header image on the 'Site Page' on SharePoint Online: Navigate to the modern site page. E.g. https://crescent.sharepoint.com/sites/marketing/SitePages/About-Us.aspx Click on "Edit" button on the top right area.  Click on the top-header area to select it. Click on the little image icon as shown below. You can upload new image, use URL, or select an existing image for banner from the site. Once selected, drag and set a focal point. Save and publish the page. Tips:  Here is the Sharepoint Online modern page banner image size recommendations from Microsoft: Banner Image Size Reference for SharePoint Online PnP PowerShell to Change Banner Image: Here is the PnP PowerShell script to change the banner image in a site page: #Parameter $SiteURL= "https://crescent.sharepoint.com/s
Read More
SharePoint Online: How to Change the Header Banner Image in Modern Site Pages? SharePoint Online: How to Change the Header Banner Image in Modern Site Pages? Reviewed by Salaudeen Rajack on March 24, 2019 Rating: 5

SharePoint Online: "Anyone with the link" is Greyed Out

March 24, 2019    ,
Problem: "Anyone with the link" is disabled in SharePoint Online Share window is greyed out! How to Enable Anyone with the link option in SharePoint Online? As a first step, we need to enable sharing with anonymous users at tenant level. Here is how to enable external users with anonymous links in SharePoint Online tenant. Login to Office 365 Admin Center >> SharePoint admin center  Click on "Sharing" from left navigation >>  Set " Sharing outside your organization " to "Allow sharing to authenticated external users and using anonymous access links" Click "OK" to save your changes. PnP PowerShell to Enable Guest Sharing for a Site Collection Once the external sharing with anonymous access is enabled at the tenant level, we have to make sure its enabled at site collection level also. #Parameter $SiteURL= "https://crescent.sharepoint.com/sites/marketing" #Connect to PnP Online Connect-PnPOnline -
Read More
SharePoint Online: "Anyone with the link" is Greyed Out SharePoint Online: "Anyone with the link" is Greyed Out Reviewed by Salaudeen Rajack on March 24, 2019 Rating: 5

SharePoint Online: How to Exclude Site from Search Results?

March 23, 2019    , , , ,
Requirement: Exclude Site from Search in SharePoint Online How to Exclude a SharePoint Online Site from Search? SharePoint Online search results are security trimmed by default. Users get search results from all sites where they have access. However, there are some scenarios where you may want to prevent a site to appear in search results, E.g. We've got a document archive site collection for backup purposes, and we don't want results from this site to appear in global search results. Open the SharePoint Online site which you want to prevent to appear in the search result.  Click on Settings Icon and then choose "Site Settings" In Site Settings page, click on the "Search and offline availability" link under the "Search" section. Set the "Allow this site to appear in search results?" option to "No" in the Indexing Site Content section, Then click on OK. These changes take effect after the next crawl - The site and
Read More
SharePoint Online: How to Exclude Site from Search Results? SharePoint Online: How to Exclude Site from Search Results? Reviewed by Salaudeen Rajack on March 23, 2019 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.