Get Template Used by Site

$site_where_template_is_needed = get-spweb "http://rooturl/sites/sitename"

write-host $site_where_template_is_needed.webtemplate




Site Templates: get-spwebtemplate

UserProfileApplication.SynchronizeMIIS: Failed to configure ILM, will attempt during next rerun. Exception: System.Data.SqlClient.SqlException

RUN AS FARMADMIN!!!!!

$sync_db = "PROD_SA_UPS_Sync"
$ups_service_app_name = "User Profile Service"



net stop sptimerv4
$syncdb=Get-SPDatabase | where {$_.Name -eq $sync_db}
$syncdb.Unprovision()
$syncdb.Status='Offline'
$ups = Get-SPServiceApplication  | where {$_.Displayname -eq $ups_service_app_name }
$ups.ResetSynchronizationMachine()
$ups.ResetSynchronizationDatabase()
$syncdb.Provision()
net start sptimerv4

Start the UserProfileSyncService again

Stop all Incoming Mail Services

Get-SPServiceInstance | ? {$_.Typename -eq "Microsoft SharePoint Foundation Incoming E-Mail"} | Stop-SPServiceInstance -Confirm:$False

Delete Orphaned Databases

Example for all UPS Databases
Get-SPDatabase | Where{$_.Name -like "*ups*"} | ForEach {$_.Delete()}

Start all Health Analyzer Jobs

get-sptimerjob | where {$_.Name -like "*Health*" -and $_.Name -like "*all*"} | start-sptimerjob

Rename Central Administration Content Database

$ca_webapp_name = "http://centraladmin_url:9090"

$new_ca_contentdbname = "Content_CentralAdministration"

$old_ca_contentdatabase = get-spcontentdatabase -webapplication $ca_webapp_name

new-spcontentdatabase -name $new_ca_contentdbname  -webapplication $ca_webapp_name


$new_ca_cdb_id = Get-SPContentDatabase -WebApplication $ca_webapp_name | where {$_.Name -eq $new_ca_contentdbname}



get-spsite -contentdatabase $old_ca_contentdatabase | move-spsite -destinationdatabase $new_ca_cdb_id

 .... i will test this solution at 19th. April 2012

Visual Upgrade

$site = Get-SPSite("SP2007 Look And Feel SiteCollection")
$site.VisualUpgradeWebs()

Silent SharePoint Server installation

Create a BAT file within your SharePoint Binary Path: %~dp0setup.exe /config %~dp0SPconfig.xml

Create a File: SPConfig.xml within your SharePoint Binary Path and copy the following text into it.


<Configuration>
 <Package Id="sts">
  <Setting Id="LAUNCHEDFROMSETUPSTS" Value="Yes"/>
 </Package>
 <Package Id="spswfe">
  <Setting Id="SETUPCALLED" Value="1"/>
         <Setting Id="REBOOT" Value="ReallySuppress"/>       
  <Setting Id="OFFICESERVERPREMIUM" Value="1" />
 </Package>
 <Logging Type="verbose" Path="C:\SharePoint\Log" Template="SharePoint Server Setup(*).log"/>
 <PIDKEY Value="12345-12345-12345-12345-12345" />
 <DATADIR Value="C:\SharePoint\Data"/>
 <Display Level="none" CompletionNotice="yes" />
 <Setting Id="SERVERROLE" Value="APPLICATION"/>
 <Setting Id="USINGUIINSTALLMODE" Value="0"/>
 <Setting Id="SETUP_REBOOT" Value="Never" />
 <Setting Id="SETUPTYPE" Value="CLEAN_INSTALL"/>
</Configuration>

PS Script to Download all PreRequisites Files

http://gallery.technet.microsoft.com/scriptcenter/bcf3332d-f726-4ac7-b01a-eeda4b7ece8e

Configure Incoming Mail

http://technet.microsoft.com/en-us/library/cc262947.aspx

Summary:

Query Suggestions

$myquerysuggestion = "SharePoint"

$sa = Get-SPEnterpriseSearchServiceApplication
New-SPEnterpriseSearchLanguageResourcePhrase -SearchApplication $sa -Language EN-US -Type QuerySuggestionAlwaysSuggest -Name $myquerysuggestion

Add a User and/or Group to all SiteCollections as SiteCollection Admin

This Script will automatically add a User and/Or Group to ALL SiteCollections in ALL WebApplications of your SharePoint Farm.
It can be very easily modified to do this action on just one WebApp  by editing the line
$wapps = Get-SPWebApplication to
$wapps = Get-SPWebApplication "mywebappname" 

The password for the content access account cannot be decrypted.....

Errormessage:

The password for the content access account cannot be decrypted because it was stored with different credentials. Re-type the password for the account used to crawl this content.

Solution:

No Help Collection was found. / Help content cannot be displayed.

http://support.microsoft.com/kb/939313

cd %COMMONPROGRAMFILES%\Microsoft Shared\web server extensions\14\BIN
Hcinstal.exe /act InstallAllHCs

(do this action on all your SharePoint Servers)

SharePoint 2010 Browser Support

Great Article:
http://technet.microsoft.com/en-us/library/cc263526.aspx

But in general:
Only Internet Explorer 7-9 32Bit is fully supported.
All other browsers are just supported WITH limitations.

WebDav: Move Files between WebDav Folders

http://support.microsoft.com/kb/825522/en-us

It's most of all only possible to "move" data between WebDav Folder per Copy/Paste.
A REAL move is mostly not possible (just in special constellations)

Replace Text within multiple Wikipages using PowerShell

Simple Sitecollection Backup

If you have for each site collection a seperate contentdatabase, you can use this script.
Otherwhise you've just to modify the backupfilename.

SharePoint Licensing

A great site about the SP licensing models. http://sharepoint.microsoft.com/en-us/buy/pages/licensing-details.aspx

HTTP 400 - Bad Request (Request Header too long) -- error in Internet Information Services (IIS)

http://support.microsoft.com/kb/2020943