Changing the Style in a view of List/Library using powershell

Today I am providing the Power Shell Script that give the report of the style applied on a view and will update the view style as per user choice. To know the details of styles available in view visit this link http://splimitationsbyabhi.blogspot.in/2016/11/view-style-in-sharepoint-listlibrary.html

This script can also be used to update the view style to default using script. 

Inputs

Site collection URl - Where you want to change the style or report will be generated for this site collection only.

List name - Where this change will be applied or report will be generated for the selected list. (Name is case sensitive) (Use Wild card (*) if you want to match a particular string in name like we can use *bp* and you get list of all List that have bp in their names), Alternatively you can use * as input to get the list of all list and library.

View name - Where this change will be applied or report will be generated for the selected View. (Name is case sensitive) (Use Wild card (*) if you want to match a particular string in name like we can use *bp* and you get list of all List that have bp in their names), Alternatively you can use * as input to get the list of all list and library.

Path - Report file path with file name and extension as .csv

Option - Enter R for getting the report of View Style and U for updating the View Style

Styleid - Style Id to be applied if you want to update the Style (Enter d for default) visit http://splimitationsbyabhi.blogspot.in/2016/11/view-style-in-sharepoint-listlibrary.html for style id.

Outputs

A report with applied style will be generated and if user want this script will update the Style in the views.

Example-

.\scriptname.ps1

.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

User should have Site Collection Admin rights for executing this script.

User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ASjVOQXJfNWhFQW8/view?usp=sharing  

Export list of all Web applications, Site Collections and their sub sites and their List/library and their columns in a sharepoint farm

Today I am Providing the Power Shell Script that will create a csv file that contain the list of all Web applications, Site Collections and their sub sites and their List/library and their columns in current SharePoint farm where the script will be executed.

Script will accept the reports file path where it will generate the csv files with following names -

Inputs - Following are the Input for the script.
Report File Path - Path for saving the files.
Report Type - Select for the types of the reports.
W for Web Applications
SC for Site Collections
SS for Sub Sites
L for Lists
C for Columns
I for Items
A for All Reports

Outputs - Following output files will be generated on provided Report File Path and Report Type.

Webapplications.csv - List of all Web applications
Sitecollection.csv - List of All site collections of all the Web Applications
Subsites.csv - List of All Sub Sites of All Site Collections of all the Web Applications
Lists.csv - List of All lists of All Sub Sites of All Site Collections of all the Web Applications 
Columns.csv - List of all Columns of All lists of All Sub Sites of All Site Collections of all the Web Applications

List of items will be crated with the name of the their respective list/library in their respective folder according to their respective site URL in the given path.

Dependencies -
For executing this script user must be added in site collection administrators in all the sites.
User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ASUJDNzFaM2xtTDA/view?usp=sharing

Go to above link to get the script.

Download all files of the Sharepoint farm

Today I am providing the Power Shell Script that will download all the documents of all the Libraries under each sites/site collections/web application in to your file system. It is useful if you want to take backup of SharePoint in current SharePoint farm where the script will be executed. Folder structure will be the same as in SharePoint and Site url will be converted as folder to identify the sites.

Script will accept the reports file path where it will create the folder and download the files there -

Inputs - Following are the Input for the script.
Report File Path - Path for saving the files.


Outputs - 
Following output files will be generated on provided Report File Path, with their respective name and under the folder structure of the site.

Dependencies -
For executing this script user must be added in site collection administrators in all the sites.
User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ARjRGXzZfWHBYdDA/view?usp=sharing

Go to above link to get the script.

Download Content using filter on a given Column

Today I am providing the Power Shell Script that will download all the Documents of the given Library of given Site on the bases of filter on a given Metadata column. It is useful if you want to take backup of documents of SharePoint on the bases of some filter of Taxonomy column. Folder structure will be the same as in SharePoint and Site url will be converted as folder to identify the sites.

Script will accept the reports file path where it will create the folder and download the files there -

Inputs - Following are the Input for the script.
Web site - Url of the site where library exists
Library title - Title of the library that you want to download
File path - Path the files where script will download all the files.
Column - Internal name of the column where you want filter
Value - Value to be filtered

Outputs - 

Items of of the list will be downloaded under the name of the list folder

Dependencies -
For executing this script user must be added in site collection administrators in all the sites.
User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.


FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.https://drive.google.com/file/d/0BznVpoE_ln0ASGtLRlRWd1RWS1E/view?usp=sharing

Go to above link to get the script.

List of users and groups in a given site

Today I am providing the Power Shell Script that will display a list of all Security Group and Users and also can generate a txt file for the same

Inputs - 
Site URL - Url of the site for which you need the user and group list.

Outputs –
This script will display the list of all the groups and their users in the given site.

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies -
For executing this script user must be added in site collection administrators in all the sites.
User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.


FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AY0pqYlB2aFBXRlE/view?usp=sharing

Go to above link to get the script.

List of users and groups in a complete Farm

Today I am providing the Power Shell Script that will display a list of all Security Group and Users in the local Farm and also can generate a txt file for the same

Inputs - No Input

Outputs –This script will display the list of all the groups and their users in the Local Farm.

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies -
For executing this script user must be added in site collection administrators in all the sites.
User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.


FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AOEI0WENhTVVpQnM/view?usp=sharing

Go to above link to get the script.

Enable/Disable Save Site as Template

Today I am providing the Power Shell Script that will enable or disable Save site as template option on the given Site.

Inputs
Site URL - Url of the site that where you want to perform task
Option - Provide E for enable and D for disable the Save site as template.

Outputs
Save site as template on the given site will be enabled or disabled on the bases of given inputs.

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies -
For executing this script user must be added in site collection administrators given site.

User should have Shell Admin rights to run the scripts.

Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AcG1IcVJWMVlDVlk/view?usp=sharing

Go to above link to get the script.

Enable/Disable Delete and Save List/Library as template option

Today I am providing the Power Shell Script that will enable or disable Delete and Save list/library as template on the given List/Library.

Inputs
Site URL - Url of the site that where you want to perform task
List - Where you want to perform the operation.
Option - Provide E for enable and D for disable the Save site as template.

Outputs
Delete and Save list/library as template on the given List/Library will be enabled or disabled on the bases of given inputs.

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies -
For executing this script user must be added in site collection administrators given site.

User should have Shell Admin rights to run the scripts.

Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AODZ0RVJiNkxGY3M/view?usp=sharing
Go to above link to get the script.

 Used when Delete option or Save List as template or Save Library as Template is not visible in a List or Library.

Create List/Library

Today I am providing the Power Shell Script that will create a new list/library on the bases of given custom template on the given site/subsite.

Inputs
Site URl - Url Where You want to create list
Title - Name of the List
Description - Description of the List
List Template - Template that will be used for creating the list

Outputs
This script will create a new list/library on the bases of given template and given url.

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies -
For executing this script user must be added in site collection administrators given site.

User should have Shell Admin rights to run the scripts.

Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ANWU2dG9saUl0SkU/view?usp=sharing
Go to above link to get the script.
This script can be used when a template is uploaded in the site and is hidden from Add new list page.

Set Lock State in a Site Collection

Today I am providing the Power Shell Script that will fire the lock state selected during execution on the given site collection.

Inputs
Site Collection - Url Where you want to apply the Lock State.
Lock State - The state that you want to set for the above url.

Outputs
This script will fire the lock state selected during execution on the given site collection.

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies -
For executing this script user must be added in site collection administrators given site.

User should have Shell Admin rights to run the scripts.

Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AX29KUzlnM19HUDA/view?usp=sharing

Go to above link to get the script.

This Script is useful if the Site Collection has gone in read only mode because of any reason such as an interrupted backup process.

Download All solutions (wsp files) in Sharepoint

Today I am providing the Power Shell Script that will download all solutions (wsp file) in Local SharePoint Farm in the given folder and Also save their status in a txt file.

Inputs
Path - The path where you want to save all the custom solutions.

Outputs
This script will download all solutions (wsp file) in Local SharePoint Farm in the given folder.

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies -
For executing this script user must be added in site collection administrators given site.

User should have Shell Admin rights to run the scripts.

Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ARzRfZTM5MWhXZG8/view?usp=sharing

Go to above link to get the script.

Clear Cache of all severs in one go

Today I am providing the Power Shell Script that will clear the cache configuration from all SharePoint servers in one go.

You have to provide all server names of the farm in the script. Provide individual server names inside double coutos ("), and separated by coma as shown in the script itself and Modify the script and provide the Server names. For getting GUID for configuration go to following path in registry editor of any one server (app or wfe). Here copy the GUID and provide it as input when asked by the script. "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15\Secure\ConfigDB" for SharePoint 2013 or "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14\Secure\ConfigDB" for Sharepoint 2010

You can also follow this path in any one server (app or wfe) of the farm “C:\ProgramData\Microsoft\SharePoint\Config” and look for a folder which contains XML files and one cache.ini file. And provide this folder path to the script. This GUID is same for all servers in a Farm.

Inputs
Cache GUID - you can get this GUID from "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15\Secure\ConfigDB" for SharePoint 2013 or "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14\Secure\ConfigDB" for Sharepoint 2010

Outputs
This script will clear the cache configuration from all SharePoint servers in one go

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies -
For executing this script user must be added in site collection administrators given site.

User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0Ac0RsUlhBQml0YjA/view?usp=sharing
Go to above link to get the script.

Creating a Site Collection using script

Today I am providing the Power Shell Script that create a Site collection “host named” or normal on the given web application on the given database.

Inputs
Site collection URL : Provide the new site collection URL.
HostHeader Web Application (Optional): Provide the webapplication URL that will host this collection(in case of Hosted Site Collection). This is optional field and can be left blank if you have provided the webapplication URl in the Site collection.
Database Name (Optional): Provide Database name where you want to move above site collection. Database must already exists in web application. This is optional field.
Site name : Provide Site Collection Name
Description (Optional) : Provide Site Collection Description
Site template : Provide Site template that will be used to create the site
Primary Login : Primary user name (Primary Site Collection Administrator)
Site Primary email (Optional) : Primary administrator email if any.
Secondary Login (Optional) : Secondary user name (Secondary Site Collection Administrator)
Secondary email (Optional) : Secondary administrator email if any.

Outputs
This script will Create a new site collection on the given database on the given web application.

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

if you are creating a site collection on specific Database then database must exists in the given webapplication.

if you are creating hosted site collection then you have to follow additional steps from this url. http://hostnamedsc.blogspot.in/2016/05/host-named-site-collection-is-not.html
For executing this script user must be added in site collection administrators given site.

User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator.
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AUmlucVFMbEE2QWM/view?usp=sharing

Go to above link to get the script.

Creating Content Database on a given Web application

Today I am providing the Power Shell Script that create content database for a given web application on the given server.

Inputs
Web Application : Provide the webapplication URL where you want a new database.
Database Name : Provide new Database name.
SQL Server : SQL server where new database will be created.

Outputs
This script will Create new content database for a given webapplication on a given SQL server.

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

SharePoint Farm Admin must have DBCreator rights on the SQL server if you are creating Database on different server other than SharePoint Farm Server.
For executing this script user must be added in site collection administrators given site.

User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator.
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ARU9ZSnVYUUZ3TUk/view?usp=sharing

Go to above link to get the script.

Granting permissions on SharePoint objects

Today I am providing the Power Shell Script that give permissions on Item level to the users or groups that are provided in a csv file. This csv will take the csv file as input. The structure of csv file will contain following columns - WebsiteURL,Libraryinternalname,Itemname,user_group,permissions,type,removeexistingpermission
Here in type you have provide the type of the object - Site, Library, Folder, Item
and In removeexistingpermission you have provide if you want to remove existing permissions in the form of True/False.
Sample file is also provided in the blog. Provide items and their permission individually in the csv.

Update - For the items  or folder that are under some folder structure, provide complete structure like "rootfolder1/subfolder2/subfolder3/item.ext". You can provide multiple user/group names and multiple permissions for the same item in one row separated by a comma. Create csv file using Ms Excel else you have to put "" for providing multiple user names and permissions like "user1,user2","permission1,permission2". All the permissions will be granted to all the users in one row on the given Item. if you want to give different permissions for different users then add them in different rows.

You can provide different sites, different libraries in one go to provide the permissions to their items in one go.

Inputs
This script will take path of csv file as input. Further this csv file will be used as input.

Outputs
This script will give the permission to the users  on the items  

Example-
.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies -
Input CSV file must be ready for the script.

Item names should be provided with extension. For folder names leave extensions.
Permission levels/Groups/Users must be available in sharepoint.
For executing this script user must be added in site collection administrators given site.
User should have Shell Admin rights to run the scripts.

Run Management Shell as an Administrator. 


How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AQzRtb1dVMi1JV00/view?usp=sharing

To see and download csv template file click here.

https://drive.google.com/file/d/0BznVpoE_ln0AdjdkcC1XeWFlT1U/view?usp=sharing

Go to above link to get the script.

Modify the Site url of content type hub in Managed Metadata service application

Today I am providing the Power Shell Script that can be used to modify the Site url for content type hub in managed meta data service application.

We can not modify the url of content type hub using UI once we have defined that in Managed Metadata Service Application. Use below script for doing this.

Inputs

Managed Metadata Service Application - Name of the Managed Metadata Service Application that is using the content type hub.

Site url - URL of the site that will host the content types.

Outputs

This Script will Change the URL of Content type hub in Managed Metadata Service Application.

Example-

.\scriptname.ps1

.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

For executing this script user must be added in site collection administrators in the sites.

User should have Shell Admin rights to run the scripts.

Run Management Shell as an Administrator.

How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ANXdSaVJPQ0xMeVU/view?usp=sharing  

Go to above link to get the script.

Creating Content type hub

Delete Site/site collections in bulk

Today I am providing the Power Shell Script that will delete multiple sites/site collections from the given list. List will be provided in the form of a csv file. The columns in csv file will be siteurl, type. Here in type, Provide s if given url is for sub site or sc for site collection.

.Inputs

Path - Provide csv file with path that will be used as input for this script.

.Outputs

Sites will be deleted as per the list in csv file.

Example-

.\scriptname.ps1

.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

For executing this script user must be added in site collection administrators in the sites.

User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator.
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ATGFjbUxPX2dpS2c/view?usp=sharing  

Go to above link to get the script.

Csv template link –

https://drive.google.com/file/d/0BznVpoE_ln0AenJrNUZSMk85NUk/view?usp=sharing

View Threshold limit issue in List/Library

Today I am providing the Power Shell Script that will disable view threshold limit on a given library of the given site. This script is useful in case your list/library has more document then its view threshold limit and you are not able to see any data in the list and even no view is working as indexing can’t be done after view threshold limit is crossed. Use this script on the list then you will be able to index the columns. This option will be applied on the given list only so you will not need to change view threshold  limit to see the items in the list.

Inputs

Site url - URL of the site where your list/library exists

List name - name of the list/library where you want to disable threshol limit

Outputs

This script will disable view threshold limit on a given library of the given site.

Example-

.\scriptname.ps1

.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

For executing this script user must be added in site collection administrators in the sites.

User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator.
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AVy13TkxpU0JKSjg/view?usp=sharing  

Go to above link to get the script.

Enable Developer Dashboard

Today I am providing the Power Shell Script that will enable Developer Dashboard in your SharePoint 2013 environment.

Inputs

Database name - Database name required if we need to create a new usage application

Usage application name - Usage application name required if we need to create a new usage application

Outputs

This Script will enable Developer Dashboard in local SharePoint 2013 environment.

Example-

.\scriptname.ps1

.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

For executing this script user must be added in site collection administrators in the sites.

User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator.
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AWWNLYUtIUl82ZXc/view?usp=sharing  

Go to above link to get the script.

Reset BLOB Cache

Today I am providing the Power Shell Script that will reset the BLOB Cache of the wfe server. 
Sometimes BLOB cache stop syncing with database due to this reason you will not able to recognize the changes (if any Change is made) in the file that are enabled for blob cache. In that case we have to flush the BLOB Cache. This script is needed to be run on all the wfe servers where ever the web application hosting.

Inputs

Web Application URL - URL of the web application for which you are going to reset the blob cache

Outputs

This script will reset the BLOB cache of the given web application.

Example-

.\scriptname.ps1

.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

For executing this script, User who is going to flush the BLOB cache must have securityadmin and dbowner rights on SQL and database.

User should also be local administrator on the server where this script will be executed.

User should have Shell Admin rights to run the scripts.

Run Management Shell as an Administrator.

How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0AeXEzN2xmZzRCT0k/view?usp=sharing  

Go to above link to get the script.

Properly Install/Uninstall/Update Sharepoint Solution

Today I am providing the Power Shell Script that will install, uninstall or update a SharePoint solution (wsp file) in SharePoint. It will also activate/deactivate the site collection, Web app feature in SharePoint web application/Site collection.

Inputs

Path - Provide log file path to save the logs of the script.
Action - Select option to be performed - 1 for update, 2 for Install or 3 for Uninstall
webapplication url - provide web application url for installing the wsp file and activating the feature.

Outputs

Solution will be installed, uninstalled and updated on the bases of selected option.if you are selecting uninstall or update solution a backup of existing wsp will be taken from SharePoint in log file path.

Example-

.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

Solution and script should be saved in same folder. it will install/uninstall all the solutions.

For activating/deactivating a feature, feature name should contain the name of wsp file in its name.

For executing this script user must be added in site collection administrators in the sites.

User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ARExuYzVKZ2JTLUE/view?usp=sharing   

Go to above link to get the script.

Find a given webpart in the given site collection

Today I am providing the Power Shell Script that is useful to find out a given web part (or all) in all the pages in all over the given site collection.

Inputs

Path - Provide log file path to save the web part report.
Sitecollection url - provide site collection url where the given web part will be searched.
Webpart name - Enter the webpart name, Name is case sensitive (Use wild card (*) if you want to match a particular string in name like you can use *bp* to get the list of all page that contains any webpart which contains bp in its name or provide * to get the list of all webparts

Outputs

A CSV file will be generated with the url of the pages where a given web part is available. or all the web parts available.

Example-

.\scriptname.ps1
.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

For executing this script user must be added in site collection administrators in the sites.
User should have Shell Admin rights to run the scripts.

Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ATzZaNVlZalNJLUk/view?usp=sharing   

Mapping User Profile Property for AD Synchronization

Today I am providing the Power Shell Script that will map the given user profile properties with given AD Synchronization properties. User will have to create a CSV file that will contain User Profile Property names and their respective Connection and Ad property and script will map them all.

Inputs

CSV path - Provide the Path of CSV file where you have save to map the user profile.

Outputs

This script will map user profile properties for Ad synchronization properties, that you have defined in CSV file. Define the mapping multiple times if you want to add mapping multiple times.

Example-

.\scriptname.ps1

.\scriptname.ps1 | out-file “FilePath\Filename.txt”

Dependencies –

Run this script with Farm Account. Farm account is the user who installed SharePoint.

User should have Shell Admin rights to run the scripts.
Run Management Shell as an Administrator. 
How to execute -
Copy this script and paste in Note pad.
Save this file as .ps1.
Run this script in SharePoint Management Shell. You can run this script in PowerShell as well.
Follow on screen instructions.

FOR ANY HELP ON THIS SCRIPT USE "GET-HELP .\SCRIPTNAME.PS1 --FULL" AFTER SAVING THIS FILE.

https://drive.google.com/file/d/0BznVpoE_ln0ANm5rTzlWREcwVEU/view?usp=sharing

CSV file template –

https://drive.google.com/file/d/0BznVpoE_ln0ARjNqdUFKOEg5am8/view?usp=sharing