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

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

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: 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.
SharePoint Online: Disable Alerts using PowerShell SharePoint Online: Disable Alerts using PowerShell Reviewed by Salaudeen Rajack on November 30, 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
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: Find All External Users using PowerShell

November 13, 2017    , ,
Users outside of the organizations can be invited to collaborate to SharePoint Online as "External Users". As Microsoft says "An external user is someone outside of your organization who can access your SharePoint Online sites and documents but does not have a license for your SharePoint Online or Microsoft Office 365 subscription. External users are not employees, contractors, or onsite agents for you or your affiliates." SharePoint Online: How to Get External Users? As part of governance policies, we wanted to take control over external sharing, So I had to see how many external users are added to SharePoint Online and where. The Get-SPOExternalUser cmdlet displays a list of all external users in our Office 365 tenant. For an external user to be listed using this PowerShell cmdlet, they need to have accepted the invitation to the SharePoint Online environment, and have logged in at least once. Find External Users in SharePoint Online: To view external user
SharePoint Online: Find All External Users using PowerShell SharePoint Online: Find All External Users using PowerShell Reviewed by Salaudeen Rajack on November 13, 2017 Rating: 5

SharePoint Online: Grant Permission to List Item using PowerShell

November 12, 2017    , , ,
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 November 12, 2017 Rating: 5

SharePoint Online: Find All Lists with Unique Permissions using PowerShell

November 12, 2017    , , , ,
Requirement: Get All Lists and Libraries with Unique Permissions using PowerShell How to Check if a list is using Unique permissions or inheriting permissions from the parent? To get if list or library has unique permissions, follow these steps: Navigate to the list and then go to List or Library Settings. In List settings page click on "Permissions for this List/Document library" link The list settings page gives you the information whether the list has unique permissions. If the list or library has unique permissions, you'll get the text " This list/library has unique permissions ", otherwise " This list/library inherits permissions from its parent." Check If the List or Library has Unique Permissions using PowerShell:  Lets check if the given list has unique permissions  #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll&qu
SharePoint Online: Find All Lists with Unique Permissions using PowerShell SharePoint Online: Find All Lists with Unique Permissions using PowerShell Reviewed by Salaudeen Rajack on November 12, 2017 Rating: 5

SharePoint Online: How to Hide "Create Site" Link?

November 11, 2017    
Requirement: Disable Create site link from SharePoint Online home page! The "Create Site" link in SharePoint Online Home (https://crescenttech.sharepoint.com/_layouts/15/sharepoint.aspx) helps end users to create their own modern SharePoint sites. We got a requirement to disable this "Create Site" Link as a policy decision. How to Hide the "Create Site" Link in SharePoint Online Home? To disable create site link, follow these steps: Login to SharePoint Online Admin Center (https://yourcompany-admin.sharepoint.com) Click on "Settings" in left navigation Under "Site Creation" section, select "Hide the Create site command" Click on "OK" to save your changes! This hides "Create Site" link in SharePoint Online home page for everyone including administrators (Admins can create sites via SharePoint Online Admin center or PowerShell) once you logout and login back!
SharePoint Online: How to Hide "Create Site" Link? SharePoint Online: How to Hide "Create Site" Link? Reviewed by Salaudeen Rajack on November 11, 2017 Rating: 5

SharePoint Online: Delete Alerts using PowerShell

October 30, 2017    , , ,
Requirement: Delete Alerts in SharePoint Online How to Delete Alerts in SharePoint Online? To delete an alert from SharePoint Online, follow these steps: Login to SharePoint Online >> Navigate to Site Settings page. Under "Site Administration" section, Click on "User Alerts" link This page lists alerts of all users in the particular site (web). Pick the user from the drop down and click on "Update" button to retrieve all alerts of the user. Once alerts are listed, can select either single alert or multiple alerts and then click on "Delelte Selected Alerts" link. SharePoint Online: Delete All Alerts of a User using PowerShell We can use PowerShell to delete all alerts of a particular user in SharePoint Online.   #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 F
SharePoint Online: Delete Alerts using PowerShell SharePoint Online: Delete Alerts using PowerShell Reviewed by Salaudeen Rajack on October 30, 2017 Rating: 5

SharePoint Online: Create Alerts using PowerShell CSOM

October 28, 2017    , , ,
Requirement: Create SharePoint Alert using PowerShell How to Create Alerts in SharePoint Online? Alerts in SharePoint Online helps to track changes such as addition/changes/delete to the content E.g. Lists and libraries, pages, etc. To create an Alert for a SharePoint Online document library, follow these steps: Go to your SharePoint Online site, Navigate to the document library for which you want to create an alert From the Toolbar, Click on the ellipses and select "Alert Me". In the new alert creation page, Type the alert title, enter users who will receive notifications,  Select E-mail or SMS for "Delivery Method". Select the condition for this alert (e.g. "Anything changes") and when to send alerts. Scroll to the bottom of the page and click "OK" to create an alert for the document library. Now, Lets create SharePoint online alert using PowerShell! SharePoint Online: PowerShell to Create Alert We want to add an alert program
SharePoint Online: Create Alerts using PowerShell CSOM SharePoint Online: Create Alerts using PowerShell CSOM Reviewed by Salaudeen Rajack on October 28, 2017 Rating: 5

SharePoint Online: Export Document Library Metadata to Excel

October 27, 2017    , , , ,
Requirement: Export SharePoint Online Document Library Metadata to a CSV file. Export Document Library Metadata to CSV using PowerShell: To export a document library's metadata into Excel, You can use: "Export to Excel" button on any SharePoint Online library. However, this functionality doesn't give you details such as: Number of Versions, File size, etc. Here is the PowerShell CSOM script to extract the metadata of all documents under a specific document library and export to Excel. #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 get all files of a folder Function Get-FilesFromFolder([Microsoft.SharePoint.Client.Folder]$Folder) { Write-host -f Yellow "Processing Folder:&qu
SharePoint Online: Export Document Library Metadata to Excel SharePoint Online: Export Document Library Metadata to Excel Reviewed by Salaudeen Rajack on October 27, 2017 Rating: 5

SharePoint Online: Remove User or Group from Folder Permissions using PowerShell

October 21, 2017    , , ,
Requirement: Remove user from folder permissions in SharePoint Online. How to Remove user from folder permissions in SharePoint Online? How to restrict access to folder in SharePoint Online? To remove a user or group from SharePoint Online Folder's permissions, follow these steps: Navigate to your SharePoint Online list or library where the target folder is located.  Click on "Details" from the specific Folder's context menu >> In the Details pane, Click on "Manage Access" and then "Advanced" links. This takes you to the "Advanced Permissions" page From the ribbon, Click on "Stop Inhering Permissions" button and confirm the prompt. Now, You'll get the list of users and groups who have permissions on the folder. When you break the permission, SharePoint copies permissions from its parent (List/library in our case!) . Select the users and groups you want to remove permission from folder and confirm the prompt.
SharePoint Online: Remove User or Group from Folder Permissions using PowerShell SharePoint Online: Remove User or Group from Folder Permissions using PowerShell Reviewed by Salaudeen Rajack on October 21, 2017 Rating: 5

How to Create OneDrive for Business Site Collections using PowerShell?

October 21, 2017    , , , , ,
Requirement: OneDrive sites in Office 356 are typically created when they click on OneDrive link for the first time. In my case, for a file share to SharePoint Online OneDrive migration project, I had to pre-create OneDrive for Business sites for N number of users. How to Create OneDrive Sites using PowerShell? OneDrive for Business sites can be pre-created using a PowerShell cmdlet "Request-SPOPersonalSite". Open SharePoint Online Management Shell, Connect as SharePoint Online Administrator by entering the appropriate credentials to the prompt. $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 #Create My Site for specific user(s) Request-SPOPersonalSite -UserEmails "peter@crescent.com","john@crescent.com" -NoWait $True Wait for new Minutes, SharePoint On
How to Create OneDrive for Business Site Collections using PowerShell? How to Create OneDrive for Business Site Collections using PowerShell? Reviewed by Salaudeen Rajack on October 21, 2017 Rating: 5

SharePoint Online: Remove List from Search using PowerShell

October 18, 2017    , ,
By default, all SharePoint Online lists and libraries appears in Search results. There are some cases you want to remove a particular list's contents from appearing in search results. Say e.g. You want to hide images library's content from appearing in Search results.   How to Remove a list from SharePoint Online Search: To exclude a list or library from search index using user interface, go to : List Settings >> Click on "Advanced Settings"  Scroll down and under Search section, select "Yes"  for "Allow items from this document library to appear in search results?" Option. Click OK to commit changes. This setting allows or disallows SharePoint Online crawler to index the list. Wait for 4 to 6 Hours and this list should be removed from search results. How to Remove SharePoint Online List from Search using PowerShell: Lets use PowerShell to exclude the list or library from SharePoint Online search. #Load SharePoint CSOM Assembl
SharePoint Online: Remove List from Search using PowerShell SharePoint Online: Remove List from Search using PowerShell Reviewed by Salaudeen Rajack on October 18, 2017 Rating: 5

SharePoint Online: How to Disable Flow in Lists and Libraries?

October 14, 2017    , , , ,
Requirement: Disable flow in SharePoint Online. Microsoft Flow is a great tool to automate business processes by building workflows . In some cases, to take control over customization, You may want to disable Flows by hiding the "Flow" button in modern lists and libraries in SharePoint Online. How to Disable Flow in SharePoint Online? There is no way to disable Microsoft Flow Out-of the box through browser. We've to use PowerShell. Assuming you have the latest SharePoint Online Management Shell installed in your machine, here is how to disable or enable Flow in SharePoint Online site collection via SharePoint Online Management Shell. #Set parameter values $AdminSiteURL="https://crescent-admin.sharepoint.com/" $SiteURL="https://crescent.sharepoint.com/" #Connect to SharePoint Online Admin Site Connect-SPOService -Url $AdminSiteURL -Credential (Get-Credential) # Disable flows on a site collection Set-SPOSite -Identity $SiteURL -DisableFlows D
SharePoint Online: How to Disable Flow in Lists and Libraries? SharePoint Online: How to Disable Flow in Lists and Libraries? Reviewed by Salaudeen Rajack on October 14, 2017 Rating: 5

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

October 11, 2017    , , , ,
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 October 11, 2017 Rating: 5
Powered by Blogger.