SharePoint folder deletion error: Cannot delete/checked out issue

Recently I have seen an issue where user was unable to delete a folder in a SharePoint online document library because a file was checked out for editing by a user. An in folder there was not file with pending checkout. And mandatory checkout was disabled on the document library. Solution: There were mandatory fields …

Continue reading ‘SharePoint folder deletion error: Cannot delete/checked out issue’ »

SharePoint Post Migration Comparison Report to Verify Migrated content using PowerShell

Being involved in migrations for past couple of years, one of the pain area is to verify the migrated content. There are some amazing migration tools like Sharegate, Metalogix, AvePoint and they provide some very useful reports to verify the content but still I haven’t seen a report which can compare the migrated content in …

Continue reading ‘SharePoint Post Migration Comparison Report to Verify Migrated content using PowerShell’ »

Adding a Column to list Index using PowerShell and UI

Adding a column to a SharePoint list is pretty simple job, you need Edit permission on the list to update the list column index and also item count in list must be less than 20000 as you can not add a field to list index if item count is over 20K. You can add upto …

Continue reading ‘Adding a Column to list Index using PowerShell and UI’ »

SharePoint Important URLs

Being working on SharePoint for last one decade, I always use shortcut to reach out to different content. Shortcut means typing URLs directly in address bar instead of going through site navigation. My most favorite URLs which I used most are /_layouts/15/viewlsts.aspx and /_layouts/15/settings.aspx. There are couple of important URLs or pages which you need …

Continue reading ‘SharePoint Important URLs’ »

How to create a multiline text field as searchable

This is one of the challenges to SharePoint search content on a list from multiline field. Multi line text field cannot be indexed as it’s an Unsupported Column Type. Indexing the field is separate from search crawling which is needed for search result. Make sure the column has a managed property which allows a column …

Continue reading ‘How to create a multiline text field as searchable’ »

SharePoint listing all documents with versioning detail

Document library in SharePoint shows count of the documents only, but there are many minor and major versions for a document. In this blog post I am going to share how we can generate a report for a document library which have details for all major and minor versions of document version size and checkedIn …

Continue reading ‘SharePoint listing all documents with versioning detail’ »

SharePoint Storage Metrics to Check size of a document Library

SharePoint storage gives us a very useful report to understand the size of a site, sub site, list and library. To view the Storage Metrics report you have to follow simple steps Go to Site Collection Settings –> Site Collection Administration –> Storage Metrics You can drill down the document library or sub site to …

Continue reading ‘SharePoint Storage Metrics to Check size of a document Library’ »

SharePoint Performance Issue- Set Memory Limits on SQL Server

By default, SQL Server is set to use max 2TB of RAM. You might not be having 2TB RAM in your environment, you might have 8GB, 16GB or more depending on your farm and SharePoint installation. Here is a formula to determine memory size for all instances of SQL Server. SQL Max Memory= TotalPhysicalMemory – …

Continue reading ‘SharePoint Performance Issue- Set Memory Limits on SQL Server’ »

Append changes to track comments in a SharePoint list

You might have seen comments on blogs/wiki page, or you can have seen comments when you checked in or publish a document in SharePoint. These comments are used to track the changes or communication for that change. Similar functionality can be achieved on a SharePoint list, I have seen many companies saving their procurement details …

Continue reading ‘Append changes to track comments in a SharePoint list’ »

Update default SharePoint security groups for a site

Recently I have seen an issue on a SharePoint site which was not showing the default security groups and due to that site owners were not able to approve the access requests. I investigated the issue and came to know that site do not have default security groups. This happened because site was migrated from …

Continue reading ‘Update default SharePoint security groups for a site’ »