In general, we can delete the columns using UI from SharePoint pretty easily. But some columns are not allowed to be deleted using UI but are allowed to be deleted using PowerShell. But there are some columns which are not deleted from PowerShell as well without some tweaks.
Recently, I encountered a requirement to extract the wsps from SharePoint Content Database and extract its contents. Extraction of WSP is already mentioned in many blogs. So, I would just guide how to extract the WSP contents.
Following is the command which is used to extract the WSP contents and saves its contents to a particular path:
expand <FullPathToWSP> <DirectoryWhereFileNeedsTobeExtracted> -F:*
The above command is a built-in Windows utility which extracts the content of WSP. Following is the example of the above mentioned command.
expand C:\mySolution.wsp C:\SolutionExtract\mySolution -F:*
Change password of a Managed Account in SharePoint
You might found a lot of scripts for doing the same task in SharePoint 2010 Managed Shell. But I would add on to the problem I faced in changing the password after listing the command for the same.
Following is the algorithm to change the password:
- Get the appropriate managed account.
- Get the password and change the password to secure string.
- Set the password.