Friday 9 December 2016

Get list of Master Pages in Current Farm or in selected Site/Site Collection

Today I am providing the Power Shell Script that is useful to find out all the used master pages(custom/outofbox) in complete (selected site/farm) as per user input.

Inputs
Path - Enter the file name with path to save the report (Enter file name with csv extension)
Other inputs - Script will ask different input on the basis of user choice. Please follow the instructions

Outputs
A CSV file will be generated with the URL of sites and the master pages used in the site.

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 be Site collection administrator 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. You can run this script in PowerShell as well after adding SharePoint snapin (Add-pssnapin *.sharepoint.*).
Follow on screen instructions.

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

Thursday 8 December 2016

Generate deployed solutions lists in the farm (OOB and custom)

Today I am providing the Power Shell Script that will find out a given solution in a given hive in the farm.

Inputs
Path - Provide log file path to save the solution report.
Installation Hive - Enter the hive (14/15) to get the solutions installed for that hive, you can enter * for getting list of all solutions in all hives
Solution name - Enter the Solution 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 solution which contains bp in its name or provide * to get the list of all solutions

Outputs
A CSV file will be generated with the name of solutions and their installed hives with solution ID.

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.
Follow on screen instructions.

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

Wednesday 16 November 2016

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.

Sunday 6 November 2016

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.

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.

Saturday 5 November 2016

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.


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.


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.
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.
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.


Go to above link to get the script.

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.


Go to above link to get the script.
Csv template link –




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.



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.
Go to above link to get the script.