kwizcom banner advertisement

SharePoint Online: Find All Large Files using PowerShell

November 12, 2018    , , ,
Requirement: Find all large files in SharePoint Online site collection. How to Find Large Files in SharePoint Online? To find large files in SharePoint Online, you can use "Storage Metrics" page. Navigate to your SharePoint Online site collection >> Click on Settings Gear >> Site Settings In Site Settings page, Click on "Storage Metrics" link under "Site Collection Administration" (https://crescent.sharepoint.com/_layouts/15/storman.aspx) The Storage Metrics page gives you the current Storage consumption of the site. You can navigate to each site/folder objects to get the storage stats of the particular object. You can also include the OOTB "File Size" column in your document library views to get the size of individual files! Explorer view also helps!! SharePoint Online: PowerShell to Get All Large Files in a Site Collection Getting large files by navigating into each folder from the above Storage metrics page is cumb
SharePoint Online: Find All Large Files using PowerShell SharePoint Online: Find All Large Files using PowerShell Reviewed by Salaudeen Rajack on November 12, 2018 Rating: 5

SharePoint Online: Site Collection Permissions Report using PowerShell

September 06, 2018    , , , ,
Requirement: Generate permissions report for a SharePoint Online site collection. SharePoint Online: Site Collection Permissions Report using PowerShell This PowerShell script generates permission report on all objects 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 All lists and libraries with unique permissions All list items with 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" Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #To call a non-generic method Load Function Invoke-LoadMethod() { param( [Microsoft.SharePoint.Client.ClientObject]$Object = $(throw "Please provide
SharePoint Online: Site Collection Permissions Report using PowerShell SharePoint Online: Site Collection Permissions Report using PowerShell Reviewed by Salaudeen Rajack on September 06, 2018 Rating: 5

SharePoint Online: Permission Report for Specific User in a Site Collection using PowerShell

September 04, 2018    , , , ,
Requirement:   Generate a permission report to audit a specific user's permissions in given SharePoint Online site collection, sub-sites, all its lists, libraries and list items. SharePoint Online PowerShell permissions report This PowerShell script checks user permissions and exports the findings into a CSV file. How to run this script? Just change the Parameters from Line#6 to Line#8 according to your environment and hit run. SharePoint Online: PowerShell to get user permissions on a given site collection  Here is how to check user permissions using PowerShell in SharePoint Online. Please note, there is a limitation in the script: This PowerShell script doesn't scan Active Directory security groups! #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\M
SharePoint Online: Permission Report for Specific User in a Site Collection using PowerShell SharePoint Online: Permission Report for Specific User in a Site Collection using PowerShell Reviewed by Salaudeen Rajack on September 04, 2018 Rating: 5

SharePoint Online: How to Remove Feedback Button?

July 18, 2018    ,
Requirement: Disable feedback button in SharePoint Online! Feedback button in bottom right of SharePoint Online gets your feedback comments to Microsoft Uservoice directly. In my case, End users thought their comments are going to the IT team of the organization and we wanted to hide feedback button in SharePoint Online to avoid the confusion. Disable Feedback Button in SharePoint Online: To remove remove feedback button in SharePoint Online, Open SharePoint Online Management Shell and run this PowerShell script. You'll be prompted for credentials.  #Set parameter values $AdminSiteURL="https://crescenttech-admin.sharepoint.com/" #Connect to SharePoint Online Admin Site Connect-SPOService -Url $AdminSiteURL -Credential (Get-Credential) # Disable Feedback button Set-SPOTenant -UserVoiceForFeedbackEnabled $False This turns off feedback for SharePoint Online at tenant level. We used CSS to hide feedback button in the past. But this is the perfect way to remove
SharePoint Online: How to Remove Feedback Button? SharePoint Online: How to Remove Feedback Button? Reviewed by Salaudeen Rajack on July 18, 2018 Rating: 5

Limit Search Results to a Specific Content Source in SharePoint 2016

May 03, 2018    , ,
Requirement:   HR team wants to setup a dedicated search portal to search a confidential file share. If its SharePoint 2010, we would have created a search scope and added rules to include only that specific content source to it. Now from SharePoint 2013 on wards search scopes has been replaced by result sources. So, lets see how to create a result source to limit search results only from a specific content source in SharePoint 2016. Before starting, I've following things configured already: A content source is created to index the specific file share with name "HR FileShare". Full crawl has been completed already. There is a subsite created with "Basic Search center" template to server as a dedicated search center. How to setup Search Result Source to Limit results to a Content Source? Result Sources can be created on three different levels: Search Service Application, Site collection and Site. For our requirement, lets create it at site level. Here
Limit Search Results to a Specific Content Source in SharePoint 2016 Limit Search Results to a Specific Content Source in SharePoint 2016 Reviewed by Salaudeen Rajack on May 03, 2018 Rating: 5

Find All OneDrive Site Collections in SharePoint Online using PowerShell

April 23, 2018    , , , ,
Requirement: Get a list of all OneDrive site collections from SharePoint Online. I was asked to get the list of all OneDrive sites to get the usage of OneDrive for Business in our Office 365 tenant. Its bit tricky to find all of your OneDrive site collections and here is how I achieved using Get-SPOSite cmdlet: Find All OneDrive Sites using SharePoint Online Management Shell: Here is the PowerShell script to get all OneDrive site collections in SharePoint Online. $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 Get-SPOSite -Template "SPSPERS" -limit ALL -includepersonalsite $True | Select URL, Owner | Format-table -autosize | Out-string -width 8096 | Out-file C:\temp\OneDriveSites.txt Just change the $AdminSiteURL t
Find All OneDrive Site Collections in SharePoint Online using PowerShell Find All OneDrive Site Collections in SharePoint Online using PowerShell Reviewed by Salaudeen Rajack on April 23, 2018 Rating: 5

Group By Content Type in SharePoint Online List View

January 22, 2018    , , , ,
Requirement: Set a List View Group by Content Type in SharePoint Online. How to Set a SharePoint Online View Group by Content Type? If you want to set a list view's group by option based on "Content Type" there is no option from web interface (because "Content Type" is missing from the list of columns in the drop-down!). Here is how you can group by content type. Option #1: Edit the List View using SharePoint Designer Here is how you can set a group by using SharePoint Designer: Create a List view from SharePoint web user interface Edit the view page in Advanced mode using SharePoint Designer.  Search for "<Query/>" and replace it with: <Query> <GroupBy Collapse='FALSE' GroupLimit='30' > <FieldRef Name='ContentType' /> </GroupBy> </Query> This method works on SharePoint On-premises as well. Option #2: Use PowerShell to Group by "Content Type&qu
Group By Content Type in SharePoint Online List View Group By Content Type in SharePoint Online List View Reviewed by Salaudeen Rajack on January 22, 2018 Rating: 5

SharePoint Online: Set Sort Order, Group By in a List View using PowerShell

January 22, 2018    , ,
Requirement:   Set Sort Order, Group By in a SharePoint Online List View using PowerShell How to Set Sort Order and Group By Settings for a SharePoint Online List View? To set sort order or group by in SharePoint List view, Modify the view and select the field in Sort and group by sections. PowerShell to Set  Sort Order, Group By in a List View 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 Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Set parameter values $SiteURL="https://crescenttech.sharepoint.com/" $ListName ="Documents" $ViewName="All Documents" Try { #Setup Credentials to connect $Cred= Get-Credential $Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cr
SharePoint Online: Set Sort Order, Group By in a List View using PowerShell SharePoint Online: Set Sort Order, Group By in a List View using PowerShell Reviewed by Salaudeen Rajack on January 22, 2018 Rating: 5

How to Make a Field Required in SharePoint List using PowerShell?

January 21, 2018    , , , , , ,
Requirement: Make a Field Required in SharePoint List. How to Make a Field Required in SharePoint List? To make field required in SharePoint, or to remove required field (to make it non-mandatory) in SharePoint list: Go to List Settings >> Pick the Field by Clicking on its "Title" under "Columns" Section  Set "Yes" for "Require that this column contains information" Click "OK" to save changes. This makes the field required.  PowerShell to Set a Field Required in SharePoint Online List: Here is the PowerShell to set a column as "required" #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://crescenttech
How to Make a Field Required in SharePoint List using PowerShell? How to Make a Field Required in SharePoint List using PowerShell? Reviewed by Salaudeen Rajack on January 21, 2018 Rating: 5

SharePoint Online: PowerShell to Get-Set Date Field Value

January 21, 2018    , ,
PowerShell to Get Date Column Value 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 Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll" #Set parameter values $SiteURL="https://crescenttech.sharepoint.com/" $ListName="Projects" $FieldName="StartDate" #Get Credentials to connect $Cred= Get-Credential #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 List $List = $Ctx.Web.lists.GetByTitle($ListName) #Get All List Items $ListItems = $List.GetItems([Microsoft.SharePoint.Client.CamlQuery]::CreateAllItemsQuery()) $Ctx.Load($ListItems) $Ctx.ExecuteQuery()
SharePoint Online: PowerShell to Get-Set Date Field Value SharePoint Online: PowerShell to Get-Set Date Field Value Reviewed by Salaudeen Rajack on January 21, 2018 Rating: 5
Powered by Blogger.