SharePoint Diary

SharePoint Managed Paths Explained

November 26, 2012 Managed Path, Reference, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016

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

SharePoint Managed Paths Explained

Reviewed by Salaudeen Rajack on November 26, 2012 Rating: 5

Export SharePoint Survey Results to Excel

November 24, 2012 CSV, SharePoint, SharePoint 2010, Survey

Requirement: is to consolidate and analyze a SharePoint survey results by exporting the data to Excel Spreadsheet. Solution: Go to the survey overview page, Export SharePoint survey results to excel by clicking Actions >> Export to Spreadsheet SharePoint 2010 Survey Export to Spreadsheet missing? Received end-user support tickets with the complaint: SharePoint 2010 survey export to spreadsheet is missing! Export to Excel functionality in SharePoint surveys is available under the Overview view only! not on any other views like Show all Responses (Allitems.aspx) or Graphical Summary view!! so make sure you are on "Overview" page to export SharePoint survey data to spreadsheet. Export to excel menu is missing in SharePoint survey overview view also? There could be some other factors: We must have Office Application installed on our client machine. Make sure "Client Integration" is enabled for the the web application. Go to Central Administratio

Export SharePoint Survey Results to Excel

Reviewed by Salaudeen Rajack on November 24, 2012 Rating: 5

SharePoint SQL Server Database Went Offline Mode - How to Bring it back to Online?

November 22, 2012 SharePoint, SQL Server, Troubleshooting

Suddenly SharePoint Database Went Offline. Analyzed Event Logs and found Database went offline because: Backup failure. SQL Server How to Bring Database Online? Alright, How to Bring it back to Online? one line T-SQL! ALTER DATABASE STS_G1WSS01_1385353007 SET ONLINE Database is up and we are back to business!

SharePoint SQL Server Database Went Offline Mode - How to Bring it back to Online?

Reviewed by Salaudeen Rajack on November 22, 2012 Rating: 5

SharePoint 2010 Keyboard Shortcuts

November 20, 2012 SharePoint, SharePoint 2010, Shortcuts, Tips and Tricks

Did you know we can use keyboard shortcuts in SharePoint 2010? Yes, As part of Accessibility standards, SharePoint 2010 offers keyboard shortcuts. How to use these shortcuts? use ALT + [key] and then ENTER (To do click action!) Here’s the list of useful keyboard shortcuts: [Key] can be: S – Go to the search box W – Login drop-down, Shared Documents - Press once again to switch between these items. X – Skip to main content (hidden) Y – Skip Ribbon Commands / – Site Actions Menu 1 – Home 6 – Help 3 – View All Site Content These shortcut keys are real Timer savers! and my favorite pick is: ALT+3, ENTER to get "View All Site Content" There are lot of other shortcuts, you can use in: Calendar View, Standard toolbar, formatting toolbar, Web Part Page, Web Part Maintenance Page, etc. Find More Shortcuts here: http://office.microsoft.com/en-us/sharepoint-server-help/keyboard-shortcuts-HA010369395.aspx

SharePoint 2010 Keyboard Shortcuts

Reviewed by Salaudeen Rajack on November 20, 2012 Rating: 5

Closed Web Parts in SharePoint - How to Find, Restore and Delete

November 19, 2012 Best Practices, CSV, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016, Web Parts

Closed Web Parts? What are they? When users don't need a particular web part on the page, they click on Edit drop down from Web Part Menu, and choose "Close" instead of Delete. They prefer Close rather Delete which is obvious! Technically, When you close a Web Part, It doesn't appears on the screen. But still running on the background and eating up the resources. Its a best practice to delete the closed web parts. Because, closed Web parts takes up the memory and could cause impact on performance. How to Find closed web parts from SharePoint Interface How to find closed Web Parts? Open the Web Part page in Web Part Maintenance Mode (Just append ?contents=1 at the end in address bar). E.g. http://SharePoint.com/sites/sales/default.aspx?contents=1 and look for "No" value under Open on Page? column. How to Delete Closed Web Parts using SharePoint Interface From the Web Part Maintenance Mode, choose the web parts which are in closed mode (Open

Closed Web Parts in SharePoint - How to Find, Restore and Delete

Reviewed by Salaudeen Rajack on November 19, 2012 Rating: 5

Hidden Screen Capture Utility in Windows 7

November 16, 2012 SharePoint, Utilities

Windows 7 comes with an In-Built Screen recorder: Problem Steps Recorder to record screen with series of screenshots and text. Its greatly helpful when we want to reproduce end-users issues and troubleshoot. How to open : Problem Steps Recorder? Go to Run >> Type "PSR" It launches the nifty utility. With this tool, we can record screen by clicking on "Start Record", add comments in middle, pause and then resume recording. Once done, on clicking "Stop Record", it creates a ZIP file with .MHT file with all steps.

Hidden Screen Capture Utility in Windows 7

Reviewed by Salaudeen Rajack on November 16, 2012 Rating: 5

Drive Space Monitoring using PowerShell Script

November 14, 2012 Admin Reports, Administration, Alerts, Monitoring, SharePoint, SharePoint 2010

In SharePoint servers monitoring disk space is a common administrator task. Because, SharePoint servers may run out of disk space from SharePoint, IIS Logs, SQL Server transaction logs or even from SharePoint content (If you don't have Quotas enabled!) There are lot of first-party, third-party utilities available, such as SCOM to Monitor disk space. What if you don't have such tools in your environment? no worries, Just PowerShell can do the monitoring of disk space! PowerShell disk space monitoring can be a cost saver too! Schedule this PowerShell script in windows task scheduler("powershell.exe D:\scripts\DriveSpaceMonitor.ps1" . Make sure PowerShell is in your "Path" environment variable!) on hourly basis. Script will run every hour and mail only when the drive's free space goes below the provided threshold value. PowerShell Script for disk space monitoring: #Purpose: Script to check the drive space in the server against the threshold value

Drive Space Monitoring using PowerShell Script

Reviewed by Salaudeen Rajack on November 14, 2012 Rating: 5

Stop and Start SharePoint 2010 Services

November 13, 2012 SharePoint, SharePoint 2010, Utilities

In my Laptop with Windows 7, I've SharePoint 2010 Installed for my tryouts. I use it whenever I'm out of network connectivity. Problem is: Not quite frequently I use SharePoint from my laptop, but SharePoint services starts automatically when I turn-on my laptop and eating up my resources especially RAM.(SharePoint is resource hungry! Huh) What I want is: Stop all SharePoint services and start only whenever I require them. I used run a batch file (or we can go to Services console) to stop SharePoint, SQL Server and IIS Services. Here is my batch file. @echo stopping SharePoint 2010 services REM SharePoint 2010 Administration net stop SPAdminV4 REM SharePoint 2010 Timer net stop SPTimerV4 REM SharePoint 2010 Tracing net stop SPTraceV4 REM SharePoint 2010 VSS Writer net stop SPWriterV4 REM SharePoint Server Search 14 net stop OSearch14 REM SharePoint Foundation Search V4 net stop SPSearch4 REM SharePoint 2010 User Code Host net stop SPUserCodeV4 REM IIS iisreset /st

Stop and Start SharePoint 2010 Services

Reviewed by Salaudeen Rajack on November 13, 2012 Rating: 5

Delete All Items from List or Library using PowerShell

November 12, 2012 CAML, Object Model, PowerShell, SharePoint, SharePoint 2007, SharePoint 2010, SharePoint 2013, SharePoint 2016

At times, we may have to delete all items from SharePoint list or library. We can get it done by going to "Manage Content and Structure" option as in my another article How to Remove All responses from SharePoint Survey There may be situations, where we've to delete all items from SharePoint list programmatically. Here are the code snippets to achieve the same. Delete All Items from SharePoint List or Library using PowerShell: Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue $WebURL = "http://portal.crescent.com/credit/" $ListName="WorkflowHistory" #Get web List and List Items $Web = Get-SPWeb $WebURL $List = $Web.Lists[$ListName] $ListItems = $List.items Write-host "Total Items in the List:"$List.ItemCount #Iterate through each Item in the list foreach ($Item in $ListItems) { $List.GetItemByID($Item.id).Delete() Write-host "Deleted Item: $($item.id)" -foregroundcolor Red } Traditional W

Delete All Items from List or Library using PowerShell

Reviewed by Salaudeen Rajack on November 12, 2012 Rating: 5

How to Create SQL Server Alias for SharePoint?

November 12, 2012 Best Practices, SharePoint, SharePoint 2010, SharePoint 2013, SharePoint 2016, SQL Server

In My SQL Server best practices for SharePoint 2010 , I wrote a point on SQL Server Alias. Let me elaborate that by going little deep on configuring SQL alias for SharePoint. Why We need SQL Alias for SharePoint? When installing SharePoint, you'll be prompted to enter the SQL Server instance and that's stored in farm's configuration. Creating SQL Alias for SharePoint enables you to change the Database Server of your SharePoint Farm! This will be a great help during disaster recovery, virtualization or migrations. SharePoint SQL alias is a best practice! Its difficult to move SharePoint to a different SQL Server, If you don't use SQL Alias. When disaster strikes, just change SQL Server alias that SharePoint references. Where to Setup SQL Alias? SQL Alias to be set on All SharePoint Servers except DB Server (SQL Server!) CliConfig.exe located at C:\windows\system32\cliconfg.exe in Windows 2003. For Windows 2008 and 2012, (or in 64 bit OS), its located at C:\wi

How to Create SQL Server Alias for SharePoint?

Reviewed by Unknown on November 12, 2012 Rating: 5

Move Site Collection to a Different Managed Path

November 09, 2012 Managed Path, SharePoint, SharePoint 2013, SharePoint 2016, Site Collection

Created a Site Collection under wrong Managed Path? Now want to move the site collection to another managed path? Unfortunately there is no way, other than: Backup your source site collection Delete the source site collection Restore the site collection with the desired target URL! There is no other way to change managed path for SharePoint site collection. These steps also applies If you want to rename Site collection URL. This can be done with either STSADM or with PowerShell. For detailed step by step instructions see my post: How to Change Site Collection URL .

Move Site Collection to a Different Managed Path

Reviewed by Unknown on November 09, 2012 Rating: 5