How to Set SharePoint 2013 Content Database to Read Only Mode using PowerShell?

January 29, 2016    , , , , , , ,
Requirement: Set content database to read only in SharePoint 2013 using PowerShell. Solution:   We may have to set SharePoint databases to read-only mode in scenarios such as: upgrades, disaster recovery / highly available maintenance, patching, etc. Setting SharePoint content database in read…

How to Set SharePoint 2013 Content Database to Read Only Mode using PowerShell? How to Set SharePoint 2013 Content Database to Read Only Mode using PowerShell? Reviewed by Salaudeen Rajack on January 29, 2016 Rating: 5

How to Move SharePoint Content Databases to Another Drive?

January 29, 2016    , , , , , ,
Requirement: Move SharePoint content database from one drive to another in SQL Server! By default, SharePoint creates its databases in the default SQL Server location: "C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA" folder (SQL Server 2016). We don't have any…

How to Move SharePoint Content Databases to Another Drive? How to Move SharePoint Content Databases to Another Drive? Reviewed by Unknown on January 29, 2016 Rating: 5

Replace "Edit" Permissions with "Contribute" in SharePoint 2016 using PowerShell

January 22, 2016    , , , ,
Problem: Prior to SharePoint 2013, Members group of the site has "Contribute" permission. From SharePoint 2013, there was a new permission level "Edit" introduced with more rights. This introduced additional issue like members can delete lists and libraries! Solution: Remo…

Replace "Edit" Permissions with "Contribute" in SharePoint 2016 using PowerShell Replace "Edit" Permissions with "Contribute" in SharePoint 2016 using PowerShell Reviewed by Salaudeen Rajack on January 22, 2016 Rating: 5

SharePoint Online: Remove a Site Column from Content Type using PowerShell

January 20, 2016    , , , , ,
Requirement: Remove a Site Column from Content Type in SharePoint Online. How to Remove a Column from Content Type in SharePoint Online ? When you remove a site column from a content type, It does not delete the column from SharePoint Online. It simply removes the site column's associati…

SharePoint Online: Remove a Site Column from Content Type using PowerShell SharePoint Online: Remove a Site Column from Content Type using PowerShell Reviewed by Salaudeen Rajack on January 20, 2016 Rating: 5

SharePoint Online: Remove a Field from List Content Type using PowerShell

January 20, 2016    , , ,
Requirement: Remove a field from SharePoint list content type in SharePoint Online. PowerShell to Remove a Column from List Content Type in SharePoint Online: #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\ISAPI\Mi…

SharePoint Online: Remove a Field from List Content Type using PowerShell SharePoint Online: Remove a Field from List Content Type using PowerShell Reviewed by Salaudeen Rajack on January 20, 2016 Rating: 5

Fix "MissingAssembly" Errors of Test-SPContentDatabase in SharePoint 2013 Migration

January 19, 2016    , , , , , , ,
Problem: During SharePoint 2013 migration, we ran Test-SPContentDatabase cmdlet and the output report contains several MissingAssembly errors! Category        : MissingAssembly Error           : True UpgradeBlocking : False Message         : Assembly [DealEventEventhandler, Version=1.2.6.0, Cu…

Fix "MissingAssembly" Errors of Test-SPContentDatabase in SharePoint 2013 Migration Fix "MissingAssembly" Errors of Test-SPContentDatabase in SharePoint 2013 Migration Reviewed by Salaudeen Rajack on January 19, 2016 Rating: 5

Remove a Web Part from All Pages in SharePoint Site Collection using PowerShell

January 18, 2016    , , , , ,
Requirement: After the SharePoint migration from SharePoint 2013 to SharePoint 2016, decided to remove a broken web part from all pages wherever its being used. How to Remove a Web Part from Page in SharePoint? To remove a web part from page, you can edit the page and simply delete the web pa…

Remove a Web Part from All Pages in SharePoint Site Collection using PowerShell Remove a Web Part from All Pages in SharePoint Site Collection using PowerShell Reviewed by Salaudeen Rajack on January 18, 2016 Rating: 5

SharePoint Online: How to Add a Site Column to Content Type using Powershell?

January 18, 2016    , , , , ,
Requirement:  Add a site column to content type in SharePoint Online using PowerShell. How to add field to existing content type in SharePoint? By default Title column gets added to the content type. However, you may want to add additional columns.   Go to the SharePoint Online site where yo…

SharePoint Online: How to Add a Site Column to Content Type using Powershell? SharePoint Online: How to Add a Site Column to Content Type using Powershell? Reviewed by Salaudeen Rajack on January 18, 2016 Rating: 5

Test-SPContentDatabase: Fix MissingWebPart Issue in SharePoint 2013 Migration

January 17, 2016    , , , ,
Problem: MissingWebPart Issues when running Test-SPContentDatabase cmdlet on SharePoint content database during SharePoint 2013 migration project. Category                : MissingWebPart Error                      : True UpgradeBlocking  : False Message                : WebPart class [9a43cf43-…

Test-SPContentDatabase: Fix MissingWebPart Issue in SharePoint 2013 Migration Test-SPContentDatabase: Fix MissingWebPart Issue in SharePoint 2013 Migration Reviewed by Salaudeen Rajack on January 17, 2016 Rating: 5

Fix MissingSetupFile Error of Test-SPContentDatabase in SharePoint Migration

January 17, 2016    , , , ,
Problem: Getting "MissingSetupFile" errors when you run the "Test-SPContentDataBase" cmdlet on SharePoint content databases during a migration process. [MissingSetupFile] File [Features\Feature-folder\feature-artifact] is referenced [1] times in the database [SharePoint_Cont…

Fix MissingSetupFile Error of Test-SPContentDatabase in SharePoint Migration Fix MissingSetupFile Error of Test-SPContentDatabase in SharePoint Migration Reviewed by Salaudeen Rajack on January 17, 2016 Rating: 5

SharePoint Online: Enable Content Types using PowerShell

January 16, 2016    , , , ,
As the name suggests, Content type defines type of the content such as item or document. In a real world scenario, A content type could refer to a invoice template or project plan document, etc. Content types provide a effective method of grouping relevant columns (metadata), document template, w…

SharePoint Online: Enable Content Types using PowerShell SharePoint Online: Enable Content Types using PowerShell Reviewed by Salaudeen Rajack on January 16, 2016 Rating: 5

Test-SPContentDatabase: Cannot open database [Database Name] requested by the login. The login failed.

January 16, 2016    , ,
Problem:  In a SharePoint 2013 to SharePoint 2016 migration, Got this error message on testing the content database with Test-SPContentDatabase cmdlet  to identify possible issues: "Cannot open database [Database Name] requested by the login. The login failed" Troubleshooting: If…

Test-SPContentDatabase: Cannot open database [Database Name] requested by the login. The login failed. Test-SPContentDatabase: Cannot open database [Database Name] requested by the login. The login failed. Reviewed by Salaudeen Rajack on January 16, 2016 Rating: 5

SharePoint Online: How to Hide a Column in Content Type using PowerShell

January 15, 2016    , , , , , ,
Requirement: Hide a Column from Content Type in SharePoint Online. How to Hide a Column using Content types in SharePoint Online? Columns can be hidden at both content type level or list level in SharePoint. You can hide a column from appearing in list forms, such as: NewForm.aspx, EditForm.a…

SharePoint Online: How to Hide a Column in Content Type using PowerShell SharePoint Online: How to Hide a Column in Content Type using PowerShell Reviewed by Salaudeen Rajack on January 15, 2016 Rating: 5
Power Query to Extract SharePoint List Data using Excel Power Query to Extract SharePoint List Data using Excel Reviewed by Salaudeen Rajack on January 12, 2016 Rating: 5
Find the Last Login Time of a SharePoint User from AD with PowerShell Find the Last Login Time of a SharePoint User from AD with PowerShell Reviewed by Salaudeen Rajack on January 11, 2016 Rating: 5

Get All Web Applications in SharePoint using PowerShell

January 11, 2016    , , , , , , ,
Web Applications are the top level containers in SharePoint. Each Web Application we create in SharePoint central administration is associated with site in IIS. How to get all web applications in SharePoint farm? To get a List of all available web applications in SharePoint, Navigate to: Sha…

Get All Web Applications in SharePoint using PowerShell Get All Web Applications in SharePoint using PowerShell Reviewed by Salaudeen Rajack on January 11, 2016 Rating: 5

Current Number of Site Collections is 0 in SharePoint After Database Attachment

January 11, 2016    , , , ,
Problem: During a production SharePoint site cloning into UAT using Database attachment method, after attaching the content database to the web application in UAT environment, found the current current number of site collections is 0 (zero). All site collections missing! Tried "View All Sit…

Current Number of Site Collections is 0 in SharePoint After Database Attachment Current Number of Site Collections is 0 in SharePoint After Database Attachment Reviewed by Salaudeen Rajack on January 11, 2016 Rating: 5

Find All InfoPath List Forms in SharePoint using PowerShell

January 10, 2016    , , , , , , , , ,
Requirement: Find all customized InfoPath list forms in SharePoint. Tasked to report a listing all the InfoPath List forms customized in SharePoint web application during a migration project. PowerShell Script to Find All InfoPath List Forms in SharePoint Add-PSSnapin Microsoft.SharePoint.Pow…

Find All InfoPath List Forms in SharePoint using PowerShell Find All InfoPath List Forms in SharePoint using PowerShell Reviewed by Salaudeen Rajack on January 10, 2016 Rating: 5
SharePoint Online: How to Import Term Set from CSV File? SharePoint Online: How to Import Term Set from CSV File? Reviewed by Salaudeen Rajack on January 07, 2016 Rating: 5

SharePoint Online: Remove User from Group using PowerShell

January 06, 2016    , , , , , ,
Requirement: Remove User from Group in SharePoint Online using PowerShell SharePoint Online - How to Remove a User from Group? Removing users from SharePoint Online security groups can be done in just few clicks.  Follow these steps to delete users from a SharePoint Online group: Navigate t…

SharePoint Online: Remove User from Group using PowerShell SharePoint Online: Remove User from Group using PowerShell Reviewed by Salaudeen Rajack on January 06, 2016 Rating: 5

PowerShell to Add Entry in Web.config AppSettings

January 06, 2016    , , , , ,
SharePoint Web applications (or any web site built on ASP.NET) uses Web.config file to store and retrieve web site configurations such as database connection strings, security, etc. web.config file is actually a XML file with .config extension, typically located at the root of your web applicatio…

PowerShell to Add Entry in Web.config AppSettings PowerShell to Add Entry in Web.config AppSettings Reviewed by Salaudeen Rajack on January 06, 2016 Rating: 5

How to Move All SharePoint Databases to a New SQL Server?

January 04, 2016    , , , , , , ,
Requirement: Move SharePoint databases to new SQL Server! You'll have to move SharePoint databases including all content databases, configuration databases and service application databases to an another SQL Server at least in a couple of circumstances: Upgrading SQL Server to new version.…

How to Move All SharePoint Databases to a New SQL Server? How to Move All SharePoint Databases to a New SQL Server? Reviewed by Salaudeen Rajack on January 04, 2016 Rating: 5
Powered by Blogger.