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" -Limit ALL -includepersonalsite $True $Result=@() # Get storage quota of each site Foreach($Site in $OneDriveSites) { $Result += New-Obj
Requirement: Get all site collections inventory in SharePoint Online using PowerShell PowerShell to Get All SharePoint Online Site Collections Inventory: Let's get list of SharePoint Online sites using PowerShell 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 col
Requirement: Disable auditing in SharePoint site collection. How to Disable Auditing in SharePoint? You may want to, To disable auditing for a SharePoint On-premises site collection follow these steps: Go to Site Settings >> Click on "Site Collection Audit settings" under site collection administration. In Configure Audit Settings page, clear all check boxes such as "Opening or downloading documents, viewing items in lists, or viewing item properties", "Editing items", etc. and click on "OK" to save your changes. This turns off auditing for the particular site collection. However, when you have a large number of site collections and want to turn off auditing for all, utilize PowerShell! PowerShell to Disable Auditing for All Site Collections of a SharePoint On-premises web application: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Set Web Application URL $WebAppURL="http://intranet.crescent
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\
Requirement: User had deleted a sub site by mistake. Now the requirement is to restore the deleted subsite in SharePoint Online. How to restore deleted subsite in SharePoint? To restore a deleted subsite in SharePoint, follow these steps: Login to SharePoint Online Site collection as site collection administrator Navigate to Site Settings >> Click on "Recycle bin" under site collection administration Click on "Second-stage recycle bin" link and select the desired subsite by clicking the checkbox of the subsite ( 2nd stage recycle bin direct URL: https://crescent.sharepoint.com/sites/Marketing/_layouts/15/AdminRecycleBin.aspx?view=13) Click on "Restore" button in the ribbon to start restoring the subsite. By default, deleted items are retained for 93 days in the recycle bin. If you don't find your subsite under recycle bin - Your site may be completely deleted! So you are left with restoring the content database backups in SharePoi
Requirement: Get the recycle bin storage space consumption of all SharePoint Online site Collections. SharePoint Online: Find Recycle Bin Storage Size of a Site Collection #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" #Variables for Processing $SiteUrl = "https://crescenttech.sharepoint.com/Sites/Marketing" #Setup Credentials to connect $Cred = Get-Credential Try { #Setup the context $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.UserName,$Cred.Password) #Get the Site collection's recycle bin: both 1st stage and 2nd stage $RecycleBinItems = $Ctx.Site.RecycleBin
Themes are quick way to add branding to SharePoint Online sites. However, we wanted to restrict site owners from changing the themes for uniform look and feel over all sites. Fortunately, SharePoint Online provides a cmdlet to hide default themes and enforce governance. PowerShell to Hide Default Themes in SharePoint Online: Open SharePoint Online Management Shell, and run this PowerShell script to hide default themes in SharePoint Online. #SharePoint Online Admin Center URL $AdminURL = "https://crescent-admin.sharepoint.com/" #Get Credentials to connect $Cred = Get-Credential #Connect to SharePoint Online Connect-SPOService -url $AdminURL -credential $Cred #Check If Default Themes are hidden already If(Get-SPOHideDefaultThemes) { Write-Host -f Yellow "Default themes are already hidden!" } Else { Set-SPOHideDefaultThemes $True Write-Host -f Yellow "Default themes are now hidden!" } Now, this is what you get when you click on "Ch
Domain names plays vital role in establishing trust and personalized brand to your organization. Its typically used in your website addresses and Email Ids. When you first signup for Office 365, The default domain name "Your-domain.onmicrosoft.com" will be assigned. Until you add your own domain to Office 365, any new users that you create contain the default domain name. E.g. your Email Ids looks like Salaudeen@SharePointDiary.onmicrosoft.com . You can change it to a personalized address like Salaudeen@SharePointDiary.com. Here is my step-by-step configuration guide to add a custom domain to Office 365. Prerequisites: I'm assuming you have an existing domain registered with GoDaddy.com and you have credentials to login to the DNS control panel of GoDaddy. In my case, I've an existing domain purchased from GoDaddy "TheCrescentTech.com". Adding domain to Office 365 is a two step process. First you need to verify the domain with Microsoft, that you are
Requirement: Delete Site Collection from recycle bin in SharePoint Online How to Delete SharePoint Online Site from recycle bin? When we delete a SharePoint Online site collection, it goes to the Recycle Bin and stays there for 93 days. However, at times we may want to completely delete the site from recycle bin too for reasons such as: We ran shortage of storage quota, and we want to delete the site collection to obtain the space. We need to create a new site collection with the same URL of the deleted site Permanently Delete Site Collection from Recycle bin To delete a site permanently from recycle bin in SharePoint Online, follow these steps: Login to Office 365 Admin >> SharePoint Online Admin Center Click on "Sites" >> "Deleted Sites" link from left navigation Select the site from the list and click on "Delete" button in the toolbar Confirm delete operation in the prompt! SharePoint Online: Delete Site Collection from
Requirement: Check if folder exists in SharePoint Online document library. SharePoint Online: PowerShell to Check If Folder Exists Here is the PowerShell for SharePoint Online to check if folder exists. #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 to check if folder Exists Function Check-SPOFolderExists() { param ( [Parameter(Mandatory=$true)] [string] $SiteURL, [Parameter(Mandatory=$true)] [string] $FolderRelativeURL ) Try { #Get Credentials to connect $Cred= Get-Credential $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password) #Setup the context $Ctx = New-Object Microsoft
Requirement: Allow custom script in SharePoint Online! By default, Custom Scripts are disabled in SharePoint Online for security reasons. So the below features are blocked when the custom scripting is disabled: Many web parts including content editor, script editor, etc are disabled. Uploading files that potentially include scripts are blocked SharePoint Designer script changes not allowed Save Site as Template, Save document library as template links disabled Solution Gallery, Sandbox Solutions, Theme Gallery, HTML Field Settings are not available All other script-related featured are turned off So, To fix the above problems, we need to enable custom script settings. Here is how to enable custom script in SharePoint Online. How to Enable Custom Script in SharePoint Online? To allow custom script in SharePoint Online, follow these steps: Sign in to Office 365 and go to the SharePoint Online Admin Center. Click on Settings from the left navigation >> Scroll down
Requirement: Disable Alerts in SharePoint Online! How to disable alerts in SharePoint Online? Well, there is no way to disable alerts from SharePoint Online user interface. (You can delete alerts however!). We can use PowerShell to disable alerts in a SharePoint site. PowerShell to Disable All Alerts of a User: Lets disable all alerts of a particular user in a given web - SharePoint Alerts are scoped at web object! #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" #Config Parameters $SiteURL= "https://crescent.sharepoint.com" $UserID="Salaudeen@Crescent.com" #Setup Credentials to connect $Cred = Get-Credential $Cred = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.
Problem: Content Editor WebPart in SharePoint Online is Missing! Fix SharePoint Online Content Editor web part missing Issue: In Modern SharePoint Online sites (E.g. Group Sites, Communication Sites), Self-serviced sites and in Root site, custom scripting is disabled by default! To enable content editor webpart and other web parts you should enable custom scripting in SharePoint Online. How to Enable Custom Scripting in SharePoint Online? To enable custom scripting at SharePoint Online Admin Center, Follow these steps: How to Enable Custom Script in SharePoint Online? This makes the content Editor web part available! Not just content editor, but also: Script Editor Web Part, Business data web part, search web part , etc. Custom Script is already enabled, But still not getting Content Editor web part and Other Web Parts? Well, if the custom script setting is already enabled in SharePoint Online Admin Center, Try running this cmdlets again to enforce Custom Script settings
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
Task: Set idle session timeout value for SharePoint Online. How to Set SharePoint Online Idle Session Timeout? Idle session timeout in SharePoint Online is a security mechanism which warns and sign outs the user after a period of inactivity. By default, idle session timeout settings are disabled in SharePoint Online. To set default session timeout values, use the PowerShell cmdlet: Set-SPOBrowserIdleSignOut The idle timeout settings are applicable only to web browsers - doesn't affect any clients such as OneDrive Sync client - they stay logged in as usual. SharePoint Online: Configure Idle Session Timeout using PowerShell Open SharePoint Online Management Shell and run this PowerShell script to change SharePoint online session timeout: #Set Config parameters $AdminSiteURL = "https://crescent-admin.sharepoint.com/" #Connect to SharePoint Online Tenant Admin Connect-SPOService -URL $AdminSiteURL -Credential (Get-Credential) #Get Current Idle session Time
Requirement: Create New Theme in SharePoint Online How to create new color theme in SharePoint Online? SharePoint Online Modern sites (Teams, Communications and Hub sites) provides set of default themes (Blue, Orange, Red, Purple, Green and Gray), which you can use to quickly change the look and feel or appearance of your SharePoint Online sites. In addition, you can create new theme for a more customized experience for your users. Here are the steps to add custom theme in SharePoint Online: Step 1: Create New Color Theme in SharePoint Online Create new theme in SharePoint Online using this theme designer: https://developer.microsoft.com/en-us/fabric#/styles/themegenerator , Customize and Copy the theme output. Step 2: Add Custom Theme to SharePoint Online using PowerShell Once the theme is created using theme designer, add the theme color to SharePoint Online using PowerShell. Open SharePoint Online Management Shell, run this script: #Define the color palette $ThemePallette
Problem: When trying to Share a document with an external user, received the error message: "Your organization's policies don't allow you to share with these users. Go to External Sharing in the Office 365 admin center to enable it." Root cause: External Sharing is disabled either at tenant level or site collection level! Solution: Enable External Sharing for SharePoint Online at tenant level and site collection level. Follow these steps to enable external users sharing 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 either "Allow users to invite and share with authenticated external users" or "Allow sharing to authenticated external users and using anonymous access links" Click "OK" to save your changes. External Sharing is already Enabled, Still getting thi
Fix "Your organization's policies don't allow you to share with these users. Go to External Sharing in the Office 365 admin center to enable it" Error in SharePoint Online
Reviewed by Salaudeen Rajack
on
November 24, 2017
Rating: 5
Requirement: Get All Group Sites in SharePoint Online. How to find all group-connected team sites in SharePoint Online? The new SharePoint Online admin center lists all group sites and modern sites. You can login to SharePoint Online Admin Center >> Click on "Active Sites" and then look for "Primary Admin" Column which has "Group Admin" to get the list of all SharePoint Online group site collections. SharePoint Online: List Group Sites using PowerShell Run these lines of PowerShell script in SharePoint Online Management Shell. #Set Admin Center URL $AdminCenterURL = "https://crescent-admin.sharepoint.com/" #Connect to SharePoint Online Connect-SPOService -url $AdminCenterURL -Credential (Get-Credential) #Get All Group Sites Get-SPOSite | Where { $_.Template -like 'GROUP*'} | Select URL This gets you the list of all group sites! Get All Group Sites in SharePoint Online and Export to CSV: Gets get a list of gro
Requirement: Disable Everyone group in SharePoint Online. "Everyone" claims in SharePoint Online consists of all users already having access to the site - This includes all accounts from the authentication provider (typically Active Directory) as well as any external accounts that are invited to the tenant. This is equivalent to the "all authenticated users" who needs to login (not anonymous users). Check if "Everyone" group is enabled or Disabled: From SharePoint Online Management Shell, Type: Get-SPOTenant to get all properties of the SharePoint Online tenant which tells us whether "Everyone" and "Everyone Except External Users" groups are hidden. "Everyone" group can be hidden from Office 365 SharePoint Online tenant people picker with the below PowerShell script. How to disable everyone Group in SharePoint Online? To disable everyone, enter the below PowerShell snippet in SharePoint Online Management Shell. #
Requirement: Get or Set Lookup field values in SharePoint Online using PowerShell. Scenario: We've a parent list called "Parent Projects" and child list "Project Milestones". The "Parent Project Name" field in the child list is being looked up from the parent list's "Project Name" field. Here is my PowerShell scripts to get and set lookup field values. PowerShell to Get Lookup Field Value in SharePoint Online: To retrieve the value of lookup column in a SharePoint Online list, use this 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\Microsoft.SharePoint.Client.Runtime.dll" #Set parameter values $SiteURL="https://crescent.sharepoint.com/Sites/PMO" $ListName="Project Milestones&
Requirement: View all alerts in SharePoint Online site collection. How to Get all alerts of a user in SharePoint Online ? Alerts are scoped at web level in SharePoint. So, to get alerts of a user in a specific site, follow these steps: Navigate to the site >> Go to Site Settings page Click on "User alerts" link under "Site Administration" Select the user from the drop down and click on "Update" button to view all alerts. This gets you all alerts of the selected user on the current site . Now the question is: How to view all alerts of a SharePoint Online user for a entire site collection? PowerShell! PowerShell to Fetch All Alerts from SharePoint Online: Here is the SharePoint Online PowerShell to get alerts from a site collection. #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
Reviewed by Salaudeen Rajack
on
December 26, 2017
Rating:
