Sharepoint 2010: Upload Multiple Documents button grayed out – This control is currently disabled

Posted on November 18, 2010 by Thomas Maurer

In the last days we had a customer ticket which was escalated because a user in our Hosted Sharepoint 2010 environment had the following problem. He could not upload multiple documents because the button was grayed out and he got the message “This control is currently disabled”.

This is a feature which is a client integration component, which is available on machines with a installed Office 2010 client. So if you have a Windows 7 PC and Office 2010 installed you get the following:

The first time you navigate on the Document Library you get asked about a ActiveX Control Object
You can accept that
Maybe you get asked again
Now you can use the Upload Multiple Documents Button
And choose the Office Files

I found this solution in the technet forums

How to Backup a Sharepoint 2010 Site Collection with Powershell

Posted on November 15, 2010 by Thomas Maurer

Powershell Header Okay for a real backup solution you should use a backup software like Microsoft System Center Data Protection Manager or Symantec Backup Exec. But maybe you have customer which needs a backup of his Sharepoint Site Collection. You also could use the Backup Tool in the Sharepoint Central Administration, but if you need to automate that, you will need Powershell.

Backup a Site Collection:

Backup-SPSite -Identity "http://sharepoint.company.com" -Path "C:\Temp\backup1.bak" -Force

Restore a Site Collection:

Restore-SPSite "http://sharepoint.company.com" -Path C:\backup1.bak -HostHeaderWebApplication "http://WebAppname" -Force -Confirm:$False

Powershell: Create a new Sharepoint 2010 WebApplication and Site collection

Posted on September 13, 2010 by Thomas Maurer

Powershell Header

Microsoft Sharepoint 2010 is one of the new products which supports Windows Powershell commands. Its really easy to do the most tasks you do normally in the Sharepoint Central Administration with Powershell.

Microsoft created a Powershell Snapin for Sharepoint 2010, which is called “Microsoft.Sharepoint.Powershell”. This enables a lot of new Powershell cmdlets for Sharepoint.

With this small scripts you can simply create a new WebApplication and/or a new Sharepoint Site Collection.

Add the Sharepoint cmdlets:

Add-PsSnapin Microsoft.SharePoint.PowerShell

Help for creating a new Sharepoint WebApplication:

The Powershell command for creating a new Web Application is New-SPWebApplication.

Get-Help New-SPWebApplication
NAME
    New-SPWebApplication

SYNOPSIS
    Creates a new Web application within the local farm.

SYNTAX
    New-SPWebApplication -ApplicationPool <String> -Name <String> [-AdditionalClaimProvider <SPClaimProviderPipeBind[]>
    ] [-AllowAnonymousAccess <SwitchParameter>] [-ApplicationPoolAccount <SPProcessAccountPipeBind>] [-AssignmentCollec
    tion <SPAssignmentCollection>] [-AuthenticationMethod <String>] [-AuthenticationProvider <SPAuthenticationProviderP
    ipeBind[]>] [-Confirm [<SwitchParameter>]] [-DatabaseCredentials <PSCredential>] [-DatabaseName <String>] [-Databas
    eServer <String>] [-HostHeader <String>] [-Path <String>] [-Port <UInt32>] [-SecureSocketsLayer <SwitchParameter>]
    [-ServiceApplicationProxyGroup <SPServiceApplicationProxyGroupPipeBind>] [-SignInRedirectProvider <SPTrustedIdentit
    yTokenIssuerPipeBind>] [-SignInRedirectURL <String>] [-Url <String>] [-WhatIf [<SwitchParameter>]] [<CommonParamete
    rs>]

DESCRIPTION
    Creates a new Web application specified by the Name parameter. The user specified by the DatabaseCredentials parame
    ter must be a member of the dbcreator fixed server role on the database server.

    For permissions and the most current information about Windows PowerShell for SharePoint Products, see the online d
    ocumentation (http://go.microsoft.com/fwlink/?LinkId=163185).

RELATED LINKS
    Get-SPWebApplication
    Set-SPWebApplication
    Get-SPWebApplication

REMARKS
    To see the examples, type: "get-help New-SPWebApplication -examples".
    For more information, type: "get-help New-SPWebApplication -detailed".
    For technical information, type: "get-help New-SPWebApplication -full".

Creating a new Sharepoint WebApplication:

# SharePoint cmdlets
Add-PsSnapin Microsoft.SharePoint.PowerShell
# Set variables
$WebAppName = "Contoso Sharepoint1"
$WebAppHostHeader = "sharepoint1.contoso.com"
$WebAppPort = 80
$WebAppAppPool = "SharePoint1AppPool"
# This User has to be a Sharepoint Manager Account
$WebAppAppPoolAccount = "contoso\sp_serviceuser"
$WebAppDatabaseName = "Sharepoint1"
$WebAppDatabaseServer = "SQLServer\InstanceName"

# Create a new Sharepoint WebApplication
New-SPWebApplication -Name $WebAppName -Port $WebAppPort -HostHeader $WebAppHostHeader -URL ("http://" + $WWebAppHostHeader) -ApplicationPool $WebAppAppPool -ApplicationPoolAccount (Get-SPManagedAccount $WebAppAppPoolAccount) -DatabaseName $WebAppDatabaseName -DatabaseServer $WebAppDatabaseServer

Creating a new Sharepoint Site Collection:

# SharePoint cmdlets
Add-PsSnapin Microsoft.SharePoint.PowerShell
# Templates
# Name                 Title                                    LocaleId   Custom
# ----                 -----                                    --------   ------
# GLOBAL#0             Global template                          1033       False
# STS#0                Team Site                                1033       False
# STS#1                Blank Site                               1033       False
# STS#2                Document Workspace                       1033       False
# MPS#0                Basic Meeting Workspace                  1033       False
# MPS#1                Blank Meeting Workspace                  1033       False
# MPS#2                Decision Meeting Workspace               1033       False
# MPS#3                Social Meeting Workspace                 1033       False
# MPS#4                Multipage Meeting Workspace              1033       False
# CENTRALADMIN#0       Central Admin Site                       1033       False
# WIKI#0               Wiki Site                                1033       False
# BLOG#0               Blog                                     1033       False
# SGS#0                Group Work Site                          1033       False
# TENANTADMIN#0        Tenant Admin Site                        1033       False

# Languages
# Name                	Title
# ----                	-----
# German				1031
# English				1033
# French				1036
# Spanish				1034

# Set variables
$SiteCollectionName = "Homepage"
$SiteCollectionURL = "http://sharepoint.contoso.com"
$SiteCollectionTemplate = "STS#0"
$SiteCollectionLanguage = 1033
$SiteCollectionOwner = "contoso\UserName"

# Create a new Sharepoint Site Collection
New-SPSite -URL $SiteCollectionURL -OwnerAlias $SiteCollectionOwner -Language $SiteCollectionLanguage -Template $SiteCollectionTemplate -Name $SiteCollectionName

Creating a new Sharepoint WebApplication and a Sharepoint Site Collection:

# SharePoint cmdlets
Add-PsSnapin Microsoft.SharePoint.PowerShell
# Set variables
$WebAppName = "Contoso Sharepoint1"
$WebAppHostHeader = "sharepoint1.contoso.com"
$WebAppPort = 80
$WebAppAppPool = "SharePoint1AppPool"
# This User has to be a Sharepoint Manager Account
$WebAppAppPoolAccount = "contoso\sp_serviceuser"
$WebAppDatabaseName = "Sharepoint1"
$WebAppDatabaseServer = "SQLServer\InstanceName"
$SiteCollectionName = "Homepage"
$SiteCollectionURL = ("http://" + $WebAppHostHeader)
$SiteCollectionTemplate = "STS#0"
$SiteCollectionLanguage = 1033
$SiteCollectionOwner = "contoso\UserName"

# Create a new Sharepoint WebApplication
New-SPWebApplication -Name $WebAppName -Port $WebAppPort -HostHeader $WebAppHostHeader -URL ("http://" + $WebAppHostHeader) -ApplicationPool $WebAppAppPool -ApplicationPoolAccount (Get-SPManagedAccount $WebAppAppPoolAccount) -DatabaseName $WebAppDatabaseName -DatabaseServer $WebAppDatabaseServer

# Create a new Sharepoint Site Collection
New-SPSite -URL $SiteCollectionURL -OwnerAlias $SiteCollectionOwner -Language $SiteCollectionLanguage -Template $SiteCollectionTemplate -Name $SiteCollectionName

Overview: SharePoint 2010 Service Applications

Posted on August 2, 2010 by Thomas Maurer

A lot of people wanna use Access or Excel Services with Sharepoint 2010. But this is only possible with Sharepoint Server 2010 Enterprise.

Here a short comparison of the different Sharepoint 2010 Versions and which Service Applications are supported.

Seen on www.sharepoint2010.at

Powershell: Count Sharepoint Sites on Sharepoint Server 2010

Posted on July 29, 2010 by Thomas Maurer

This is a very small line of code to count Sharepoint 2010 Site Collections with Powershell.

(Get-SPSite -Limit all).Count

By the way, we at Genotec AG are offering a Hosted Sharepoint 2010 solution based on Powershell automation.

Powershell: Get Sharepoint 2010 Site Collection Storage Usage

Posted on July 12, 2010 by Thomas Maurer

If you need to get the Storage Usage from a Sharepoint 2010 Site Collection, you can do this with Powershell.

1. Start SharePoint 2010 Management Shell or Powershell with the Sharepoint Snapin by:

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

2. Create a new Object for a Site Collection:

$MySite = Get-SPSite http://my.sharepoint.com

3. You can now check the members of the $MySite Object:

$MySite | Get-Member (You could also use: Get-SPSite http://mysite.sharepoint.com | Get-Member)

4. Now you get an output with a lot of member properties of this Site Collection Object. And you can see there is a member property called Usage, I think thats the right property. Now lets see what we get here:

$MySite.Usage

retruns:

Storage : 1775819 Bandwidth : 0 Visits : 0 Hits : 0 DiscussionStorage : 0

Ah there is a Storage property, lets use this to only get the used Storage:

$MySite.Usage.Storage

this returns the Storage Space in Bytes. Not really use full, so we get this in Megabytes:

$MySite.Usage.Storage / 1MB

returns:

1.6935....