Get-Set OneDrive Site Collection Storage Quota Size using PowerShell

December 26, 2017    , , ,
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
Read More
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 December 26, 2017 Rating: 5

Get All SharePoint Online Site Collections Inventory using PowerShell

December 24, 2017    , , , , ,
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
Read More
Get All SharePoint Online Site Collections Inventory using PowerShell Get All SharePoint Online Site Collections Inventory using PowerShell Reviewed by Salaudeen Rajack on December 24, 2017 Rating: 5

How to Disable Auditing in SharePoint using PowerShell?

December 23, 2017    , , ,
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
Read More
How to Disable Auditing in SharePoint using PowerShell? How to Disable Auditing in SharePoint using PowerShell? Reviewed by Salaudeen Rajack on December 23, 2017 Rating: 5

SharePoint Online: Add Site Column to List using PowerShell

December 20, 2017    , , , , ,
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\
Read More
SharePoint Online: Add Site Column to List using PowerShell SharePoint Online: Add Site Column to List using PowerShell Reviewed by Salaudeen Rajack on December 20, 2017 Rating: 5

SharePoint Online: Restore Deleted Subsite from Recycle Bin using PowerShell

December 19, 2017    , , , ,
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
Read More
SharePoint Online: Restore Deleted Subsite from Recycle Bin using PowerShell SharePoint Online: Restore Deleted Subsite from Recycle Bin using PowerShell Reviewed by Salaudeen Rajack on December 19, 2017 Rating: 5

SharePoint Online: Get Recycle Bin Storage Size using PowerShell

December 18, 2017    , , , ,
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
Read More
SharePoint Online: Get Recycle Bin Storage Size using PowerShell SharePoint Online: Get Recycle Bin Storage Size using PowerShell Reviewed by Salaudeen Rajack on December 18, 2017 Rating: 5

SharePoint Online: How to Hide Default Themes?

December 17, 2017    , , , , , ,
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
Read More
SharePoint Online: How to Hide Default Themes? SharePoint Online: How to Hide Default Themes? Reviewed by Salaudeen Rajack on December 17, 2017 Rating: 5

How to Add Domain to Office 365 - Step by Step

December 15, 2017    ,
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
Read More
How to Add Domain to Office 365 - Step by Step How to Add Domain to Office 365 - Step by Step Reviewed by Salaudeen Rajack on December 15, 2017 Rating: 5

SharePoint Online: Delete Site Collection from Recycle Bin using PowerShell

December 13, 2017    , , , ,
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 (Otherwise, It gives error: New-SPOSite : A site already exists at url https://yourtenant.sharepoint.com) 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 i
Read More
SharePoint Online: Delete Site Collection from Recycle Bin using PowerShell SharePoint Online: Delete Site Collection from Recycle Bin using PowerShell Reviewed by Salaudeen Rajack on December 13, 2017 Rating: 5

SharePoint Online: Check If Folder Exists using PowerShell

December 12, 2017    , , ,
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
Read More
SharePoint Online: Check If Folder Exists using PowerShell SharePoint Online: Check If Folder Exists using PowerShell Reviewed by Salaudeen Rajack on December 12, 2017 Rating: 5

How to Enable Custom Script in SharePoint Online?

December 09, 2017    , ,
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
Read More
How to Enable Custom Script in SharePoint Online? How to Enable Custom Script in SharePoint Online? Reviewed by Salaudeen Rajack on December 09, 2017 Rating: 5

SharePoint Online: Disable Alerts using PowerShell

November 30, 2017    , , ,
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.
Read More
SharePoint Online: Disable Alerts using PowerShell SharePoint Online: Disable Alerts using PowerShell Reviewed by Salaudeen Rajack on November 30, 2017 Rating: 5

Content Editor, Script Editor Web Part Missing in SharePoint Online?

November 29, 2017    , ,
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
Read More
Content Editor, Script Editor Web Part Missing in SharePoint Online? Content Editor, Script Editor Web Part Missing in SharePoint Online? Reviewed by Salaudeen Rajack on November 29, 2017 Rating: 5

How to Add a Custom Tile to SharePoint 2016 App Launcher?

November 28, 2017    ,
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
Read More
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 November 28, 2017 Rating: 5

SharePoint Online: Change Idle Session Timeout Settings

November 28, 2017    , , ,
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
Read More
SharePoint Online: Change Idle Session Timeout Settings SharePoint Online: Change Idle Session Timeout Settings Reviewed by Salaudeen Rajack on November 28, 2017 Rating: 5

SharePoint Online: How to Add New Custom Theme using PowerShell?

November 25, 2017    , , , , ,
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
Read More
SharePoint Online: How to Add New Custom Theme using PowerShell? SharePoint Online: How to Add New Custom Theme using PowerShell? Reviewed by Salaudeen Rajack on November 25, 2017 Rating: 5

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

November 24, 2017    ,
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
Read More
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 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

Find All Office 365 Group Sites in SharePoint Online

November 23, 2017    , , ,
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
Read More
Find All Office 365 Group Sites in SharePoint Online Find All Office 365 Group Sites in SharePoint Online Reviewed by Salaudeen Rajack on November 23, 2017 Rating: 5

SharePoint Online: Enable-Disable "Everyone" Group using PowerShell

November 18, 2017    , ,
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. #
Read More
SharePoint Online: Enable-Disable "Everyone" Group using PowerShell SharePoint Online: Enable-Disable "Everyone" Group using PowerShell Reviewed by Salaudeen Rajack on November 18, 2017 Rating: 5

SharePoint Online: Get-Set Lookup Column Values using Powershell

November 17, 2017    , , ,
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&
Read More
SharePoint Online: Get-Set Lookup Column Values using Powershell SharePoint Online: Get-Set Lookup Column Values using Powershell Reviewed by Salaudeen Rajack on November 17, 2017 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.