kwizcom banner advertisement

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
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: 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 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
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\
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
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. PowerShell to Get SharePoint Online Recycle bin Storage Size: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.SharePoint.Client.dll" Add-Type -Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.SharePoint.Client.Runtime.dll" Add-Type -Path "C:\Program Files\SharePoint Online Management Shell\Microsoft.Online.SharePoint.PowerShell\Microsoft.Online.SharePoint.Client.Tenant.dll" #Function to Get the recycle bin Size of a SharePoint Online site collection Function Get-SPOSiteRecycleBinSize($SiteURL, $Cred) { #Setup credentials $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password) #Set up the context $Context = New-Object Mi
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
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
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

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 run 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 the delete operation in the prompt! SharePoint Online: Delete Site Collection fr
SharePoint Online: Delete Site Collection from Recycle Bin SharePoint Online: Delete Site Collection from Recycle Bin 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 #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.SharePoint.Client.ClientContext($SiteURL) $Ctx.Credentials = $Cred
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, will be blocked SharePoint Designer script changes not allowed Save Site as Template is disabled 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 to "Custom Script" section Under Custom Script section, Set "Allow users to run custom script on personal s
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
Powered by Blogger.