Site Content and Structure error

Whenever I tried to access my ‘Content and structure’ link in Site Settings under Site Administration, I would get an error and it would fail. After checking the logs, the following helped me to fix this issue:

First, I used the SharePoint Feature Administration and Cleanup Tool from CodePlex and cleaned out any errors. This changed the error in the logs.

There was now a list ID that was giving a problem. To find which list it was, I searched via the list ID in PowerShell:

Get-SPSite http://yourSite | Get-SPWeb  -Limit ALL | %{$_.Lists} | ?{$_.ID –eq “your-list-ID-no-brackets”} | ft Title, ParentWebURL, RootFolder

Then I deleted the list by name:

$web = get-spweb -Identity http://yourSite
$list = $web.lists["Name of Offending Library"]
$list.AllowDeletion = $true

This script lists all of the titles and IDs per site:

$sitec = Read-Host 'Enter Site Collection (ex:'
$subsite = Read-Host 'Enter Sub-Site(ex: departments or ENTER for "root")'
$site = Get-SPSite $sitec
$web = $site.OpenWeb("$subsite")
write-host "Site: " + $
write-host "Web: " + $
$web.lists | Format-Table title,id -AutoSize

After doing this, I was able to open the link without error.

Gmail scripts – Mark Read During Business Hours

I quickly threw this together. The following script would mark all Gmail email coming in to be read if it’s Monday through Friday between the hours of 9am and 5pm. This is done at with the API from

Don’t forget to click on Resources > Current Project’s Triggers and have it run once a minute!

function markReadDuringBusHours() {
    var currentDate = new Date();
    var currentDay = currentDate.getDay();
    var currentHour = currentDate.getHours();
    var threads = GmailApp.getInboxThreads();
    if (currentHour > 8 && currentHour < 18 && currentDay > 0 && currentDay < 6)

“Getting the most out of SharePoint” email

Once a user completes the creation of their My Site, an email will be automatically sent that looks like this:

Get the Most Out of SharePoint

As you can see, you may not want this to be sent out or, at least, have the ability to customize it. Unfortunately, it’s baked into SharePoint so your only options are either to intercept the email via Exchange or to customize files that could be replaced on a service update, patches, whatever.

To customize, read this. Is this how I get the most out of SharePoint?

The file in question is located in: C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\Resources

And to get rid of the Let’s Get Social dialog box, click here.

Add ‘Sign in as Different User’ back to SharePoint 2013 Drop Down

1.  Navigate to the C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\TEMPLATE\CONTROLTEMPLATES\Welcome.ascx file and open it in a text editor

2.  Add the following snippet before this line <SharePoint:MenuItemTemplate runat=”server” id=”ID_RequestAccess”

<SharePoint:MenuItemTemplate runat="server" ID="ID_LoginAsDifferentUser"

3.  Save and reload in browser. You’ll get the “Working on it…” screen before the site loads.

SharePoint 2013 Installation

This is guide for installing SharePoint 2013 Enterprise using a compilation of various posts with the plan built off of Todd Klindt’s basic installation guide.

  1. Confirm Service Accounts. Here’s another suggestion that has more detail
    • Make sp_install a local administrator on all SharePoint servers
  2. Install SQL 2012 SP1
  3. Run Prereq installer to Install Prereqs
  4. Install forgotten prereqs
  5. Install SharePoint 2013
  6. Run “Start-Transcript” in SharePoint 2013 Management Shell so you can track all the commands you are executing
  7. Create Farm
  8. Install any CUs
  9.  Create managed accounts
  10. Create content web app
  11. Create mysite web app. Here’s another resource. And finally TechNet
    • How to get those user photos in there from AD. Make sure to read the comments as well
    • If you set up the User Profile Service now, profile data will have temporary issues until you setup other services.
  12. Create App Management Service. Here’s the TechNet info on Apps. Here’s some important info regarding allowing anonymous access to Apps.
  13. Add SharePoint web apps to Hosts file
  14. Create State Service
  15. Create Usage Service app (see previous link)
  16. Create Managed Metadata Service
  17. Create Search Service
  18. Run a full crawl to verify everything works
  19. Create User Profile Service app if you haven’t already
  20. Create other service applications as needed
  21. Gpupdate /force & reboot
  22. Run all Health Analyzer rules
  23. Don’t forget the Workflow Manager and this for non-SSL:
    • register-SPWorkFlowService -spsite “http://yourSite” -WorkflowHostUri “http://workflowHost:12291″ -AllowOAuthHttp
    • And don’t forget to run Workflow Manager on every server in your farm.
  24. Create the Business Data Connectivity Service Application. Make sure you’re running the “Business Data Connectivity Service” in Services on Server before you create the Service Application.
  25. Install PerformancePoint 
  26. Report Server. No content-types?

Update Web Part on a Page Using Powershell in SharePoint 2010

I recently had to update a web part’s zone id that existed on most pages throughout the SharePoint 2010 site. I wrote up this powershell script to address this. DISCLAIMER: Use at your own risk!

  $site = new-object Microsoft.SharePoint.SPSite(“http://your_site”)
  foreach($web in $site.AllWebs)
    #Make sure you specify which page needs changes
    $page = $web.GetFile(“default.aspx”)
    $wpm = $web.GetLimitedWebPartManager($page.Url, [System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
  #$wpm.WebParts | ft
  $wp = $wpm.WebParts | Where-Object { $_.Title -eq “Page Tabs” }
  #$wp.ZoneID | ft
  $wp.ZoneID = “Header”
  $page.CheckIn(“Update via PowerShell”,[Microsoft.SharePoint.SPCheckinType]::MajorCheckIn)
  $wp.ZoneID | ft

I left the commented lines in since they can be helpful as well.