Find Active Inactive Site Collections in SharePoint

December 31, 2012    , , ,
Some time back, wrote a PowerShell script to find Most active sites(sub-sites) in SharePoint: Find Most Active SharePoint Sites of a Web Application . Now have a similar requirement, but for SharePoint Site collection! Find Active and Inactive SharePoint site collections of a project collaboration environment. How to find Most Active SharePoint Site Collections?  Well, SPSite object has LastContentModifiedDate property, why don't we use it? Here is the nifty PowerShell script to find Most active Site collections based on content modified date. In a reverse, this can be used to find all In-active site collections also. Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue Get-SPWebApplication "https://sharepoint.company.com" | Get-SPSite -Limit All | foreach { Write-Host $_.URL $_.LastContentModifiedDate } This will reveal SharePoint 2010 inactive sites. For SharePoint 2007, you can slightly change the code. BTW, I use PowerGUI IDE for wri
Read More
Find Active Inactive Site Collections in SharePoint Find Active Inactive Site Collections in SharePoint Reviewed by Unknown on December 31, 2012 Rating: 5

Hide Columns in SharePoint List NewForm, EditForm and DispForms

December 31, 2012    , , , , , , , , ,
Had a requirement to hide a specific column "Parent Project" in a SharePoint list "Project Metrics", Since this field was being updated by an internal workflow, it must not be visible in NewForm or in EditForm. So to protect a particular column from edits, decided to hide it from New & Display Forms. Here are the various methods I've used in different scenarios. SharePoint SPField Object has the following properties to control its visibility.     ShowInNewForm - Show in the list settings page     ShowInEditForm - Controls field in edit form page     ShowInDisplayForm - Show in the display form page.     ShowInListSettings - Show in the list settings page     ShowInViewForms - Show field in views field selection     ShowInVersionHistory - Show in the version history view These field properties are self-explaining, isn't it? Lets see various ways to Hide SharePoint List Columns. Enable Content Type and Hide the Field: This will hide the f
Read More
Hide Columns in SharePoint List NewForm, EditForm and DispForms Hide Columns in SharePoint List NewForm, EditForm and DispForms Reviewed by Unknown on December 31, 2012 Rating: 5

Create Send To Connection with PowerShell

December 27, 2012    , ,
In continuation to my post: SharePoint 2010 Configure Send To Connections , If you want to create send to connections programmatically or have multiple send to connections to create, PowerShell can help to automate it: PowerShell Script to Create Send To Connections: #Get the Web Application $WebApp = Get-SPWebApplication "http://sharepoint.crescent.com" $SPOfficialFileHost = New-Object Microsoft.SharePoint.SPOfficialFileHost #Set Send to Options# #Send to Connection Name $SPOfficialFileHost.OfficialFileName = "Project Directory" #Send to Target location $SPOfficialFileHost.OfficialFileUrl = "http://sharepoint.crescent.com/teams/PMO/ProjectDir/_vti_bin/officialfile.asmx" $SPOfficialFileHost.ShowOnSendToMenu = $true #Send to Operation $SPOfficialFileHost.Action=[Microsoft.SharePoint.SPOfficialFileAction]::Copy $SPOfficialFileHost.Explanation = "Send to connection for Project submission" $WebApp.OfficialFileHosts.Add($SPOfficialFileHost); $W
Read More
Create Send To Connection with PowerShell Create Send To Connection with PowerShell Reviewed by Salaudeen Rajack on December 27, 2012 Rating: 5

SharePoint 2010 Configure Send To Connections

December 26, 2012    , ,
In my organization, Program Managers group from multiple departments wanted to collect documents from their department sites to a centralized location for brainstorming. Somehow they heard about/located send to connections in SharePoint! What is Send to connections in SharePoint? Send to connections in SharePoint is a great and flexible way to manage documents. Users can easily Move or Copy document to a new location. Documents can be sent across sites, site collections and even web application. Its often used with records center, But we can enable "Content Organizer" feature to activate Custom Send To connections on any site. Lets see how to configure Send To connections in SharePoint 2010. Steps to Create New Send to Connection: Activate Content Organizer in Target site where you want your documents to be collected. Create a Custom Send To connection in Central Administration Copy/Move documents by clicking "Send To >> Send to Location" Step 1
Read More
SharePoint 2010 Configure Send To Connections SharePoint 2010 Configure Send To Connections Reviewed by Unknown on December 26, 2012 Rating: 5

Update a Column Value for All List Items in SharePoint using PowerShell

December 26, 2012    , , , , , ,
Requirement is to update a list item in SharePoint using PowerShell. Here are some code scripts to update SharePoint list item using PowerShell script. PowerShell to update a column value for all List items in SharePoint The syntax for updating a specific column value on SharePoint List item goes like this: $Web = Get-SPWeb "http://sharepoint-site-url" $List = $web.Lists["List Name"] foreach ($item in $list.Items) { $item["ColumnName"] = "New value" $item.Update() } This PowerShell updates all list items in SharePoint. Here is an example for update all items in a SharePoint list with PowerShell: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue #Get the List $Web = Get-SPWeb "http://intranet.crescent.com" $List = $web.Lists["Contacts"] #Get all List Items $ListItems = $List.Items #if the Item Found foreach($Item in $ListItems) { #Update 'Company' Field Value $Item["Com
Read More
Update a Column Value for All List Items in SharePoint using PowerShell Update a Column Value for All List Items in SharePoint using PowerShell Reviewed by Salaudeen Rajack on December 26, 2012 Rating: 5

Copy SharePoint List or Library between Sites with PowerShell

December 26, 2012    , , ,
In a migration project, we had to move few lists and libraries to different site collection. In SharePoint 2010, using granular export, we can export SharePoint lists and libraries from one site to another with SharePoint Central Administration web interface. Once exported we've to use Import-SPSite PowerShell cmdlet to restore the list. Lists can be copied to different SharePoint site as well. Exporting from Central Admin UI and importing it again isn’t that much great time saver, So lets turn our attention to PowerShell to copy SharePoint 2010 list between sites. Here is my PowerShell script to Copy a single List or Library to another SharePoint Site: Export Import a Library using PowerShell: Export-SPWeb "http://your-site-url" -itemurl "/document" -path "c:\documents.cmp" -IncludeVersions All Import-SPWeb "http://your-new-site-url/" -Path "c:\documents.cmp" PowerShell Script to Backup-Restore (Or Export-Import) SharePo
Read More
Copy SharePoint List or Library between Sites with PowerShell Copy SharePoint List or Library between Sites with PowerShell Reviewed by Salaudeen Rajack on December 26, 2012 Rating: 5

Rotating Banner for SharePoint using jQuery

December 12, 2012    , , , ,
With jQuery we can do lot of user interface enhancements in SharePoint. In this article, I'm exploring one of them: Add rotating banner for SharePoint using jQuery, Let our SharePoint site display moving top banner. Lets start building rotating banner for SharePoint! jQuery Rotating Banner for SharePoint - Steps in Brief: Here is how to create rotating banner in SharePoint Download and create necessary files Create the folder structure as explained below Create HTM file for banner Rotator. Update the links to point to your SharePoint site for images and JavaScript files in HTM and CSS. Add a Content Editor web part to the page, specify the banner HTM file. Step 1: Download and create necessary Files For SharePoint scrolling banner implementation, we need below files: jquery.min.js - Get it from: https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js jquery.cycle.all.js - http://cdn.jsdelivr.net/cycle/2.9999.6/jquery.cycle.all.js A CSS file to define style
Read More
Rotating Banner for SharePoint using jQuery Rotating Banner for SharePoint using jQuery Reviewed by Unknown on December 12, 2012 Rating: 5

Set SharePoint Web Application or Farm to Read Only Mode

December 10, 2012    , , , , , , , ,
During maintenance/migrations, its inevitable to set the entire SharePoint Farm or at least Web Applications to read-only mode for some time. SharePoint doesn't provide any direct ways to set the entire web application or Farm to Read-only mode, but we've these options available to set read only access to either SharePoint Web Application or Farm. Using Central Administration user permissions Set read-only mode for all site collections of the web application through PowerShell Set all SharePoint content databases of the web application to read-only mode Option 1: Using Central Administration User Permissions to Make SharePoint web application read only: Go to Central Administration >> Application Management >> Manage web Applications >> and select "User Permissions" Un-check "Select All" and Select Permissions which are starting with "Open, View, Browse". such as: View Items, Open Items, Browse User Information. This
Read More
Set SharePoint Web Application or Farm to Read Only Mode Set SharePoint Web Application or Farm to Read Only Mode Reviewed by Unknown on December 10, 2012 Rating: 5

SharePoint 2010 Search Error: The search request was unable to connect to the Search Service.

December 10, 2012    , , , ,
After configuring SharePoint search service application, Got this error message when I attempt to do a search: "The search request was unable to connect to the Search Service" I verified search settings, crawl logs and found they are fine. After a while nailed the issue: Search Service proxy association. Fix is simple: Go to Central Administration >> Manage Web Applications >> Selected your target web application Click Service Connections from the ribbon. This will list all connections. Found the search service "Search Service Application " and was not connected to our web application! Just ticked the  search service application we configured and we are back to business! Other Reasons: Apart from Search service proxy association, There could be many other reasons for this error message: 1. Make sure you have the search service application created, up and running. If not, create a new search service application. 2. SharePoint Server
Read More
SharePoint 2010 Search Error: The search request was unable to connect to the Search Service. SharePoint 2010 Search Error: The search request was unable to connect to the Search Service. Reviewed by Salaudeen Rajack on December 10, 2012 Rating: 5

Configure Diagnostic Logging in SharePoint 2010 - Best Practices, FAQs

December 09, 2012    , , , , ,
What is Diagnostic Logging in SharePoint, By the way? Simple! Diagnostic logging is where SharePoint logs it's own actions. There are two log file locations where SharePoint Diagnostic logging keeps its logs: Windows Event Log - You can view it with "Event Viewer" - The one comes with Windows! ULS or "Trace Log" - Text based log format that is specific to SharePoint Server and is stored on the file system. The default location is  C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS ULS loges are following the naming convention of  "ServerName-YYYYMMDD-HHMM" and each subsequent file is created in 30 minutes intervals by default. Look at the below screenshot. Where to Configure Diagnostic Logging? Go to Share 2010 Central Administration >> Monitoring >> Click "Configure diagnostic logging" (Under Reporting) From Here you can select the Category,  Least critical event to report to the ev
Read More
Configure Diagnostic Logging in SharePoint 2010 - Best Practices, FAQs Configure Diagnostic Logging in SharePoint 2010 - Best Practices, FAQs Reviewed by Salaudeen Rajack on December 09, 2012 Rating: 5

Create or Delete Managed Path in SharePoint using PowerShell

December 09, 2012    , , , , ,
Managed paths in SharePoint enables us to create a uniform navigational structure to group multiple site collections together. SharePoint Managed Paths can be defined using PowerShell or STSADM command line tool. Managed paths are explained in my another article: Managed path in SharePoint Create Managed Path in SharePoint using PowerShell: Use New-SPManagedPath cmdlet to create a new managed path in a web application on the SharePoint farm. New-SPManagedPath -WebApplication "http://sharepoint.company.com" -RelativeURL "teams" This adds managed path in sharepoint 2013 using PowerShell. By default, the managed path is created as a wildcard inclusion type. You can include the Explicit switch to create a managed path of explicit inclusion type. New-SPManagedPath –WebApplication "http://sharepoint.company.com" –RelativeURL "/departments/" -Explicit PowerShell to Delete Managed path in SharePoint: If you need to delete a managed path fr
Read More
Create or Delete Managed Path in SharePoint using PowerShell Create or Delete Managed Path in SharePoint using PowerShell Reviewed by Salaudeen Rajack on December 09, 2012 Rating: 5

Check Lock Status for All Site Collections in SharePoint

December 02, 2012    , , ,
End user came with a compliant: "I'm receiving 'HTTP 403: The Website declined to Show this webpage' in some sites", in an intranet collaboration environment. Ah! This is because: site is locked with "No Access". How to Check Site Lock Status? You can Navigate to: Central Administration > Application Management > Configure Quotas and Locks to get lock status. Get Lock status with STSADM stsadm -o getsitelock -URL http://sharepoint.crescent.com Retrieve Site lock status with PowerShell: Get-SPSite "http://sharepoint.crescent.com" | Select ReadOnly,Readlocked,WriteLocked But for this case, End-user doesn't remember the URL. There are 5000+ site collections. How do I find which site collection has been locked with "No Access"? We have to retrieve lock status for all site collections. PowerShell comes to rescue again: PowerShell Script to Get Lock status for all Site Collections: Add-pssnapin Microsoft.SharePoi
Read More
Check Lock Status for All Site Collections in SharePoint Check Lock Status for All Site Collections in SharePoint Reviewed by Unknown on December 02, 2012 Rating: 5

SharePoint Managed Paths Explained

November 26, 2012    , , , , ,
Let me document the Frequently Asked Questions on SharePoint Managed Paths during my training sessions: What is Managed Path in SharePoint? A managed path is a location within a web application in which you can have site collections. When you create a web application, there are two managed paths created with it. The first managed path is called the Root "/" path of explicit inclusion type. The second is called "sites" with wildcard inclusion path. SharePoint 2010 My Site host comes with "Personal" Wildcard managed path. Why We need Managed Paths in SharePoint? Managed Paths in SharePoint used to group multiple sites based on some criteria. Also helps to maintain a logical structure in SharePoint. Say, You want to group all Sales department sites, then you can have: http://company/sales/Site1/ , http://company/sales/Site2/, etc. SharePoint managed path examples: Lets take an example. A typical SharePoint URL could be: "http://company.com/ s
Read More
SharePoint Managed Paths Explained SharePoint Managed Paths Explained Reviewed by Salaudeen Rajack on November 26, 2012 Rating: 5
Subscribe to: Posts ( Atom )
Powered by Blogger.