Archive
SharePoint 2013 PowerShell cmdlets listed – Onprem vs Online
PowerShell! Every SharePoint technicians best friend, for 2010 this is absolutely true, but how are we doing in the new releases? 2013 and Office 365 wave 15 (likely to be released during Q1 2013). Turns out we have nothing to worry about, with the RTM of 2013, PowerShell is still our best friend, a little worse with SharePoint Online though, but while not yet best friends, we have now gone from beeing complete strangers to acquaintances…
The support for PowerShell is somewhat better in 2013 and the number of features in the product has grown significantly, with that taken into account, the total number of CMD’lets in SharePoint Server 2013 is 730 Out of Box! This compared to SharePoint Server 2010 that has 531 CMD’lets (Aug-2011).
Compared to that, the modest list of 27 CMD’lets in SharePoint Online in the wave 15 upgrade can hardly even be called PowerShell support.
But, if looking at the original Office 365 release that had NONE/No PowerShell support for SharePoint it is a great leap forward, given that Microsoft has to solve a lot of issues running PowerShell commands against a remote instance in the cloud and never beeing able to have direct database access and so on, it is a pretty good start. I do however hope and think that Microsoft is investing in broader support in the future. I would for example love to be able to manage content and site/web configurations using PowerShell in SharePoint online as well as I can onprem today.
Below are the complete lists of Onprem vs. Online commandlets available. My goal was from the beginning to make a comparison chart but the differences are to great, the Online list to short so the benefit would be little or none.
| Note: Remember that we do not necessarily have to stare ourselves blind only at the number of CMD’lets, one CMD’let can have better functionality as well. |
-
| Menu (click on a topic) | |
| SharePoint Online CMD’lets | The complete list of CMD’lets available out of box, 27 all in all |
| SharePoint 2013 CMD’lets | The complete list of CMD’lets available out of box, an impressive list of 730. As you probably guessed, *New* means that it is new with 2013. |
| Credit and references | References, the things you still feel you have some questions about, for example how to setup the PowerShell for SharePoint Online, the SharePoint Online Management Shell, Microsofts own lists and more… |
|
SharePoint Online |
Description |
| Add-SPOUser | Adds an existing Office 365 user or an Office 365 security group to a SharePoint group. |
| Connect-SPOService | Connects a SharePoint Online global administrator to a SharePoint Online connection (the SharePoint Online Administration Center). This cmdlet must be run before any other SharePoint Online cmdlets can run. |
| Disconnect-SPOService | Disconnects from a SharePoint Online service. |
| Get-SPOAppErrors | Returns application errors. |
| Get-SPOAppInfo | Returns all installed applications. |
| Get-SPODeletedSite | Returns all deleted site collections that are in the Recycle Bin. |
| Get-SPOSite | Returns one or more site collections. |
| Get-SPOSiteGroup | Returns all the groups on the specified site collection. |
| Get-SPOTenantLogEntry | Retrieves SharePoint Online company logs. |
| Get-SPOTenantLogLastAvailableTimeInUtc | Returns the time when the SharePoint Online organization logs are collected. |
| Get-SPOUser | Returns the SharePoint Online user or security group accounts that match given search criteria. |
| Get-SPOWebTemplate | Shows all site templates that match the given identity. |
| New-SPOSite | Creates a new SharePoint Online site collection for the current company. |
| New-SPOSiteGroup | Creates a new group in a SharePoint Online site collection. |
| Remove-SPODeletedSite | Removes a SharePoint Online deleted site collection from the Recycle Bin. |
| Remove-SPOSite | Sends a SharePoint Online site collection to the SharePoint Online Recycle Bin. |
| Remove-SPOSiteGroup | Removes a SharePoint Online group from a site collection. |
| Remove-SPOUser | Removes a user or a security group from a site collection or a group. |
| Repair-SPOSite | Checks and repairs the specified site collection and its contents. |
| Request-SPOUpgradeEvaluationSite | Requests to create a copy of an existing site collection for the purposes of validating the effects of upgrade without affecting the original site. |
| Restore-SPODeletedSite | Restores a SharePoint Online deleted site collection from the Recycle Bin. |
| Set-SPOSite | Sets or updates the values of one or more properties for a site collection. |
| Set-SPOSiteGroup | Updates the SharePoint Online owner and permission level on a group inside a site collection. |
| Set-SPOTenant | Sets properties on the SharePoint Online organization. |
| Set-SPOUser | Configures properties on an existing user. |
| Test-SPOSite | Tests a SharePoint Online site collection. |
| Upgrade-SPOSite | Starts the upgrade process on a site collection. |
| SharePoint Server 2013 | SharePoint Foundation 2013 | Description |
| Add-SPAppDeniedEndpoint *New* | Adds an endpoint to the Apps denied endpoint list. |
| Add-SPClaimTypeMapping *New* | Adds a claim mapping to a trusted security token service (STS) identity provider. |
| Add-SPDiagnosticsPerformanceCounter | Adds an instance of a performance counter. |
| Add-SPDistributedCacheServiceInstance *New* | Adds an instance of the distributed cache service to a local server. |
| Add-SPInfoPathUserAgent | Adds a user agent to a farm. |
| Add-SPProfileLeader | Adds a company leader. |
| Add-SPRoutingMachineInfo *New* | Adds a new routing target to the farm. |
| Add-SPRoutingMachinePool *New* | Adds a new machine pool. |
| Add-SPRoutingRule *New* | Adds a routing rule. |
| Add-SPScaleOutDatabase *New* | Adds an existing scale-out database to the specified service application. |
| Add-SPSecureStoreSystemAccount *New* | Adds an account to a designated list. |
| Add-SPServerScaleOutDatabase *New* | Adds an existing scale-out database to the specified service application. |
| Add-SPServiceApplicationProxyGroupMember | Adds a member to the service application proxy group. |
| Add-SPShellAdmin | Adds a user to the SharePoint_Shell_Access role for the specified database. |
| Add-SPSiteSubscriptionFeaturePackMember | Adds a feature to a SharePoint feature set. |
| Add-SPSiteSubscriptionProfileConfig | Adds a new site subscription to a User Profile Service application. |
| Add-SPSocialAppPermissions *New* | Do not use this cmdlet. |
| Add-SPSolution | Uploads a SharePoint solution package to the farm. |
| Add-SPThrottlingRule *New* | Adds a new throttling rule. |
| Add-SPUserLicenseMapping *New* | Maps a security group, forms-based role, or claim to a SharePoint user license. |
| Add-SPUserSolution | Uploads a new sandboxed solution to the solution gallery. |
| Backup-SPConfigurationDatabase | Performs a farm-level configuration-only backup. |
| Backup-SPEnterpriseSearchServiceApplicationIndex *New* | Takes a backup of the search index to a specified backup location. |
| Backup-SPFarm | Creates a backup of an individual database, web application, or the entire farm. |
| Backup-SPSite | Performs a backup of a site collection. |
| Clear-SPAppDeniedEndpointList *New* | Removes all App denied endpoints. |
| Clear-SPBusinessDataCatalogEntityNotificationWeb | Clears the entity notification site. |
| Clear-SPDistributedCacheItem *New* | Clears cached items from the distributed cache server. |
| Clear-SPLogLevel | Resets the Windows trace logging and event logging levels to their default values. |
| Clear-SPMetadataWebServicePartitionData | Removes all data for a site subscription on a metadata Web service application |
| Clear-SPPerformancePointServiceApplicationTrustedLocation | Clears all the trusted locations for a PerformancePoint Services application identity |
| Clear-SPScaleOutDatabaseDeletedDataSubRange *New* | Clears all partitions inside the specified deleted subrange. |
| Clear-SPScaleOutDatabaseLog *New* | Clears all scale-out logs. |
| Clear-SPScaleOutDatabaseTenantData *New* | Removes all data related to the specified site subscription. |
| Clear-SPSecureStoreCredentialMapping | Deletes a credential mapping from a Secure Store Service application. |
| Clear-SPSecureStoreDefaultProvider | Clears the secure store provider. |
| Clear-SPServerScaleOutDatabaseDeletedDataSubRange *New* | Clears all partitions inside the specified deleted subrange. |
| Clear-SPServerScaleOutDatabaseLog *New* | Clears all scale-out logs. |
| Clear-SPServerScaleOutDatabaseTenantData *New* | Removes all data related to the specified site subscription. |
| Clear-SPSiteSubscriptionBusinessDataCatalogConfig | Deletes all data from the Business Data Connectivity Metadata Store for a specified partition. |
| Connect-SPConfigurationDatabase | Connects the local server computer to a farm. |
| Convert-SPWebApplication *New* | Converts the authentication mode of a web application. |
| Copy-SPBusinessDataCatalogAclToChildren | Copies a set of permissions of a Business Data Connectivity Metadata Store metadata object to its child objects. |
| Copy-SPSite | Makes a copy of a site collection. |
| Disable-SPAppAutoProvision *New* | Disables automatic provisioning of an app. |
| Disable-SPBusinessDataCatalogEntity | Deactivates an external content type in the Business Data Connectivity Metadata Store. |
| Disable-SPFeature | Disables an installed SharePoint feature at a given scope. |
| Disable-SPInfoPathFormTemplate | Deactivates an InfoPath 2013 form template from the specified site collection. |
| Disable-SPSessionStateService | Turns off the session state service on the farm |
| Disable-SPSingleSignOn | Disables the single sign-on (SSO) service on a farm server. |
| Disable-SPTimerJob | Disables a timer job. |
| Disable-SPUserLicensing *New* | Disables user license enforcement. |
| Disable-SPWebApplicationHttpThrottling | Turns off network throttling for a web application. |
| Disconnect-SPConfigurationDatabase | Disconnects the local server computer from the farm. |
| Dismount-SPContentDatabase | Detaches a content database from the web application it is currently associated with. |
| Dismount-SPStateServiceDatabase | Removes the association to a state service database from the farm without dropping the database in the Microsoft SQL Server database |
| Enable-SPAppAutoProvision *New* | Enables automatic provisioning of an app. |
| Enable-SPBusinessDataCatalogEntity | Activates an external content type in the Business Data Connectivity Metadata Store. |
| Enable-SPFeature | Enables an installed SharePoint feature at the given scope. |
| Enable-SPInfoPathFormTemplate | Activates an InfoPath 2013 form template in the specified site collection. |
| Enable-SPSessionStateService | Creates a session state database and turns on the session state service |
| Enable-SPTimerJob | Enables a timer job. |
| Enable-SPUserLicensing *New* | Enables user-license enforcement. |
| Enable-SPWebApplicationHttpThrottling | Turns on network throttling for a web application. |
| Export-SPAppPackage *New* | Exports an app package. |
| Export-SPBusinessDataCatalogModel | Exports a Business Data Connectivity Model. |
| Export-SPEnterpriseSearchTopology | Exports an existing search topology. |
| Export-SPInfoPathAdministrationFiles | Saves InfoPath 2013 form templates on the SharePoint Central Administration web site and .udcx files to a .cab file. |
| Export-SPMetadataWebServicePartitionData | Exports the data from a metadata Web service for a site subscription. |
| Export-SPScaleOutDatabaseTenantData *New* | Exports the data of the specified subscription. |
| Export-SPServerScaleOutDatabaseTenantData *New* | Exports the data of the specified subscription. |
| Export-SPSiteSubscriptionBusinessDataCatalogConfig | Exports all data from the Business Data Connectivity Metadata Store associated with a partition. |
| Export-SPSiteSubscriptionSettings | Creates a backup file of site subscription data. |
| Export-SPWeb | Exports a site collection, web application, list, or library. |
| Get-SPAccessServiceApplication | Returns an Access Services application or a collection of Access Services applications. |
| Get-SPAccessServicesApplication *New* | Returns an Access Services application or a collection of Access Services applications. |
| Get-SPAccessServicesDatabase *New* | Returns an Access Services database or a collection of Access Services databases. |
| Get-SPAccessServicesDatabaseServer *New* | Returns the settings for all application servers. |
| Get-SPAccessServicesDatabaseServerGroup *New* | Returns the settings for all application server groups. |
| Get-SPAccessServicesDatabaseServerGroupMapping *New* | Returns the mapping from a source package type to the database server group. |
| Get-SPAlternateURL | Returns all alternate URLs that match a given set of criteria. |
| Get-SPAppAcquisitionConfiguration *New* | Returns app acquisition settings. |
| Get-SPAppAutoProvisionConnection *New* | Returns provision connection settings for an app. |
| Get-SPAppDeniedEndpointList *New* | Returns the App denied endpoint list. |
| Get-SPAppDisablingConfiguration *New* | Returns the disable list sync state for an app. |
| Get-SPAppDomain *New* | Gets the domain used to host Apps. |
| Get-SPAppHostingQuotaConfiguration *New* | Returns the hosting quotas for an app. |
| Get-SPAppInstance *New* | Returns the hosting quotas for an app. |
| Get-SPAppStoreConfiguration *New* | Returns app SharePoint Store settings. |
| Get-SPAppPrincipal *New* | Displays a specific app principal object. |
| Get-SPAppScaleProfile *New* | Returns settings for an app profile. |
| Get-SPAppSiteSubscriptionName *New* | Returns the name of the specified site subscription. |
| Get-SPAppDisablingConfiguration *New* | Returns the disable list sync state for an app. |
| Get-SPAppStateSyncLastRunTime *New* | Returns the latest time the app state update job was invoked. |
| Get-SPAppStateUpdateInterval *New* | Returns the interval in hours between updates of the app state update job. |
| Get-SPAuthenticationProvider | Returns an authentication provider. |
| Get-SPAuthenticationRealm *New* | Returns the authentication realms. |
| Get-SPBackupHistory | Returns a history of backup and restore operations. |
| Get-SPBingMapsBlock *New* | Sets Bing maps to blocked status. |
| Get-SPBingMapsKey *New* | Returns the Bing Maps key. |
| Get-SPBrowserCustomerExperienceImprovementProgram | Returns the current opt-in state for the browser Customer Experience Improvement Program. |
| Get-SPBusinessDataCatalogEntityNotificationWeb *New* | Returns the entity notification site. |
| Get-SPBusinessDataCatalogMetadataObject | Returns a Business Data Connectivity Metadata Store metadata object. |
| Get-SPBusinessDataCatalogThrottleConfig | Returns the throttling configuration for a Business Data Connectivity service application. |
| Get-SPCertificateAuthority | Returns the SharePoint certificate authority (CA). |
| Get-SPClaimProvider | Returns a claim provider. |
| Get-SPClaimProviderManager | Returns a claim provider manager. |
| Get-SPClaimTypeEncoding *New* | Returns a list of all the types of claims. |
| Get-SPContentDatabase | Returns one or more content databases. |
| Get-SPContentDeploymentJob | Returns a content deployment job or a collection of content deployment jobs. |
| Get-SPContentDeploymentPath | Returns a content deployment path or a collection of content deployment paths. |
| Get-SPCustomLayoutsPage | Returns a mapping to a custom layout page. |
| Get-SPDatabase | Retrieves all properties of a database. |
| Get-SPDataConnectionFile | Returns a data connection file or a collection of data connection files. |
| Get-SPDataConnectionFileDependent | Returns deployed forms on the server dependent on a universal data connection. |
| Get-SPDesignerSettings | Displays SharePoint Designer 2013 features. |
| Get-SPDiagnosticConfig | Retrieves ULS diagnostic configuration values of the farm. |
| Get-SPDiagnosticsPerformanceCounter | Returns a collection of performance counters. |
| Get-SPDiagnosticsProvider | Returns a diagnostics provider. |
| Get-SPDistributedCacheClientSetting *New* | Returns distributed cache settings from usage. |
| Get-SPEnterpriseSearchComponent *New* | Retrieves one or all search components in a given search topology. |
| Get-SPEnterpriseSearchContentEnrichmentConfiguration *New* | Returns the content enrichment configuration for the specified search service application. |
| Get-SPEnterpriseSearchCrawlContentSource | Returns a crawl content source. |
| Get-SPEnterpriseSearchCrawlCustomConnector | Returns a CustomConnector object type. |
| Get-SPEnterpriseSearchCrawlDatabase | Returns a crawl store. |
| Get-SPEnterpriseSearchCrawlExtension | Returns the file types to be included in the content index. |
| Get-SPEnterpriseSearchCrawlMapping | Returns a crawl mapping for the search application. |
| Get-SPEnterpriseSearchCrawlRule | Accesses crawl rules. |
| Get-SPEnterpriseSearchFileFormat *New* | Lists all parseable file formats. |
| Get-SPEnterpriseSearchHostController *New* | Lists the specified or all search host controllers in the farm. |
| Get-SPEnterpriseSearchLanguageResourcePhrase | Returns a language resource phrase. |
| Get-SPEnterpriseSearchLinguisticComponentsStatus *New* | Returns the status of the linguistic query and document processing components. |
| Get-SPEnterpriseSearchLinksDatabase *New* | Retrieves a reference to a links database. |
| Get-SPEnterpriseSearchMetadataCategory | Returns a crawled property category. |
| Get-SPEnterpriseSearchMetadataCrawledProperty | Returns a crawled property. |
| Get-SPEnterpriseSearchMetadataManagedProperty | Returns a managed property. |
| Get-SPEnterpriseSearchMetadataMapping | Returns the current state of a managed property mapping. |
| Get-SPEnterpriseSearchOwner *New* | Returns the search object owner. |
| Get-SPEnterpriseSearchPropertyRule *New* | Returns a property rule. |
| Get-SPEnterpriseSearchPropertyRuleCollection *New* | Returns the collection of rules that are applied to search results. |
| Get-SPEnterpriseSearchQueryAndSiteSettingsService | Returns the search manager service. |
| Get-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance | Returns the service manager service instance. |
| Get-SPEnterpriseSearchQueryAndSiteSettingsServiceProxy | Returns the search manager service proxy. |
| Get-SPEnterpriseSearchQueryAuthority | Returns an authoritative page. |
| Get-SPEnterpriseSearchQueryDemoted | Returns a demoted site rule. |
| Get-SPEnterpriseSearchQueryKeyword | Returns a keyword term. |
| Get-SPEnterpriseSearchQueryScope | Returns a query results scope. |
| Get-SPEnterpriseSearchQueryScopeRule | Returns a shared scope rule. |
| Get-SPEnterpriseSearchQuerySpellingCorrection *New* | Returns the object that exposes the Query Spelling Correction (QSC) configuration. |
| Get-SPEnterpriseSearchQuerySuggestionCandidates | Returns a list of queries. |
| Get-SPEnterpriseSearchRankingModel | Returns a ranking model. |
| Get-SPEnterpriseSearchResultItemType *New* | Returns result item types. |
| Get-SPEnterpriseSearchSecurityTrimmer | Returns a custom security trimmer. |
| Get-SPEnterpriseSearchService | Returns the search service for a farm. |
| Get-SPEnterpriseSearchServiceApplication | Returns the search service application for a farm. |
| Get-SPEnterpriseSearchServiceApplicationBackupStore *New* | Retrieves information about the search service application backup files. |
| Get-SPEnterpriseSearchServiceApplicationProxy | Returns the search service application proxy. |
| Get-SPEnterpriseSearchServiceInstance | Returns the search service instance for a farm. |
| Get-SPEnterpriseSearchSiteHitRule | Returns the shared site hit rule. |
| Get-SPEnterpriseSearchStatus | Retrieves diagnostics information for the search components. |
| Get-SPEnterpriseSearchTopology *New* | Retrieves one or all search topologies that belong to a given search service application. |
| Get-SPEnterpriseSearchVssDataPath *New* | Retrieves the index paths for all active search index components on the current server. |
| Get-SPExcelBlockedFileType | Returns a file type or list of file types that are prevented from being loaded. |
| Get-SPExcelDataConnectionLibrary | Returns a trusted data connection library or a list of trusted data connection libraries. |
| Get-SPExcelDataProvider | Returns a safe data provider or a list of safe data providers. |
| Get-SPExcelFileLocation | Returns a trusted file location or a list of trusted file locations. |
| Get-SPExcelServiceApplication | Returns an SPExcelServiceApplication object. |
| Get-SPExcelUserDefinedFunction | Returns a user-defined function or a collection of user-defined functions. |
| Get-SPFarm | Returns the local SharePoint farm. |
| Get-SPFarmConfig | Returns a global property or a collection of global properties for the local farm. |
| Get-SPFeature | Returns the SharePoint features based on a given scope. |
| Get-SPHelpCollection | Returns Help collection files. |
| Get-SPInfoPathFormsService | Returns the InfoPath Forms Services in SharePoint Server 2013 settings that are in the farm. |
| Get-SPInfoPathFormTemplate | Returns an InfoPath 2013 form template. |
| Get-SPInfoPathUserAgent | Returns a user agent or all the currently defined user agents for the farm. |
| Get-SPInfoPathWebServiceProxy | Returns the web proxy settings for the web application. |
| Get-SPInternalAppStateSyncLastRunTime *New* | Returns the latest time the internal app state update job was invoked. |
| Get-SPInternalAppStateUpdateInterval *New* | Returns the interval in hours between updates of the internal app state update job. |
| Get-SPIRMSettings *New* | Returns the Information Rights Management (IRM) settings. |
| Get-SPLogEvent | Returns results from a Unified Logging Service (ULS) trace log. |
| Get-SPLogLevel | Returns a list of objects or diagnostic levels. |
| Get-SPManagedAccount | Retrieves accounts registered in the configuration database. |
| Get-SPMarketplaceConnectionSettings *New* | Returns SharePoint Store settings. |
| Get-SPManagedPath | Returns all managed paths that match the given criteria. |
| Get-SPMetadataServiceApplication | Returns the properties of a service application or a collection of service applications. |
| Get-SPMetadataServiceApplicationProxy | Returns the properties of a service application proxy or a collection of service application proxies. |
| Get-SPMobileMessagingAccount | Retrieves mobile messaging accounts for the specified web application. |
| Get-SPODataConnectionSettingMetaData *New* | Returns a Business Data Connectivity service metadata object. |
| Get-SPOfficeStoreAppsDefaultActivation *New* | Returns the properties of apps for Office. |
| Get-SPPendingUpgradeActions *New* | Displays pending upgrade actions. |
| Get-SPPerformancePointServiceApplication | Returns a PerformancePoint Service application object and properties. |
| Get-SPPerformancePointServiceApplicationTrustedLocation | Returns a trusted location object and properties for a PerformancePoint Services application. |
| Get-SPProcessAccount | Returns a system account or a managed account. |
| Get-SPProduct | Returns a list of the SharePoint-related products installed in the farm and the versions of all updates installed for each product. |
| Get-SPProfileLeader | Returns the current company leaders. |
| Get-SPProfileServiceApplicationSecurity | Returns permission and identity information. |
| Get-SPRequestManagementSettings *New* | Returns a Request Manager object. |
| Get-SPRoutingMachineInfo *New* | Returns all the routing targets. |
| Get-SPRoutingMachinePool *New* | Returns all available routing pools. |
| Get-SPRoutingRule *New* | Returns all routing rules. |
| Get-SPScaleOutDatabase *New* | Returns all scale-out database objects. |
| Get-SPScaleOutDatabaseDataState *New* | Returns the state information about the specified scale-out database. |
| Get-SPScaleOutDatabaseInconsistency *New* | Displays all inconsistencies related to scale-out databases’ ranges. |
| Get-SPScaleOutDatabaseLogEntry *New* | Queries a scale-out database for scale-out logs. |
| Get-SPSecureStoreApplication | Returns a Secure Store application. |
| Get-SPSecureStoreSystemAccount *New* | Returns a list of users from a designated list. |
| Get-SPSecurityTokenServiceConfig | Returns the security token service (STS) for the farm. |
| Get-SPServer | Returns the server or servers in the farm that match the given identity. |
| Get-SPServerScaleOutDatabase *New* | Returns all scale-out database objects. |
| Get-SPServerScaleOutDatabaseDataState *New* | Returns the state information about the specified scale-out database. |
| Get-SPServerScaleOutDatabaseInconsistency *New* | Displays all inconsistencies related to scale-out databases’ ranges. |
| Get-SPServerScaleOutDatabaseLogEntry *New* | Queries a scale-out database for scale-out logs. |
| Get-SPServiceApplication | Returns the specified service application. |
| Get-SPServiceApplicationEndpoint | Returns the endpoint of a service application. |
| Get-SPServiceApplicationPool | Returns the specified Internet Information Services (IIS) application pool. |
| Get-SPServiceApplicationProxy | Returns an instance of the specified service application proxy. |
| Get-SPServiceApplicationProxyGroup | Returns the proxy group for the specified service application. |
| Get-SPServiceApplicationSecurity | Returns the SPObjectSecurity object for a service application. |
| Get-SPServiceContext | Returns a service context. |
| Get-SPServiceHostConfig | Returns the common web service settings. |
| Get-SPServiceInstance | Returns the services instance for a specific server or the entire farm. |
| Get-SPSessionStateService | Returns the properties of the session state service, including time-out and database settings |
| Get-SPShellAdmin | Returns the names of all users who have the SharePoint_Shell_Access role. |
| Get-SPSite | Returns all site collections that match the given criteria. |
| Get-SPSiteAdministration | Returns a site administration object that farm administrators can use to view certain information about site collections to which they might not have access. |
| Get-SPSiteSubscription | Returns the site subscription for the given URL or all site subscriptions in the local farm. |
| Get-SPSiteSubscriptionConfig | Returns the configuration properties of a site subscription. |
| Get-SPSiteSubscriptionEdiscoveryHub | Displays the eDiscovery hub for a site subscription. |
| Get-SPSiteSubscriptionEdiscoverySearchScope | Displays the search scope for the eDiscovery hub of the specified site collection. |
| Get-SPSiteSubscriptionFeaturePack | Retrieves available SharePoint feature sets or the Feature set assigned to a given site subscription. |
| Get-SPSiteSubscriptionIRMConfig *New* | Gets the Information Rights Management (IRM) settings. |
| Get-SPSiteSubscriptionMetadataConfig | Returns the site subscription configuration settings for a metadata service application. |
| Get-SPSiteUpgradeSessionInfo *New* | Manage or report site upgrade. |
| Get-SPSiteUrl *New* | Displays all URL mappings for the site. |
| Get-SPSolution | Returns a specified SharePoint solution. |
| Get-SPStateServiceApplication | Returns state service applications on the farm |
| Get-SPStateServiceApplicationProxy | Returns state service application proxies on the farm. |
| Get-SPStateServiceDatabase | Returns a state service database. |
| Get-SPTaxonomySession | Returns a TaxonomySession object. |
| Get-SPThrottlingRule *New* | Returns all throttling rules. |
| Get-SPTimerJob | Returns timer jobs. |
| Get-SPTopologyServiceApplication | Displays properties of the topology service application for the current farm. |
| Get-SPTopologyServiceApplicationProxy | Retrieves the topology service application proxy. |
| Get-SPTrustedIdentityTokenIssuer | Returns an identity provider. |
| Get-SPTrustedRootAuthority | Returns a trusted root authority. |
| Get-SPTrustedSecurityTokenIssuer *New* | Returns the trusted security token issuer object. |
| Get-SPUpgradeActions *New* | Returns all upgrade actions. |
| Get-SPUsageApplication | Returns a specified usage application. |
| Get-SPUsageDefinition | Returns a usage definition object. |
| Get-SPUsageService | Returns a usage service. |
| Get-SPUser | Returns the user account or accounts that match a given search criteria. |
| Get-SPUserLicense *New* | Returns the list of supported SharePoint user licenses. |
| Get-SPUserLicenseMapping *New* | Returns the claim-to-user license mappings. |
| Get-SPUserLicensing *New* | Returns the state of user-license enforcement. |
| Get-SPUserSolution | Returns a specified sandboxed solution. |
| Get-SPVisioExternalData | Returns the settings for external data connections for a Visio Services application. |
| Get-SPVisioPerformance | Returns the Visio Services settings for the performance of a Visio Services application. |
| Get-SPVisioSafeDataProvider | Returns the settings of a safe data provider for a Visio Services application. |
| Get-SPVisioServiceApplication | Returns properties of a Visio Services application or a collection of Visio Services applications. |
| Get-SPVisioServiceApplicationProxy | Returns properties of a Visio Services application proxy or a collection of Visio Services application proxies |
| Get-SPWeb | Returns all subsites that match the given criteria. |
| Get-SPWebApplication | Returns all web applications that match the given criteria. |
| Get-SPWebApplicationHttpThrottlingMonitor | Reads all counters for network throttling on a web application. |
| Get-SPWebPartPack | Returns the Web Part packages that were installed for the specified scope. |
| Get-SPWebTemplate | Displays all globally installed site templates that match the given identity. |
| Get-SPWorkflowConfig | Returns workflow settings for the specified web application. |
| Get-SPWOPIBinding *New* | Returns a list of bindings that were created by using New-SPWOPIBinding on the current SharePoint farm where this cmdlet is run. |
| Get-SPWOPISuppressionSetting *New* | Returns the suppression settings on the current SharePoint farm where this cmdlet is run. |
| Get-SPWOPIZone *New* | Returns the zone that is configured on the current SharePoint farm for the WOPI application to use. |
| Grant-SPBusinessDataCatalogMetadataObject | Grants a right to a principal for the specified Business Data Connectivity Metadata Store metadata object. |
| Grant-SPObjectSecurity | Adds a new security principal to an SPObjectSecurity object. |
| Import-SPAppPackage *New* | Imports an app package. |
| Import-SPBusinessDataCatalogDotNetAssembly | Imports data that is associated with the Business Data Connectivity Metadata Store for a partition. |
| Import-SPBusinessDataCatalogModel | Imports a Business Data Connectivity Model. |
| Import-SPEnterpriseSearchCustomExtractionDictionary *New* | Imports a custom extraction dictionary. |
| Import-SPEnterpriseSearchPopularQueries *New* | Imports queries from a comma-separated list. The search box will suggest these queries as users type. |
| Import-SPEnterpriseSearchThesaurus *New* | Deploys the dictionary to the thesaurus component in the query processing flow. |
| Import-SPEnterpriseSearchTopology | Imports and activates a topology from an XML file. |
| Import-SPInfoPathAdministrationFiles | Imports InfoPath 2013 form templates and .udcx files that are located on the SharePoint Central Administration web site. |
| Import-SPMetadataWebServicePartitionData | Restores the data for a site subscription. |
| Import-SPScaleOutDatabaseTenantData *New* | Imports data from the specified subscription id. |
| Import-SPServerScaleOutDatabaseTenantData *New* | Imports data from the specified subscription id. |
| Import-SPSiteSubscriptionSettings | Restores a backup of subscription site settings to the given subscription identifier. |
| Import-SPWeb | Imports a site collection, web application, list, or library. |
| Initialize-SPResourceSecurity | Enforces resource security on the local server. |
| Initialize-SPStateServiceDatabase | Installs the state database schema into a state service database |
| Install-SPApp *New* | Installs an instance of an app. |
| Install-SPApplicationContent | Copies shared application data to existing web application folders. |
| Install-SPDataConnectionFile | Installs the provided data connection file. |
| Install-SPFeature | Installs a SharePoint feature by using the Feature.xml file. |
| Install-SPHelpCollection | Installs the provided Help site collection files in the current farm. |
| Install-SPInfoPathFormTemplate | Installs an InfoPath 2013 form template on a farm. |
| Install-SPService | Installs and provisions services on a farm. |
| Install-SPSolution | Deploys an installed SharePoint solution in the farm. |
| Install-SPUserSolution | Activates a sandboxed solution in a site collection. |
| Install-SPWebPartPack | Installs the specified Web Part package to the specified location. |
| Merge-SPLogFile | Combines trace log entries from all farm computers into a single log file on the local computer. |
| Mount-SPContentDatabase | Attaches an existing content database to the farm. |
| Mount-SPStateServiceDatabase | Attaches an existing state service database to the farm |
| Move-SPBlobStorageLocation | Copies a content database by using Remote BLOB Storage (RBS). |
| Move-SPDeletedSite | Moves deleted site collections from one content database to another. |
| Move-SPEnterpriseSearchLinksDatabases *New* | Repartitions data across links databases. |
| Move-SPProfileManagedMetadataProperty | Moves multiple-string values into a term set. |
| Move-SPSocialComments | Moves social comments. |
| Move-SPSite | Moves site collections from one content database to another. |
| Move-SPUser | Migrates a user account in SharePoint 2010 Products. |
| New-SPAccessServiceApplication | Creates a new instance of an Access Services application. |
| New-SPAccessServicesApplication *New* | Creates a new instance of an Access Services application in SharePoint Server 2013. |
| New-SPAccessServicesDatabaseServer *New* | Adds a new SQL Server database to the list of servers. |
| New-SPAlternateUrl | Creates a new public or internal URL for the specified web application zone or resource. |
| New-SPAppManagementServiceApplication *New* | Creates an App Management Service application. |
| New-SPAppManagementServiceApplicationProxy *New* | Creates an App Management Service application proxy. |
| New-SPAuthenticationProvider | Creates a new authentication provider in the farm. |
| New-SPAzureAccessControlServiceApplicationProxy *New* | Creates a new service application proxy group. |
| New-SPBECWebServiceApplicationProxy *New* | Do not use this cmdlet. |
| New-SPBusinessDataCatalogServiceApplication | Creates a new Business Data Connectivity service application in the farm. |
| New-SPBusinessDataCatalogServiceApplicationProxy | Creates a new Business Data Connectivity service application proxy in the farm. |
| New-SPCentralAdministration | Creates a new SharePoint Central Administration web application. |
| New-SPClaimProvider | Registers a new claim provider in the farm. |
| New-SPClaimsPrincipal | Creates a new claims principal. |
| New-SPClaimTypeEncoding *New* | Registers a new type of claim. |
| New-SPClaimTypeMapping *New* | Creates a claim mapping rule for a security token service (STS) identity provider. |
| New-SPConfigurationDatabase | Creates a new configuration database. |
| New-SPContentDatabase | Creates a new content database and attaches it to the specified web application. |
| New-SPContentDeploymentJob | Creates a content deployment job. |
| New-SPContentDeploymentPath | Creates a new content deployment path. |
| New-SPEnterpriseSearchAdminComponent *New* | Creates a new admin component for the given topology and search service instance. |
| New-SPEnterpriseSearchAnalyticsProcessingComponent *New* | Creates a new analytics processing component for the given topology and search service instance. |
| New-SPEnterpriseSearchContentEnrichmentConfiguration *New* | Creates a new ContentEnrichmentConfiguration object. |
| New-SPEnterpriseSearchContentProcessingComponent | Creates a new content processing component for the given topology and search service instance. |
| New-SPEnterpriseSearchCrawlComponent | Adds a query component to a query topology. |
| New-SPEnterpriseSearchCrawlContentSource | Creates a new crawl content source for a shared search application. |
| New-SPEnterpriseSearchCrawlCustomConnector | Registers a protocol for custom crawling. |
| New-SPEnterpriseSearchCrawlDatabase | Creates a crawl database which can be added to a search service application. |
| New-SPEnterpriseSearchCrawlExtension | Adds an extension rule to a shared search application. |
| New-SPEnterpriseSearchCrawlMapping | Creates a crawl mapping rule for a shared search application. |
| New-SPEnterpriseSearchCrawlRule | Creates a new crawl rule. |
| New-SPEnterpriseSearchFileFormat *New* | Adds a new file format in the parsing system. |
| New-SPEnterpriseSearchIndexComponent *New* | Creates a new index component for the given topology and search service instance. |
| New-SPEnterpriseSearchLanguageResourcePhrase *New* | Adds a language resource phrase to a shared search application. |
| New-SPEnterpriseSearchLinksDatabase *New* | Creates a new links database for a search service application. |
| New-SPEnterpriseSearchMetadataCategory | Adds a crawled property category to a search service application. |
| New-SPEnterpriseSearchMetadataCrawledProperty | Adds a crawled property to a search application crawled property category. |
| New-SPEnterpriseSearchMetadataManagedProperty | Adds a managed property to a shared search application. |
| New-SPEnterpriseSearchMetadataMapping | Adds a managed property mapping to a shared search application. |
| New-SPEnterpriseSearchQueryAuthority | Adds an authoritative page to a shared search application. |
| New-SPEnterpriseSearchQueryDemoted | Adds a demoted site rule to a shared search application. |
| New-SPEnterpriseSearchQueryKeyword | Adds a keyword term to a shared search application. |
| New-SPEnterpriseSearchQueryProcessingComponent *New* | Creates a new query processing component for the given topology and search service instance. |
| New-SPEnterpriseSearchQueryScope | Adds a query results scope to a shared search application. |
| New-SPEnterpriseSearchQueryScopeRule | Adds a shared scope rule to a query scope. |
| New-SPEnterpriseSearchRankingModel | Adds a ranking model to a shared search application. |
| New-SPEnterpriseSearchResultItemType *New* | Creates a new result item type. |
| New-SPEnterpriseSearchSecurityTrimmer | Adds a custom security trimmer to a shared search application. |
| New-SPEnterpriseSearchServiceApplication | Adds a search service application to a farm. |
| New-SPEnterpriseSearchServiceApplicationProxy | Adds a new search application proxy to a farm.. |
| New-SPEnterpriseSearchSiteHitRule | Adds a new site hit rule for a search application. |
| New-SPEnterpriseSearchTopology *New* | Creates a new search topology in the given search service application. |
| New-SPExcelBlockedFileType | Adds a file type to the list of file types that Excel Services Application prevents from being loaded. |
| New-SPExcelDataConnectionLibrary | Adds a new data connection library to Excel Services Application. |
| New-SPExcelDataProvider | Adds a new safe data provider to Excel Services Application. |
| New-SPExcelFileLocation | Adds a new trusted location to Excel Services Application. |
| New-SPExcelServiceApplication | Creates a new instance of Excel Services Application. |
| New-SPExcelUserDefinedFunction | Adds a new user-defined function to Excel Services Application. |
| New-SPLogFile | Creates a new log file. |
| New-SPManagedAccount | Registers a new managed account. |
| New-SPManagedPath | Creates a new managed path for the given web application for all host header site collections. |
| New-SPMarketplaceWebServiceApplicationProxy *New* | Creates a service application proxy for the app identity data web service. |
| New-SPMetadataServiceApplication | Creates a new metadata service application. |
| New-SPMetadataServiceApplicationProxy | Creates a new metadata service application proxy. |
| New-SPODataConnectionSetting *New* | Creates a new Business Data Connectivity service connection. |
| New-SPPerformancePointServiceApplication | Creates a new service application for PerformancePoint Services. |
| New-SPPerformancePointServiceApplicationProxy | Creates a proxy for a PerformancePoint Services application. |
| New-SPPerformancePointServiceApplicationTrustedLocation | Creates a new trusted location for a PerformancePoint Services application. |
| New-SPPowerPointConversionServiceApplication | Creates a PowerPoint Conversion Service application. |
| New-SPPowerPointConversionServiceApplicationProxy | Creates a PowerPoint Conversion Service application proxy. |
| New-SPProfileServiceApplication | Adds a User Profile Service application to a farm. |
| New-SPProfileServiceApplicationProxy | Creates a User Profile Service application proxy on the local farm. |
| New-SPRequestManagementRuleCriteria *New* | Creates criteria for the rule to match. |
| New-SPSecureStoreApplication | Creates a new Secure Store application. |
| New-SPSecureStoreApplicationField | Creates a new Secure Store application fields object. |
| New-SPSecureStoreServiceApplication | Creates a new Secure Store Service application in the farm. |
| New-SPSecureStoreServiceApplicationProxy | Creates a new Secure Store Service application proxy in the farm. |
| New-SPSecureStoreTargetApplication | Creates a new Secure Store target application. |
| New-SPServiceApplicationPool | Creates a new Web service application pool. |
| New-SPServiceApplicationProxyGroup | Creates a new service application proxy group. |
| New-SPSite | Creates a new site collection at the specified URL. |
| New-SPSiteSubscription | Creates a new site subscription. |
| New-SPSiteSubscriptionFeaturePack | Creates a new SharePoint feature set that can be used to limit the features available to a site subscription. |
| New-SPStateServiceApplication | Creates a new state service application |
| New-SPStateServiceApplicationProxy | Creates a proxy for a state service application |
| New-SPStateServiceDatabase | Creates and provisions a new state service database, and installs the state database schema into it |
| New-SPSubscriptionSettingsServiceApplication | Creates a new subscription settings service application. |
| New-SPSubscriptionSettingsServiceApplicationProxy | Creates an application proxy to a subscription settings service application. |
| New-SPTranslationServiceApplication *New* | Provisions a new instance of the Machine Translation service. |
| New-SPTranslationServiceApplicationProxy *New* | Creates a Machine Translation Service application proxy on the local farm. |
| New-SPTrustedIdentityTokenIssuer | Creates an identity provider in the farm. |
| New-SPTrustedRootAuthority | Creates a trusted root authority. |
| New-SPTrustedSecurityTokenIssuer *New* | Creates a trust between a server to server principal. |
| New-SPTrustedServiceTokenIssuer | Creates a trust with a SharePoint farm. |
| New-SPUsageApplication | Creates a new usage application. |
| New-SPUsageLogFile | Starts a new usage log file on the current server computer. |
| New-SPUser | Adds an existing user to a SharePoint site with the designated permissions. |
| New-SPUserLicenseMapping *New* | Creates a license mapping object. |
| New-SPVisioSafeDataProvider | Adds a new data provider to a Visio Services application. |
| New-SPVisioServiceApplication | Adds a new Visio Services application to a farm. |
| New-SPVisioServiceApplicationProxy | Adds a new Visio Services application proxy to a farm. |
| New-SPWeb | Creates a new site in an existing site collection. |
| New-SPWebApplication | Creates a new web application within the local farm. |
| New-SPWebApplicationExtension | Creates a new zone instance for the web application. |
| New-SPWOPIBinding *New* | Creates a new binding to associate file name extensions or applications with actions on the current SharePoint farm where this cmdlet is run. |
| New-SPWOPISuppressionSetting *New* | The New-SPWOPISuppressionSetting cmdlet turns off Office Web Apps for the action and document type or binding you’ve specified on the current SharePoint farm. |
| New-SPWordConversionServiceApplication | Creates a new instance of a Word Automation Services application on the farm. |
| New-SPWorkManagementServiceApplication *New* | Creates a new Work Management Service application. |
| New-SPWorkManagementServiceApplicationProxy *New* | Creates a new service application proxy group. |
| Publish-SPServiceApplication | Shares the specified local service application outside the farm. |
| Register-SPAppPrincipal | Lets an on-premises or SharePoint Online administrator register an app principal. |
| Register-SPWorkflowService | Configures the SharePoint host to use a workflow service. |
| Remove-SPAccessServicesDatabaseServer *New* | Removes the specified database server. |
| Remove-SPAlternateUrl | Completely deletes the specified alternate URL. |
| Remove-SPAppDeniedEndpoint *New* | Removes an endpoint from the Apps denied endpoint list. |
| Remove-SPAppPrincipalPermission *New* | Removes the permissions on a specified app principal. |
| Remove-SPBusinessDataCatalogModel | Deletes a Business Data Connectivity Model. |
| Remove-SPClaimProvider | Unregisters a claim provider. |
| Remove-SPClaimTypeMapping | Deletes a claim type mapping rule for a security token service (STS) identity provider. |
| Remove-SPConfigurationDatabase | Permanently removes a configuration database. |
| Remove-SPContentDatabase | Deletes a content database. |
| Remove-SPContentDeploymentJob | Removes a content deployment job. |
| Remove-SPContentDeploymentPath | Removes a content deployment path. |
| Remove-SPDiagnosticsPerformanceCounter | Removes an instance of a performance counter. |
| Remove-SPDistributedCacheServiceInstance *New* | Removes an instance of the distributed cache service from a local server. |
| Remove-SPEnterpriseSearchComponent *New* | Removes the specified search component from the given search topology. |
| Remove-SPEnterpriseSearchContentEnrichmentConfiguration *New* | Removes the current content enrichment configuration from the search service application. |
| Remove-SPEnterpriseSearchCrawlContentSource | Deletes a specified crawl content source from a search application. |
| Remove-SPEnterpriseSearchCrawlCustomConnector | Removes a CustomConnector object. |
| Remove-SPEnterpriseSearchCrawlDatabase | Sets properties of a crawl database for a search service application. |
| Remove-SPEnterpriseSearchCrawlExtension | Removes a file name extension from the list of files that can be crawled. |
| Remove-SPEnterpriseSearchCrawlLogReadPermission *New* | Removes permission to view crawl log information. |
| Remove-SPEnterpriseSearchCrawlMapping | Deletes a crawl mapping. |
| Remove-SPEnterpriseSearchCrawlRule | Deletes a crawl rule. |
| Remove-SPEnterpriseSearchFileFormat *New* | Remove a previously registered file format from the system. |
| Remove-SPEnterpriseSearchLanguageResourcePhrase | Deletes a language resource phrase from a shared search application. |
| Remove-SPEnterpriseSearchLinksDatabase *New* | Deletes a links database. |
| Remove-SPEnterpriseSearchMetadataCategory | Deletes a crawled property category. |
| Remove-SPEnterpriseSearchMetadataManagedProperty | Deletes a metadata managed property. |
| Remove-SPEnterpriseSearchMetadataMapping | Deletes a metadata mapping from a managed property. |
| Remove-SPEnterpriseSearchQueryAuthority | Deletes an authoritative page. |
| Remove-SPEnterpriseSearchQueryDemoted | Deletes a demoted site rule. |
| Remove-SPEnterpriseSearchQueryKeyword | Deletes a query keyword. |
| Remove-SPEnterpriseSearchQueryScope | Deletes a query scope. |
| Remove-SPEnterpriseSearchQueryScopeRule | Deletes query results scope rules. |
| Remove-SPEnterpriseSearchRankingModel | Deletes a ranking model. |
| Remove-SPEnterpriseSearchResultItemType *New* | Creates a new result item type. |
| Remove-SPEnterpriseSearchSecurityTrimmer | Deletes a custom security trimmer. |
| Remove-SPEnterpriseSearchServiceApplication | Deletes a search service application. |
| Remove-SPEnterpriseSearchServiceApplicationProxy | Deletes a search service application proxy. |
| Remove-SPEnterpriseSearchServiceApplicationSiteSettings *New* | Cleans up search settings for a particular site collection, subscription, or search application |
| Remove-SPEnterpriseSearchSiteHitRule | Deletes a site hit rule. |
| Remove-SPEnterpriseSearchTenantConfiguration *New* | Removes all tenant specific search settings. |
| Remove-SPEnterpriseSearchTenantSchema *New* | Removes a defined search schema. |
| Remove-SPEnterpriseSearchTopology *New* | Removes an inactive search topology from a search service application. |
| Remove-SPExcelBlockedFileType | Removes an entry from the list of file types that are prevented from being loaded on Excel Services Application. |
| Remove-SPExcelDataConnectionLibrary | Removes a data connection library from Excel Services Application. |
| Remove-SPExcelDataProvider | Removes a data provider from Excel Services Application. |
| Remove-SPExcelFileLocation | Removes a trusted file location from Excel Services Application. |
| Remove-SPExcelUserDefinedFunction | Removes a user-defined function from Excel Services Application. |
| Remove-SPInfoPathUserAgent | Removes a user agent. |
| Remove-SPManagedAccount | Removes a managed account registration from the farm. |
| Remove-SPManagedPath | Deletes the specified managed path from the specified host header or web application. |
| Remove-SPODataConnectionSetting *New* | Removes a Business Connectivity Services connection. |
| Remove-SPPerformancePointServiceApplication | Deletes a PerformancePoint Services application from a farm. |
| Remove-SPPerformancePointServiceApplicationProxy | Deletes the proxy for a PerformancePoint Services application. |
| Remove-SPPerformancePointServiceApplicationTrustedLocation | Removes a single trusted location from a PerformancePoint Services application. |
| Remove-SPProfileLeader | Remove a company leader. |
| Remove-SPRoutingMachineInfo *New* | Removes an external routing target. |
| Remove-SPRoutingMachinePool *New* | Removes a routing pool from Request Manager. |
| Remove-SPRoutingRule *New* | Removes a routing rule. |
| Remove-SPScaleOutDatabase *New* | Removes a specific scale-out database. |
| Remove-SPSecureStoreApplication | Deletes a Secure Store application. |
| Remove-SPSecureStoreSystemAccount *New* | Removes a user account from a designated list. |
| Remove-SPServerScaleOutDatabase *New* | Removes a specific scale-out database. |
| Remove-SPServiceApplication | Deletes the specified service application on the local server. |
| Remove-SPServiceApplicationPool | Completely deletes the specified Web service application pool. |
| Remove-SPServiceApplicationProxy | Deletes the specified service application proxy. |
| Remove-SPServiceApplicationProxyGroup | Completely deletes the specified service application proxy group. |
| Remove-SPServiceApplicationProxyGroupMember | Removes one or more proxies from the specified service application proxy group. |
| Remove-SPShellAdmin | Removes a user from the SharePoint_Shell_Access role. |
| Remove-SPSite | Completely deletes an existing site collection and all subsites. |
| Remove-SPSiteSubscription | Removes data stored in a subscription settings service application for a set of site subscriptions. |
| Remove-SPSiteSubscriptionBusinessDataCatalogConfig | Removes the Business Data Connectivity Metadata Store for a partition. |
| Remove-SPSiteSubscriptionFeaturePack | Removes a SharePoint feature set from a site subscription. |
| Remove-SPSiteSubscriptionFeaturePackMember | Removes a feature definition from the provided SharePoint feature set. |
| Remove-SPSiteSubscriptionMetadataConfig | Removes site subscription configuration settings. |
| Remove-SPSiteSubscriptionProfileConfig | Deletes a site subscription from a User Profile Service application. |
| Remove-SPSiteSubscriptionSettings | Removes the settings service data for a specified site subscription, or finds and removes orphaned data. |
| Remove-SPSiteUpgradeSessionInfo *New* | Removes an SPSite object from upgrade. |
| Remove-SPSiteUrl *New* | Removes an URL mapping from the site. |
| Remove-SPSocialAppPermissions *New* | Do not use this cmdlet. |
| Remove-SPSocialItemByDate | Deletes tags, notes, or ratings. |
| Remove-SPSolution | Removes a SharePoint solution from a farm. |
| Remove-SPSolutionDeploymentLock | Removes the solution deployment lock for a server. |
| Remove-SPStateServiceDatabase | Removes a state service database from a state service application and drops it from the SQL Server |
| Remove-SPThrottlingRule *New* | Removes a throttling rule. |
| Remove-SPTranslationServiceJobHistory *New* | Removes Machine Translation service jobs. |
| Remove-SPTrustedIdentityTokenIssuer | Deletes a security token service (STS) identity provider from the farm. |
| Remove-SPTrustedRootAuthority | Deletes a trusted root authority. |
| Remove-SPTrustedSecurityTokenIssuer *New* | Removes the trusted security token service object. |
| Remove-SPTrustedServiceTokenIssuer | Deletes the object that represents the farm trust. |
| Remove-SPUsageApplication | Removes a usage application from the local farm. |
| Remove-SPUser | Removes a user from a web site. |
| Remove-SPUserLicenseMapping *New* | Removes a claim-to-SharePoint user license mapping. |
| Remove-SPUserSolution | Removes a sandboxed solution from the solution gallery. |
| Remove-SPVisioSafeDataProvider | Removes a data provider from a Visio Services application. |
| Remove-SPWeb | Completely deletes the specified web. |
| Remove-SPWebApplication | Deletes the specified web application. |
| Remove-SPWOPIBinding *New* | Removes bindings for applications, file name extensions, and their associated actions on the current SharePoint farm where this cmdlet is run. |
| Remove-SPWOPISuppressionSetting *New* | Removes the suppression settings for a file type or program ID (ProgID) on the current SharePoint farm where this cmdlet is run. |
| Remove-SPWordConversionServiceJobHistory | Removes entries from the Word Automation Services job history database. |
| Rename-SPServer | Renames a server that is currently connected to the farm. |
| Repair-SPManagedAccountDeployment | Repairs the local managed account credential deployment. |
| Repair-SPSite | Activates the RunRepairs method against the referenced SPSite object. |
| Request-SPUpgradeEvaluationSite *New* | Requests an upgrade evaluation site for a specified site. |
| Reset-SPAccessServicesDatabasePassword *New* | Resets the passwords for all logons for user application databases. |
| Restart-SPAppInstanceJobs *New* | Restarts an app instance. |
| Restore-SPEnterpriseSearchServiceApplication | Restores a third-party backup of a search application. |
| Restore-SPEnterpriseSearchServiceApplicationIndex *New* | Restores the search index from the specified backup files. |
| Restore-SPFarm | Restores one or more items from a backup. |
| Restore-SPSite | Restores a site collection. |
| Resume-SPEnterpriseSearchServiceApplication | Resumes a search service application that was suspended. |
| Resume-SPStateServiceDatabase | Resumes a paused state service database so that new rows of data are received |
| Revoke-SPBusinessDataCatalogMetadataObject | Revokes a right to a principal in the specified Business Data Connectivity Metadata Store metadata object. |
| Revoke-SPObjectSecurity | Removes a security principal from a SPObjectSecurity object. |
| Set-SPAccessServicesApplication *New* | Sets global properties of an existing Access Services application in SharePoint Server 2013. |
| Set-SPAccessServicesDatabaseServer *New* | Specifies whether or not a database in SQL Server is available. |
| Set-SPAccessServicesDatabaseServerGroupMapping *New* | Sets server group mappings. |
| Set-SPAccessServiceApplication | Sets global properties of an existing Access Services application. |
| Set-SPAlternateUrl | Configures the specified alternate URL. |
| Set-SPAppAcquisitionConfiguration *New* | Sets app acquisition settings. |
| Set-SPAppAutoProvisionConnection *New* | Sets provision connection settings for an app. |
| Set-SPAppDisablingConfiguration *New* | Sets the disable list sync state for an app. |
| Set-SPAppDomain *New* | Sets the domain used to host Apps. |
| Set-SPAppHostingQuotaConfiguration *New* | Sets hosting quotas for an app. |
| Set-SPAppManagementDeploymentId *New* | Sets the identifier of the farm or tenant used by the Office Marketplace to issue App licenses. |
| Set-SPAppStoreConfiguration *New* | Sets SharePoint Store settings for an app. |
| Set-SPAppPrincipalPermission *New* | Sets the permissions on a given app principal. |
| Set-SPAppScaleProfile *New* | Sets settings for the app profile. |
| Set-SPAppSiteSubscriptionName *New* | Sets or changes the name for the specified site subscription. |
| Set-SPAppDisablingConfiguration *New* | Sets the disable list sync state for an app. |
| Set-SPAppStateUpdateInterval *New* | Sets the interval in hours between updates of the app state update job. |
| Set-SPAuthenticationRealm *New* | Sets the authentication realm. |
| Set-SPBingMapskey *New* | Sets the Bing Maps key. |
| Set-SPBrowserCustomerExperienceImprovementProgram | Turns on or off the browser Customer Experience Improvement Program. |
| Set-SPBusinessDataCatalogEntityNotificationWeb | Sets the entity notification site. |
| Set-SPBusinessDataCatalogMetadataObject | Sets the value of a property or attribute of a Business Data Connectivity Metadata Store metadata object. |
| Set-SPBusinessDataCatalogServiceApplication | Sets global properties for a Business Data Connectivity service application in the farm. |
| Set-SPBusinessDataCatalogThrottleConfig | Sets the throttling configuration for a Business Data Connectivity Service application. |
| Set-SPCentralAdministration | Sets the port for the SharePoint Central Administration web site. |
| Set-SPClaimProvider | Updates registration of a claims provider. |
| Set-SPContentDatabase | Sets global properties of a SharePoint content database. |
| Set-SPContentDeploymentJob | Sets properties of a content deployment job. |
| Set-SPContentDeploymentPath | Sets properties of a content deployment path. |
| Set-SPCustomLayoutsPage | Maps a new path for a custom layout page. |
| Set-SPDataConnectionFile | Sets properties of a data connection file. |
| Set-SPDesignerSettings | Sets SharePoint Designer 2013 features. |
| Set-SPDiagnosticConfig | Sets diagnostic configuration settings on the farm. |
| Set-SPDiagnosticsProvider | Enables a diagnostics provider and updates its retention policy. |
| Set-SPDistributedCacheClientSetting | Sets distributed cache settings. |
| Set-SPEnterpriseSearchContentEnrichmentConfiguration *New* | Stores the specified content enrichment configuration to the search service application. |
| Set-SPEnterpriseSearchCrawlContentSource | Sets the properties of a crawl content source for a shared search application. |
| Set-SPEnterpriseSearchCrawlDatabase | Sets properties of a crawl database for a search service application. |
| Set-SPEnterpriseSearchCrawlLogReadPermission *New* | Grants users permission to view the crawl log information. |
| Set-SPEnterpriseSearchCrawlRule | Sets properties for a crawl rule. |
| Set-SPEnterpriseSearchFileFormatState | Enables or disables parsing of a given file format. |
| Set-SPEnterpriseSearchLinguisticComponentsStatus *New* | Sets the operation status of the linguistic query and document processing components. |
| Set-SPEnterpriseSearchLinksDatabase *New* | Sets properties of a links database for a search service application. |
| Set-SPEnterpriseSearchMetadataCategory | Sets properties of a crawled property category for a shared search application. |
| Set-SPEnterpriseSearchMetadataCrawledProperty | Sets the properties of a metadata crawled property for a shared search application. |
| Set-SPEnterpriseSearchMetadataManagedProperty | Sets the properties of a metadata managed property. |
| Set-SPEnterpriseSearchMetadataMapping | Sets the properties of a managed property mapping for a shared search application. |
| Set-SPEnterpriseSearchPrimaryHostController *New* | Sets the primary search host controller for the farm. |
| Set-SPEnterpriseSearchQueryAuthority | Sets the properties of an authoritative page for a shared search application. |
| Set-SPEnterpriseSearchQueryKeyword | Sets the properties of a keyword term for a shared search application. |
| Set-SPEnterpriseSearchQueryScope | Sets the properties of a query results scope for a shared search application. |
| Set-SPEnterpriseSearchQueryScopeRule | Sets the properties of a shared scope rule for a query scope. |
| Set-SPEnterpriseSearchQuerySpellingCorrection *New* | Sets the operation status of the Query Spelling Corrections (QSC) component. |
| Set-SPEnterpriseSearchRankingModel | Sets the properties of a ranking model for a shared search application. |
| Set-SPEnterpriseSearchResultItemType *New* | Sets properties of a result item type. |
| Set-SPEnterpriseSearchService | Sets the properties of a search service for a farm. |
| Set-SPEnterpriseSearchServiceApplication | Sets the properties of a search service application for a farm. |
| Set-SPEnterpriseSearchServiceApplicationProxy | Sets properties of a search service application proxy. |
| Set-SPEnterpriseSearchServiceInstance | Sets the properties of a search service instance. |
| Set-SPEnterpriseSearchTopology *New* | Activates a given search topology. |
| Set-SPExcelDataConnectionLibrary | Sets properties of a data connection library for Excel Services Application. |
| Set-SPExcelDataProvider | Sets properties of a safe data provider for Excel Services Application. |
| Set-SPExcelFileLocation | Sets properties of a trusted file location for Excel Services Application. |
| Set-SPExcelServiceApplication | Sets global properties for Excel Services Application. |
| Set-SPExcelUserDefinedFunction | Sets properties of a user-defined function in Excel Services Application. |
| Set-SPFarmConfig | Sets a global property or a collection of global properties for the local farm. |
| Set-SPInfoPathFormsService | Sets parameters for InfoPath Forms Services in SharePoint Server 2013. |
| Set-SPInfoPathFormTemplate | Sets properties of an InfoPath 2013 form template. |
| Set-SPInfoPathWebServiceProxy | Sets parameters for an existing SharePoint Web service application. |
| Set-SPInternalAppStateUpdateInterval *New* | Sets the interval in hours between updates of the internal app state update job. |
| Set-SPIRMSettings *New* | Sets the Information Rights Management (IRM) settings. |
| Set-SPLogLevel | Sets the trace and event level for a set of categories. |
| Set-SPManagedAccount | Configures the managed account. |
| Set-SPMarketplaceConnectionSettings | Sets SharePoint Store connection settings. |
| Set-SPMetadataServiceApplication | Sets the properties for a metadata service application. |
| Set-SPMetadataServiceApplicationProxy | Sets the properties for a metadata service application proxy. |
| Set-SPMobileMessagingAccount | Configures the specified mobile messaging account. |
| Set-SPODataConnectionSetting *New* | Sets or updates global properties for a Microsoft Business Connectivity Services connection. |
| Set-SPODataConnectionSettingMetaData *New* | Updates properties for the metadata of a Business Connectivity Services connection. |
| Set-SPOfficeStoreAppsDefaultActivation *New* | Sets the properties of apps for Office. |
| Set-SPPassPhrase | Sets the passphrase to a new value. |
| Set-SPPerformancePointSecureDataValues | Sets global settings for the unattended service account. |
| Set-SPPerformancePointServiceApplication | Sets global run-time properties for a PerformancePoint Services application. |
| Set-SPPowerPointConversionServiceApplication | Configures settings for a PowerPoint Conversion Service application. |
| Set-SPProfileServiceApplication | Sets properties of a User Profile Service application. |
| Set-SPProfileServiceApplicationProxy | Sets properties of a proxy for a User Profile Service application. |
| Set-SPProfileServiceApplicationSecurity | Sets permission and identity information. |
| Set-SPRequestManagementSettings *New* | Sets Request Manager properties. |
| Set-SPRoutingMachineInfo *New* | Sets routing target properties. |
| Set-SPRoutingMachinePool *New* | Sets properties of a machine pool. |
| Set-SPRoutingRule *New* | Changes properties of an existing routing rule. |
| Set-SPScaleOutDatabaseDataRange *New* | Extends the range of a specified scale-out database. |
| Set-SPScaleOutDatabaseDataSubRange *New* | Creates a subrange for a specified scale-out database. |
| Set-SPSecureStoreApplication | Sets properties of a Secure Store application. |
| Set-SPSecureStoreDefaultProvider | Sets or updates the secure store provider. |
| Set-SPSecureStoreServiceApplication | Sets properties of a Secure Store Service application in the farm. |
| Set-SPSecurityTokenServiceConfig | Updates the settings of the SharePoint security token service (STS) identity provider. |
| Set-SPServerScaleOutDatabaseDataRange *New* | Extends the range of a specified scale-out database. |
| Set-SPServerScaleOutDatabaseDataSubRange *New* | Creates a subrange for a specified scale-out database. |
| Set-SPServiceApplication | Sets properties of a service application. |
| Set-SPServiceApplicationEndpoint | Sets the host of an endpoint for a service application. |
| Set-SPServiceApplicationPool | Changes the account used for the Identity of the specified application pool. |
| Set-SPServiceApplicationSecurity | Updates the SPObjectSecurity object for a service application. |
| Set-SPServiceHostConfig | Configures one or more common settings for all Web services. |
| Set-SPSessionStateService | Updates the credentials that are used to communicate with the state service database |
| Set-SPSite | Configures the specified site collection. |
| Set-SPSiteAdministration | Allows farm administrators to configure any site collection. |
| Set-SPSiteSubscriptionConfig | Sets the configuration properties of a site subscription. |
| Set-SPSiteSubscriptionEdiscoveryHub | Sets properties for the eDiscovery hub of a site subscription. |
| Set-SPSiteSubscriptionIRMConfig *New* | Sets the Information Rights Management (IRM) settings. |
| Set-SPSiteSubscriptionMetadataConfig | Sets the site subscription configuration settings for a specified metadata service application. |
| Set-SPSiteSubscriptionProfileConfig | Sets the parameters of a site subscription. |
| Set-SPSiteUrl *New* | Adds or changes an URL mapping for the site. |
| Set-SPStateServiceApplication | Updates the name of a state service application |
| Set-SPStateServiceApplicationProxy | Updates the name of a state service application proxy |
| Set-SPStateServiceDatabase | Updates properties of a state service database |
| Set-SPSubscriptionSettingsServiceApplication | Sets properties of a subscription settings service application. |
| Set-SPThrottlingRule *New* | Changes properties of an existing throttling rule. |
| Set-SPTimerJob | Sets the schedule for running a timer job. |
| Set-SPTopologyServiceApplication | Sets the properties on the topology service application of the local farm. |
| Set-SPTopologyServiceApplicationProxy | Sets the proxy properties of the topology service application. |
| Set-SPTranslationServiceApplication *New* | Sets property settings on a Machine Translation service application. |
| Set-SPTranslationServiceApplicationProxy *New* | Sets properties to the Machine Translation service application proxy. |
| Set-SPTrustedIdentityTokenIssuer | Sets the identity providers of a web application. |
| Set-SPTrustedRootAuthority | Creates a new trusted root authority. |
| Set-SPTrustedSecurityTokenIssuer *New* | Sets the trusted token issuer. |
| Set-SPTrustedServiceTokenIssuer | Updates a trust with the farm. |
| Set-SPUsageApplication | Sets properties of a usage application. |
| Set-SPUsageDefinition | Sets the retention period for a usage provider. |
| Set-SPUsageService | Sets the properties of a usage service. |
| Set-SPUser | Configures properties on an existing user. |
| Set-SPVisioExternalData | Configures settings related to external data connections for a Visio Services application. |
| Set-SPVisioPerformance | Sets performance properties for a Visio Services application. |
| Set-SPVisioSafeDataProvider | Specifies a description of a safe data provider for a Visio Services application. |
| Set-SPVisioServiceApplication | Sets the ServiceApplicationPool property for a Visio Services application. |
| Set-SPWeb | Configures the specified subsite. |
| Set-SPWebApplication | Configures the specified web application. |
| Set-SPWebApplicationHttpThrottlingMonitor | Sets the Health Score bucket values for an existing network throttling performance counter for a specified web application. |
| Set-SPWOPIBinding *New* | Updates the default click action for an application or file name extension binding. |
| Set-SPWOPIZone *New* | Configures the zone that the current SharePoint farm will use to navigate the browser to the WOPI application. |
| Set-SPWordConversionServiceApplication | Sets properties of a Word Automation Services application. |
| Set-SPWorkflowConfig | Configures the workflow settings for the specified web application. |
| Set-SPWorkManagementServiceApplication *New* | Sets settings for the Work Management Service application. |
| Set-SPWorkManagementServiceApplicationProxy *New* | Sets the settings for the Work Management Service application proxy. |
| Split-SPScaleOutDatabase *New* | Moves a specified percentage of partitions from one scale-out database to another. |
| Split-SPServerScaleOutDatabase *New* | Moves a specified percentage of partitions from one scale-out database to another. |
| Start-SPAdminJob | Immediately starts any waiting administrative job on the local computer. |
| Start-SPAssignment | Initiates a new assignment store. |
| Start-SPContentDeploymentJob | Starts a content deployment job. |
| Start-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance | Starts an instance of a search manager service. |
| Start-SPEnterpriseSearchServiceInstance | Starts an instance of a search service. |
| Start-SPInfoPathFormTemplate | Activates a previously quiesced InfoPath 2013 form template. |
| Start-SPServiceInstance | Starts the service instance for a service on a specific server or the farm. |
| Start-SPTimerJob | Runs a timer job once. |
| Stop-SPAssignment | Disposes of objects in the provided assignment collection. |
| Start-SPDiagnosticsSession *New* | Reports diagnostic information to the usage database. |
| Stop-SPDiagnosticsSession *New* | Stops the diagnostics session. |
| Stop-SPDistributedCacheServiceInstance *New* | Stops an instance of the distributed cache service on a local server. |
| Stop-SPEnterpriseSearchQueryAndSiteSettingsServiceInstance | Stops an instance of a search manager service. |
| Stop-SPEnterpriseSearchServiceInstance | Stops an instance of a search manager service. |
| Stop-SPInfoPathFormTemplate | Disables an InfoPath 2013 form template on a farm before an upgrade. |
| Stop-SPServiceInstance | Stops the service instance for a service. |
| Suspend-SPEnterpriseSearchServiceApplication | Suspends a search service application, pausing all crawls and search operations, to perform a task such as system maintenance. |
| Suspend-SPEnterpriseSearchServiceApplication | Suspends a search service application, pausing all crawls and search operations, to perform a task such as system maintenance. |
| Suspend-SPStateServiceDatabase | Pauses a state database and thus prevents new rows of data from being added to a database |
| Test-SPContentDatabase | Tests a content database. |
| Test-SPInfoPathFormTemplate | Validates that an InfoPath 2013 form template is browser-enabled. |
| Test-SPSite *New* | Activates the RunTests method against a referenced SPSite object. |
| Uninstall-SPAppInstance *New* | Uninstalls an instance of an app. |
| Uninstall-SPDataConnectionFile | Removes a data connection file. |
| Uninstall-SPFeature | Uninstalls an installed feature definition. |
| Uninstall-SPHelpCollection | Removes Help collection files. |
| Uninstall-SPInfoPathFormTemplate | Removes an InfoPath 2013 form template from a farm. |
| Uninstall-SPSolution | Retracts a deployed SharePoint solution. |
| Uninstall-SPUserSolution | Deactivates a sandboxed solution in a site collection. |
| Uninstall-SPWebPartPack | Uninstalls the specified Web Part package. |
| Unpublish-SPServiceApplication | Stops sharing the specified service application outside the farm. |
| Update-SPAppCatalogSettings *New* | Sets a specific site collection as the App Catalog site collection. |
| Update-SPAppInstance *New* | Updates the app instance. |
| Update-SPFarmEncryptionKey | Changes the value of the farm encryption key and, using the new key, re-encrypts all the data. |
| Update-SPInfoPathAdminFileUrl | Updates InfoPath 2013 form templates (.xsn files) and universal data connections (.udcx files), including all .xsn files and .udcx files that were deployed by an administrator. |
| Update-SPInfoPathUserFileUrl | Updates InfoPath form templates (.xsn files) and universal data connections (.udcx files). |
| Update-SPProfilePhotoStore | Updates the profile photo store to be compatible with SharePoint 2013 |
| Update-SPRepopulateMicroblogFeedCache *New* | Refreshes the cache. |
| Update-SPRepopulateMicroblogLMTCache *New* | Refreshes the cache. |
| Update-SPSecureStoreApplicationServerKey | Synchronizes the key on a server running SharePoint Server by using the Secure Store master key. |
| Update-SPSecureStoreCredentialMapping | Sets a new credential mapping for a Secure Store Service application. |
| Update-SPSecureStoreGroupCredentialMapping | Sets a new group credential mapping for a Secure Store Service application. |
| Update-SPSecureStoreMasterKey | Changes the master key of a Secure Store Service application. |
| Update-SPSolution | Upgrades a deployed SharePoint solution. |
| Update-SPUserSolution | Upgrades an activated sandboxed solution in a farm. |
| Update-SPWOPIProofKey *New* | Updates the public key that is used to connect to the WOPI application on the current SharePoint farm where this cmdlet is run. |
| Upgrade-SPContentDatabase | Upgrades a content database. |
| Upgrade-SPEnterpriseSearchServiceApplication | Upgrades a search service application. |
| Upgrade-SPEnterpriseSearchServiceApplicationSiteSettings *New* | Upgrades search settings for a particular site collection |
| Upgrade-SPFarm | Activates the Upgrade method for the local farm. |
| Upgrade-SPSingleSignOnDatabase | Migrates the application definitions from single sign-on (SSO) database to Secure Store database as target applications. |
| Upgrade-SPSite | Starts the upgrade process on a site collection. |
Resources and Recognitions
Thanks to:
Mattias Gutke for all the support, help, ideas and for always beeing my second opinion.
Niklas Goude Always helpful and all-knowing when it comes to PowerShell.
Herakles for the help with Kerberos
References:
Index of Windows PowerShell for SharePoint Online cmdlets
http://technet.microsoft.com/en-us/library/fp161364.aspx
Index of Windows PowerShell cmdlets for SharePoint 2013
http://technet.microsoft.com/en-us/library/ff678226.aspx
Introduction to the SharePoint Online management Shell
http://technet.microsoft.com/en-us/library/fp161388.aspx
Set up the SharePoint Online Management Shell Windows PowerShell environment
http://technet.microsoft.com/en-us/library/fp161372.aspx
___________________________________________________________________________________________________
Enjoy!
Regards
SharePoint 2013 feature comparison chart all editions
Did you ever see such a pretty table before..? Which one to pick?? This has to be one of the harder choices in Life…
(Sugarrush central at Newark Liberty International Airport – New Jersey)
The feature list of SharePoint gets longer and longer, richer and richer, this is the (as far as I know) complete list of features in the three different versions of SharePoint 2013 on-premise (not SharePoint online):
SharePoint Foundation 2013 | SharePoint Server 2013 Standard Edition | SharePoint Server 2013 Enterprise Edition.
To save you all a few ‘swipes’ or ‘rolls’ on the old mouse wheel, I have also added a menu here at the top, click on any of the focus areas to jump right in.
| Note: If you are only looking to find whats only available in the Enterprise edition, you can get that list alone here with extended information: Enterprise edition of SharePoint Server 2013 – What’s in it?. |
| Menu |
| Developer features |
| IT Professional features |
| Content features |
| Insights features |
| Search features |
| Sites features |
| Social features |
| Credit and references |
| Note: Purple YES equals a Enterprise only feature. |
1 Requires connection to Office Web Apps Server 2013 and an Office desktop suite license, such as Office Professional Plus or Office Standard.
2 Requires connection to Microsoft Exchange Server or Microsoft Exchange Online to enable integrated features
3 Requires SharePoint Server 2013, Standard or Enterprise edition. This feature is not available to Foundation as stated in some TechNet articles.
Thanks to:
Mattias Gutke for all the support, help, ideas and for Always beeing my second opinion. A link sent from him gave me the idea for this post.
References:
SharePoint Online
http://technet.microsoft.com/en-us/library/jj819267.aspx
Discontinued features and modified functionality in Microsoft SharePoint 2013
http://go.microsoft.com/fwlink/p/?LinkId=275764
Changes from SharePoint 2010 to SharePoint 2013
http://technet.microsoft.com/en-us/library/ff607742(v=office.15).aspx
Create and configure Machine Translation services in SharePoint Server 2013
http://technet.microsoft.com/en-us/library/jj553772.aspx
(…and yes, I would personally go with Ben & Jerrys…)
![]()
___________________________________________________________________________________________________
Enjoy!
Regards
A guide to https and Secure Sockets Layer in SharePoint 2013
Hi dear friends!
It has become something of a habit of mine, to jump over the tougher more difficult topics, the ones that I have spent a lot of energy avoiding before. Kerberos must be the worst of them all, and since I feel that I have Kerberos pretty much covered, I know everything and I can do anything…
This topic is something that I always avoided doing myself as well, if in production or in the lab, since certificates are difficult to understand and hard to come by for tests, I never got to try it much and thus it stayed a bit of a grey area for long.
But no more, by publishing this guide, I hope that I and you can all get over the fear of https/SSL together.
This guide is also available as a whitepaper to download Here
(Skip all the bullshit yada yada and jump straight to the steps.)

This guide was created far from the ultrafast fibreoptic gigabit internet Connections
One important thing to remember though, this guide is only meant to be used in test or lab, it is not recommended to use exactly this setup in production. If you are looking to setup https in production, then you should have a certificate issued by your own Certificate Authority or have one bought from a trusted certificate issuer such as Verisign for example. I don’t know all the downsides, but for one, you cannot revoke a self-signed cert.
My requirements for https in testing are these:
- They should look and behave the same as it would in production
- It should be a real DNS URL or a real URL added to the host file
- It should not cause any red warnings in the browser
- IIS and SharePoint must be configured the same way as if it were a real life scenario
How do we do this? Let me show you how I would do it…
First we need a proper environment, in my setup I have:
- A single SharePoint 2013 server on Windows Server 2012 running all roles but the DB.
- A SQL server 2008 R2 on Windows Server 2008 R2 (OS here is irrelevant)
- A Windows Server 2012 DNS server
- A Windows Server 2012 Domain Controller (Any DC will do…)
- A Windows 7 client with Internet Explorer 9. (Most common customer setup, works from the server as well with loopback check disabled)
I am also using a utility from the IIS 6.0 Resource kit, download that before we start from this link: Download IIS 6.0 Resource Kit
In order for https / SSL and SharePoint to work we need a few things, lets add it all up in a checklist:
- A Web Application with a root site already created
- A URL (FQDN preferred)
- A DNS entry to go with the URL
- A Self-signed Certificate (or from a trusted issuer)
- AAM
- IIS Binding
- Certificate added to trusted authority on the client/server
- URL added to the local intranet zone in Internet Explorer for auto-logon
In my example, I will use the following:
| Requirement | In my test environment |
| - A URL (FQDN preferred) | sharepoint2013.corp.balkestahl.se |
| - A DNS entry to go with the URL | sharepoint2013.corp.balkestahl.se -> 192.168.1.130 |
| - A Certificate (Self signed or from a trusted issuer) | Certificate created using the IIS 6.0 RK utility SelfSSL. |
| - AAM | Internal http and https, Public https only |
| - IIS Binding | Bind my site to https and all IP using the created certificate |
-
-
These are the steps we need to take (click on any link):
1. Create a new Web Application or use an existing one (use port 80 initially and not https/443 for this guide.)
2. DNS, create an A-Record
3. Create the certificate (or request, buy, get any way you choose the real deal)
4. Add IIS Binding with Host-Header (this has to be done manually)
5. AAM, Add the necessary Alternate Access Mappings
6. Add the certificate to the Trusted Certificate store on the client
7. Test functionality
8. T-Shooting
9. References and recognitions
| Note: If there is something that I have missed in this guide, or that should be done differently, please let me know. I will reply to any comment and feedback that you submit. |
1. Web Application
This step can be skipped completely if you already have a working Web Application with http on port 80 with an existing Site Collection.
If you do not have that or don’t feel Confident that it will be adequate, follow these simple steps.
1.1 In Central Admin, go to Application Management, then Manage Web Applications, in the ribbon, click on new, fill in the form using your own values.
| Note: The Name value is what the Web Application will be shown as in CA and in IIS. |
1.2 Note that I have not chosen to use SSL here, this will be added at a later time. Leave these choices as default.
1.3 The http url for this web application. As we set this up initially on port 80 and using http only, this could be anything, I have chosen to use the same FQDN as my https address will use.
Leave all other settings as is, the default values will do just fine for this test. The default is in 2013 using claims as authentication provider and this will serve our goal well.
I will not show you step by step how to create a Site Collection in the Web Application, something that you must do in order for the browser to later access the URL. But the steps are something like this:
1.4 Create a new Site Collection: In Central Admin select Application Management
1.5 Under Site Collections section, click on Create Site Collection.
1.6 In the dropdown, select the proper Web Application.
1.7 Enter a Name, Address and Description.
1.8 If only for test, use the Team site template under the Collaboration tab.
1.9 Add yourself as a site Collection administrator, or the account that will test access from a client, or add both in the primary and secondary fields.
1.10 Click OK. Wait until it has been created. Done!
Back to main menu
-
-
-
2. DNS
2.1 On your Windows Server 2012 running the DNS service, start server manager, then click on Tools and select DNS:
2.2 Locate the forward lookup zone for your domain:
2.3 Right click the zone and select New Host (A or AAAA)…
2.4 Enter the name of your site, this together with the full domain path will form the FQDN, Fully Qualified Domain Name. In the IP address field you enter the IP address of the SharePoint web server:
2.5 Click on Add Host and then Done, when you see this and verify that the FQDN shown is correct, you are done with the DNS part.
In my test setup, I will create my own certificate but use a properly named one, this makes it feel more like the real thing. If you have not already done so, download and install the IIS 6.0 Resource kit that comes with the nifty little util called SelfSLL. This allows you to create a self-signed certificate that has a proper URL, a requirement if you want to avoid the red warning in the browser that a regular self-signed cert would give you. The RK can be downloaded here: Download IIS 6.0 Resource Kit
Content of the IIS 6.0 Resource Kit - the following tools are available in this package:
- IIS 6.0 Migration Tool Version 1.0 Version 1.1 Now Available!
- Apache to IIS 6.0 Migration Tool Version 1.0
- CustomAuth Version 1.0
- IISCertDeploy.vbs Version 1.0
- IIS Host Helper Service Version 1.0
- IISState Version 3.0
- Log Parser Version 2.1 Version 2.2 Now Available!
- Metabase Explorer Version 1.6
- Permissions Verifier Version 1.0
- RemapUrl Version 1.0
- SelfSSL Version 1.0
- TinyGet Version 5.2
- Web Capacity Analysis Tool Version 5.2
- WFetch Version 1.3
What we really want out of all this this time, is the small util called SelfSSL in bold. This little util allows you like I said before, to create a self-signed cert using an FQDN of choice. In my example, I want to use the URL: sharepoint2013.corp.balkestahl.se and have the cert created with the same URL. I’ll show you how step by step.
It’s really quite simple.
| Note: You might consider even in a lab Environment, to install your own Certificate Authority and issue your own private Certificates, the following links will be of help when doing that: Install the Certification Authority (Windows Server 2012) Install a Root Certification Authority (Windows Server 2008 R2) Active Directory Certificate Services Overview (Windows Server 2012) |
3.1 Run the tool from the start menu:
3.2 The command-line tool does not look much to the world:
| Note: You need to be logged on with an account that is a member of the local administrators Group in order to use this tool. |
It gives you some options and I’m not going to go into what can be done with this tool, I’ll just go with the default and create a certificate using the suggested settings with one exception, we need to use the proper site ID.
Every site in IIS gets an ID, this is in this case used to put the certificate in the correct place on the correct site.
3.3 Get the correct ID from IIS, open up the IIS Manager, in server manager, click on Tools and then on Internet Information Services Manager:
3.4 In Internet Information Services Manager, select your site:
3.5 On the right pane, near the bottom, click on Advanced Settings…:
3.6 In the next dialog, you will see a row called simply ID:
3.7 Select the number in the field and right click and copy:
3.8 Paste the ID after the /S: switch. You should also change the value for the /V: setting, this represents how many days the certificate will be valid, the default 7 is ok for me in a very temporary setup, but for longer test runs, make it 90 Days or so. If the certificate expires, you will get ugly warnings that the certificate has expired and that it is untrusted. Https wil still work but on probation…
Now you have all you need to proceed. Run the SelfSSL util and use the site ID but leave everything else default.
Answer yes to the question – Do you want to replace the SSL settings for site 724410038.
selfssl.exe /N:CN=SharePoint2013.corp.balkestahl.se /K:1024 /V:7 /S:724410038 /P:443
| Note: One option that could be useful, if you add the /T to the command the certificate will be added to the local Machines trusted authority certificates list. This makes it trusted in the servers browser. |
The certificate is now created and put into the personal store for this computer.
If you get an error here stating that the certificate could not be assigned to the site, then you most likely already have an instance of the same certificate name, locate any existence of the certificate and delete it. (See how later in the post under chapter 8. T-shooting)
Move on to Chapter 4 or go Back to main menu
In order for the web server, IIS, to recognize any incoming traffic and locate the proper site to direct it to, IIS uses Host header bindings. This is done so that you can have more than one site on port 80 in the same web server. The default site has a blank Host header binding which will in affect make it claim all incoming requests as its own.
SharePoint stops the Default Web Site so that does not affect us now, but we need to take care of our own IIS Web Site that in reality is our SharePoint Web Application.
What we have to do, is make our IIS Web Site answer to all incoming traffic with a host header of https and the FQDN created in Chapter 2. DNS - sharepoint2013.corp.balkestahl.se
4.1 Start by opening up your IIS manager, in Server Manager, click on tools and the on Internet Information Services (IIS) Manager:
4.2 Locate your Web Site:
4.3 In the right hand pane, locate Bindings:
4.4 What you see here is a list of the existing Bindings for this site, Type, Host Name, Port and IP address. If you have created the certificate using the SelfSSL util and added the ID of the Web Site, then you will most likely see at least two rows here (see 4.5).

4.5 This is what you will have if the SelfSSL successfully added the cert to the site using its ID:
If this is what you have, select the second row with the https/443 and click on Edit, then scroll down to step 4.11 in this guide.
4.6 Assuming that it was not added, we have to add the cert to the site. Click on Add.
4.7 In this dialog, we must first select the proper protocol, https. Use the dropdown:
4.8 Once you have selected https as the protocol, you will find that a new field appears. This is where you select the certificate to use.
4.9 Select the certificate created in Chapter 3. Create a Certificate, in my environment, that is the sharepoint2013.corp.balkestahl.se certificate listed.
4.10 Once selected, you can click on View to verify that it really is the correct certificate and that everything looks to be in order, click on OK.
4.11 Next we add the Host Name that this Binding will be matched on, same as the certificate name, sharepoint2013.corp.balkestahl.se, click OK.
4.12 Now you should see two rows in the bindings list for this Web Site. One for the initial http/80 and one for https/443. This is goOoOod!
4.13 Now click on Close and Close the IIS manager.
Move on to Chapter 5 or go Back to main menu
-
-
-
5. Alternate Access Mappings – AAM
In order for SharePoint to know how to handle the incoming requests for this new URL, we need to add/configure Alternate Access Mappings, this basically tells SharePoint how to handle all URLs. AAMs Control if SharePoint should do a redirect or a translation of the incoming address. AAMs can be configured from Central Administration and using PowerShell, I will in this guide use only CA.
5.1 Open up your Central Administration site and click on Configure Alternate Access Mappings located under the System Settings category.
This will show you all Alternate Access Mappings for all of your Web Applications in the farm. In the top right dropdown, click on Change Alternate Access Mapping Collection and select the correct Web Application.
Now, it will look like this:
5.2 Next thing we want to do, is to alter the existing Public URL so that it uses https instead of http. Since all else is ok, add the s…
5.3 Ok on that will give you this view, note that both the Internal URL and the Public URL has changed. This site is now only accessible by the https protocol. (Not entirely true, but true enough)
5.4 I always like to be able to type in the default http URL in my browser, and if the site uses https, be redirected automatically. This is rather easy to do in SharePoint, simply add an Internal URL using http and add it to the Default zone which will direct us to the Public URL using https. It may sound difficult but trust me, it just works.
| If you are interested in Learning more about Alternate Access Mappings and the inner workings, I have a free whitePaper published on the subject for 2010 Here and a basic post for 2013 Here. |
Anyways, click on the Add Internal URLs link and simply add the same URL using http, make sure that the default zone is selected.
-
| Note: The zones used in AAM has NO RELATION with the zones in Internet Explorer, they are named similar, but they have no connection whatsoever. |
5.5 Now the list should look like this, note that you have http and https on the left (incoming traffic) and only https on the right (target):
You are now done configuring your Alternate Access Mappings! Let’s move on to testing, start with Chapter 6.
Back to main menu
-
-
-
6. Add the Certificate to the Trusted Authorities store.
If we do nothing else from here, we will be able to access the site using https, but it will not be pretty…in order to mimic https using a ‘real’ certificate we need to also add the certificate to the trusted store. This will make the browser trust the cert as authentic and it will stop throwing us the errors.
| Note: If you are doing these tests on the server itself, you will need to disable the loopback check Before accessing the site, else it will fail. See Chapter 8. T-shooting for information on how to do this. |
6.1 Try it first, open a browser, type in the address of the https URL and hit enter. You will first see this warning. Click on Continue to this website.
6.2 This will lead to a login prompt. This is to be expected at this Point, login using your credentials that you have made site Collection admin or that have access to the site Collection.
6.3 Access! Yeay! or…no…hang on?! that’s not the way I pictured it…we don’t have access and we have a red certificate error. This is not what we want our users to see…
Two things cause this:
6.3.1. The White ribbon telling us that this is a secured browser comes from that the server in this case, has IE ESC – Internet Explorer Enhanced Security Configuration enabled.
If you are using a client like Windows 7 or 8, you will not see this but should actually see the site content.
To fix this, follow the steps in this blog post: How to disable IE Enhanced Security in Windows Server 2012 (Opens up in a new window)
6.3.2. The red Certificate error is there because the certificate comes from an untrusted source. This is as it should be, and can be fixed.
To fix this, keep reading…
6.4 There are several ways to add the certificate to the trusted store, I will show you the easiest of them all. Click on the Certificate Error to the right of the red shield symbol. This will show this:
6.5 It is all true what it says, except that nobody is trying to fool us…Click on View Certificates to show this dialog:
6.6 You can probably guess what the next step is going to be? Click on Install Certificate…
6.7 We want the certificate to be in the Computers store, select Local Machine and click Next.
6.8 Select Place all Certificates in the following store and hit the Browse button.
6.9 Now, locate the ‘Trusted Root Certification Authorities’ and make sure it is selected, click OK.
6.10 Verify that this is what you see as well. Click on OK.
6.11 Success! Try again to browse to the site, you should probably close the browser and start a new browser window.
6.12 Now we’re talking! that’s more like it, no red errors, no banner preventing us from loading the content…all is good, Life is GOOD!
| Note: On my own server, it simply took a while for the error to go away, the IE cache has a renewal cycle of 50 minutes, to force a renewal, press Ctrl F5. That should do it. |
Testing has really already been taken care of in Chapter 6, but if you did what I did and used the servers browser (not recommended in production) to test access, then you really should test from a client to get the proper feel for it.
Use the steps described in Chapter 6 on the client computer as well. The dialog may look a bit of, but it’s the same steps basically. Sample dialog:
You will get the Picture if you use the steps in Chapter 6. Once you see the image below in your browser, you are OK!
8. T-shooting
T-shooting scenarios covered so far:
- 8.1 Delete redundant certificates
- 8.2 Configure Loopback check
8.1 Delete redundant certificates
If adding the cert fail and you want to delete every copy, do this:
8.1.1 Press the start button, type Certificates…
8.1.2 Select Manage computer certificates.
8.1.3 This will open up the ‘Certificates Manager’//MMC Certificates Snap in. Locate the Personal, Certificates folder. In the content, either delete them both, or, find out which is the newer and delete the old one.
8.1.4 In the Certificate Details, you will see the Valid from timestamp, this is from when the certificate was created.
8.1.5 When you know which one to keep, delete the other, right click delete.
Done.
Back to main menu
8.2 Configure Loopback check.
| Note: Remember that the loopback check is a security feature that has been put there for a reason, it protects the server from a certain form of attacks. Disabling it will open up the server for such attacks. Read Spencer Harbars post at the link below for a deeper understanding of this concept. |
Are you planning to do one of two things on your SharePoint server, then you need to configure this, configure, not necessarily disable it.
- If you have search on the server and the Content source Points to the server itself using an FQDN.
- If you want to use the servers browser to test functionality or to access CA using an FQDN. (This is us in this guide…)
| Note: I strongly recommend against using any browser on any server! It is a security risk since use of the browser opens up new ways for unwanted code to enter the server. Always access the server from a client browser! I use the servers browser in my lab to make it easier, but it is a contained lab environment and the accounts used do not have access to anything outside this particular lab environment. furthermore, the lab environment cannot be reached from outside nor can it access the Internet. (Thanks Anders Janson, UAG/TMG/Security expert at Enfo Zipper for great feedback!) |
Two links will tell you all you need to know:
8.2.1 DisableLoopbackCheck & SharePoint: What every admin and developer should know. (Spencer Harbar explains it all)
8.2.2 http://support.microsoft.com/kb/896861 (the best KB out there, it is old but still relevant)
Done
-
-
9. Resources and Recognitions
Don’t know who the author is, but this article gave me the last piece in the https puzzle.
How to Create a Self Signed Certificate in IIS 7
My thanks to the following individuals who have in different ways helped me in my ambitions to create these guides on difficult subjects for SharePoint:
Anders Janson (Enfo Zipper) Thanks Anders for very good and constructive feedback!
Hasain Alshakarti (TrueSec) Blog
Mattias Gutke (Enfo Zipper)
Anders Grönlund (Enfo Sweden)
Andrija Marcic (Microsoft)
Mattias Karlsson (Microsoft)
Herakles (Unknown)
![]()
___________________________________________________________________________________________________
Enjoy!
Regards
Activate selected languages on all subsites using Powershell
Hi friends.
If you ever find yourself wanting to enable a particular language or set of languages on a site Collection and all subsites, and if you do NOT want to enable all languages installed but rather Control what gets enabled? Here is a scripot that will help you.
In my own scenario I had 4 site Collections, each tageted for a different nordic country, Sweden, Norway, Finland and Denmark. So, the need is to have enabled English for all and only the countrys language for the 4 site Collections.
Looking for an existing sample code to use, I found many that were copies of the MSDN sample, this is a good piece of code but it enables all languages installed.
So, trying to find a clever way of selecting what language got enabled, I found an old script I created for the same customer, the solution was so simple it works!
While iterating thru all the installed languages, site by site, I check the displayname of the Language and add criteria fro the languages to install. Beautifully simple ![]()
There is Little difference between this and the MSDN sample code, but is was an important difference to me.
This is what I used in the end:
# Enables SELECTED installed languages for each subsite in a site collection $spSiteURL = http://sharepoint.balkestahl.se/sites/subsitecountry $spSite = Get-SPSite -Identity $spSiteURL foreach ($spWeb in $spSite.AllWebs) { $spWeb.IsMultilingual = $true $WebRegionSettings = New-Object Microsoft.SharePoint.SPRegionalSettings($spWeb) foreach ($language in $WebRegionSettings.InstalledLanguages) { If ($language.DisplayName -eq "English" -or $language.DisplayName -eq "Swedish") # Add the displayname of any langauge you have installed: -or $language.DisplayName -eq "Norwegian" -or $language.DisplayName -eq "Finnish" -or $language.DisplayName -eq "Danish" { write-host -BackgroundColor Green -ForegroundColor Black "Update -" $spWeb "site with LCID:" $language.DisplayName $culture = New-Object System.Globalization.CultureInfo($language.LCID) $spWeb.AddSupportedUICulture($Culture) } else { Write-host " Language not activated: " $language.DisplayName " on site " $spWeb.Name } } $spWeb.Update() }
This saved me hours and hours…or made it possible ![]()
The running of the script looks something like this, in my case around 3000 times for the Swedish collection, all in all, 50.000 subsites!):
Before running the script, in each site, you have these settings:
(Accessed under: Site Settings/Language Settings, path: /_layouts/muisetng.aspx)

And what we want to do, is check the box for the selected language(s) and move on to the next.
When adding the criteria to the If statement, use the displaynames exactly like in the list in Site Settings/Language Settings:
This script saved me, I hope it can do the same for some of you.
![]()
_________________________________________________________
Enjoy!
Regards
A guide to Alternate Access Mappings Basics in SharePoint 2013
Alternate Access Mapping Basics in SharePoint 2013
(This post is in its entirety valid for SharePoint 2010 as well)
Explains how you should look at Alternate Access Mappings – left to right.
Alternate Access Mappings is something that most SharePoint engineers or administrators struggles with. More often than not, you get it right in the end but we are not really sure why it works or if it really works the way we want it to.
This, is my attempt to make it easy to understand.
| Note: This is part 1 in a series, the next part will show how to configure DNS and a simple scenario adding a new NetBIOS name as URL to a Web Application. |
| Note: For the complete guide, with DNS steps and 4 different scenarios including https, download the free Whitepaper from TechNet: The final guide to Alternate Access Mappings |
In order to make AAMs simpler to understand, look at it a bit differently, start with this simple table:
Left area Internal URL’s
Right area Public URL’s with a zone
Middle area Zones, is what connects Internal URL’s to Public URL’s, many to one.
Internal URL redirects or transforms to a Public URL, from left, to right. The URL on the left, is what you enter in the address field in your browser, the Public URL on the right is what you will see once there, this goes for visible and invisible links as well.
Internal URL format: Protocol + URL (+non default port)
Public URL is the address of the Web Application for one of the five zones available. The ‘Default’ must be filled out and has some special properties/uses, the other four are optional. You can only have five Public URL’s per Web Application.
This is the URL that the browser will be redirected to in the end.
Public URL format: Protocol + URL (+non default port)
Zone is a label representing a Public URL, the zone is used to ‘connect’ an Internal URL to a Public URL. The zone names has no relation what so ever with the four Internet Explorer security zones (Internet, Local Intranet, Trusted sites and Restricted sites) and could just as easily been named 1,2,3,4 and 5. A zone can also represent an authentication provider.
Zones: Default, Intranet, Internet, Custom, Extranet
Example:
| Note: Based on the Zone selected for every Internal URL, they will be connected to a Public URL. |
From left – to right…
The zones might as well be represented by numbers:
| Note: Try to always use the most used URL as the default Public URL. This is what will be used by other services, like crawl and in certain other links. |
Translated to SharePoint GUI, this same setup would look like this:
| Note: Filtered on this Web Applications Alternate Access Mapping Collection only. Same Alternate Access Mappings as in the Example table above. |
You will see that if you click on any of the ‘Internal URLs’ that you can select zone, and with the zone, the Public URL it will be connected to:

In addition to the actual Alternate Access Mapping in SharePoint Central Administration, you also have to add a Binding in IIS, contrary to what many believe, except for the initial hostheader when you create the web application, SharePoint does not do that for you, so you have to do it manually.
The example above would show up in IIS Bindings like this:
As you can see, in IIS 8.0 and Windows Server 2012, the https binding does show up as a hostname, in IIS 7.5 and Windows Server 2008 R2, the hostname is determined by the name configured in certificate used when adding that binding and hidden in this view.
That’s it! When you have configured your AAM’s and Bindings correctly, given that you have name resolution and IP addresses in order and connectivity from the client to the server(s) and all other aspects in order, you can now start to use the URL’s you want.
Enjoy!
Regards
Hardware requirements for all SharePoint 2013 components summarized

Update 2013-01-28 - New note added : Certain Installation Scenarios not supported
Listed below are all of the Hardware requirements that have been announced for SharePoint 2013 and it’s connected services and products.
Covered in the list are, in this order:
| Note: In addition to the listed HW requirements below, note that certain Microsoft SharePoint Server 2013 installation scenarios are not supported Not supported are: Dynamic Memory, ReFS(Resilient File system), Install on a DC, Install in a Workgroup, Install on Windows Web Server. see Microsoft KB: http://support.microsoft.com/kb/2764086 |
-
-
| SharePoint Foundation 2013 | Deployment type and scale | RAM | Processor | Hard disk space |
|---|---|---|---|---|
| Single server with a built-in database or single server that uses SQL Server | Development or evaluation installation of SharePoint Foundation 2013 | 8 GB | 64-bit, 4 cores | 80 GB for system drive |
| Web and application server in a two-tier farm | Pilot, user acceptance test, or production deployment of SharePoint Foundation 2013 | 8 GB | 64-bit, 4 cores | 80 GB for system drive |
| database servers in a two-tier farm | Pilot, user acceptance test, or production deployment of SharePoint Foundation 2013 | 8 GB | 64-bit, 4 cores | 80 GB for system drive |
-
| SharePoint Server 2013 | Deployment type and scale | RAM | Processor | Hard disk space |
|---|---|---|---|---|
| Single server with a built-in database or single server that uses SQL Server | Development or evaluation installation of SharePoint Server 2013 | 24 GB | 64-bit, 4 cores | 80 GB for system drive |
| Web server or application server in a three-tier farm | Pilot, user acceptance test, or production deployment of SharePoint Server 2013 | 12 GB | 64-bit, 4 cores | 80 GB for system drive |
| database servers in environments that have multiple servers in the farm/multi tier | Small deployments | 8 GB | 64-bit, 4 cores | 80 GB for system drive |
| database servers in environments that have multiple servers in the farm/multi tier | Medium deployments | 16 GB | 64-bit, 8 cores | 80 GB for system drive |
| database servers in environments that have multiple servers in the farm/multi tier | Large deployments | See link | See link | See link |
-
| Office Web Applications 2013 | Deployment type and scale | RAM | Processor | Hard disk space |
|---|---|---|---|---|
| Office Web Apps server | Development or evaluation installation of Office Web Apps | 8 GB | 64-bit, 4 cores | 80 GB for system drive |
| Office Web Apps server | Pilot, user acceptance test, or production deployment of Office Web Apps | 12 GB | 64-bit, 4 cores | 80 GB for system drive |
-
| Project Server 2013, Small dataset scenario | Deployment type and scale | RAM | Processor | Hard disk space |
|---|---|---|---|---|
| Minimum requirement, single–server deployment | Development or evaluation installation of Project Server 2013 | 24 GB | 64-bit, 4 cores | 80 GB for system drive |
| Front-end web and Application server hardware | Development or evaluation installation of Project Server 2013 | 8 GB | 64-bit, 4 cores | 80 GB for system drive |
| Front-end web and Application server | Pilot, user acceptance test, or production deployment of Project Server 2013 | 16 GB | 64-bit, 4 cores | 80 GB for system drive |
| Database server | Pilot, user acceptance test, or production deployment of Project Server 2013 | 16 GB | 64-bit, 4 cores | 80 GB for system drive |
| Project Server 2013, Medium dataset scenario | Deployment type and scale | RAM | Processor | Hard disk space |
|---|---|---|---|---|
| Minimum requirement, front-end web server | Development or evaluation installation of Project Server 2013 | 8 GB | 64-bit, 4 cores | 80 GB for system drive |
| Minimum requirement, application server | Development or evaluation installation of Project Server 2013 | 8 GB | 64-bit, 4 cores | 80 GB for system drive |
| Minimum requirement, database server | Development or evaluation installation of Project Server 2013 | 16 GB | 64-bit, 4 cores | 100 GB for system drive |
| Recommended, front-end web server | Pilot, user acceptance test, or production deployment of Project Server 2013 | 16 GB | 64-bit, 4 cores | 80 GB for system drive |
| Recommended, application server | Pilot, user acceptance test, or production deployment of Project Server 2013 | 16 GB | 64-bit, 4 cores | 100 GB for system drive |
| Recommended, database server | Pilot, user acceptance test, or production deployment of Project Server 2013 | 32 GB | 64-bit, 8 cores | 160 GB for system drive |
| Note: Ideally, you should separate and prioritize data among disks. Place your data files and your SQL Server transaction logs on separate physical hard disks. RAID 5 should provide a good compromise between reliability, and throughput. |
| Project Server 2013, Large dataset scenario | Deployment type and scale | RAM | Processor | Hard disk space |
|---|---|---|---|---|
| Recommended, front-end web server | Pilot, user acceptance test, or production deployment of Project Server 2013 | 16 GB | 64-bit, 4 cores | 80 GB for system drive |
| Recommended, application server | Pilot, user acceptance test, or production deployment of Project Server 2013 | 16 GB | 64-bit, 4 cores | 100 GB for system drive |
| Minimum requirement, database server | Pilot, user acceptance test, or production deployment of Project Server 2013 | 32 GB | 64-bit, 4 cores | 250 GB for system drive |
| Recommended, database server | Pilot, user acceptance test, or production deployment of Project Server 2013 | 64 GB | 64-bit, 8 cores | 300 GB or more |
| Note: Ideally, you should separate and prioritize data among disks. Place your data files and your SQL Server transaction logs on separate physical hard disks. RAID 5 should provide a good compromise between reliability, and throughput. |
Back to table of contents
-
-
-
| SQL Server 2012 Reporting Services, SharePoint Integrated mode | Deployment type and scale | RAM | Processor | Hard disk space |
|---|---|---|---|---|
| Reporting Services 2012 Add-on | Must be Installed on a SharePoint Server 2013 Web Server | 12 GB | 64-bit, 4 cores | 80 GB for system drive |
| Reporting Services 2012 Service Application | Must be Installed on a SharePoint Server 2013 Application Server | 12 GB | 64-bit, 4 cores | 80 GB for system drive |
-
| PowerPivot in SharePoint Mode | Deployment type and scale | RAM | Processor | Hard disk space |
|---|---|---|---|---|
| Standalone PowerPivot for SharePoint 2013 server that is not part of the SharePoint farm | Minimum requirement | 8 GB | 64-bit, 2 cores | 80 GB or more |
| Standalone PowerPivot for SharePoint 2013 server that is not part of the SharePoint farm | Recommended | 64 GB | 64-bit, 16 cores | 80 GB or more |
-
| SQL Server 2012 SP1 Analysis Server in SharePoint mode | Deployment type and scale | RAM | Processor | Hard disk space |
|---|---|---|---|---|
| SQL Server 2012 SP1 Analysis Server in SharePoint mode | Runs outside a SharePoint 2013 farm | SQL, see link | SQL, see link | SQL, see link |
-
References:
Software, hardware, and configuration requirements for Office Web Apps Server
http://technet.microsoft.com/en-us/library/jj219435.aspx#software
Hardware and software requirements for SharePoint 2013
http://technet.microsoft.com/en-us/library/cc262485(v=office.15)#hwforwebserver
Hardware and software requirements for Project Server 2013
http://technet.microsoft.com/en-us/library/ee683978
Hardware and Software Requirements for Reporting Services Server in SharePoint Mode for SharePoint 2013
http://msdn.microsoft.com/en-us/library/jj714188.aspx
Hardware and Software Requirements for Analysis Services Server in SharePoint Mode (SQL Server 2012 SP1)
http://msdn.microsoft.com/en-us/library/fb86ca0a-518c-4c61-ae78-7680c57fae1f
Hardware and Software Requirements for Installing SQL Server 2012
http://msdn.microsoft.com/en-us/library/09bcf20b-0a40-4131-907f-b61479d5e4d8
Certain Microsoft SharePoint Server 2013 installation scenarios are not supported
http://support.microsoft.com/kb/2764086
Use best practice configurations for the SharePoint 2013 virtual machines and Hyper-V Environment
http://technet.microsoft.com/en-us/library/ff621103.aspx
I know I will use this to make my life easier until I get it all memorized…I hope that it may help you as well. Any feedback or recommended additions to the tables will be appreciated.
Back to table of contents
![]()
_________________________________________________________
Enjoy!
Regards
SharePoint 2013 and Office Web Apps 2013 resources
I just thought that it would be a nice thing to have key links to getting started with Office Web Apps 2013 all in one place:
- Download Microsoft Office Web Apps Server
- Download Language Packs for Microsoft Office Web Apps Server
- TechNet: Deploy the infrastructure: Office Web Apps Server
- TechNet: Plan Office Web Apps (Used with SharePoint 2013)
- TechNet: Overview of Office Web Apps and how they work on-premises with SharePoint 2013
The Licensing for Office Web Apps is all new:
Licensing Office Web Apps for editing Office files
Office Web Apps licensing offers two options:
- View-only. By default, Office Web Apps is view-only. View-only functionality is provided for free.
- Edit and view. You must purchase an editing license to use the editing features of Office Web Apps with SharePoint 2013. You enable editing when you create the Office Web Apps Server farm.
Enterprise customers who are licensed for Office 2013 through a Volume Licensing program can enable Office Web Apps editing for SharePoint 2013 on-premises. This helps make sure that users have Office editing capabilities at home or in other locations where Office clients might not be installed. Editing licenses for Office Web Apps are not available for separate purchase.
For exact details about your license, refer to the Microsoft Software License Terms that is shown when you install Office Web Apps Server.
SharePoint 2013 provides new license enforcement that works with Office Web Apps. If you enable SharePoint licensing and then enable Office Web Apps editing, only the users who have the appropriate license, which is known as OfficeWebAppsEdit, can actually edit Office files in a browser. If no Office Web Apps editing licenses are applied for users, only viewing is supported. For more information about how licensing works in SharePoint 2013, see Configure licensing in SharePoint Server 2013. The EditingEnabled parameter that enables editing is described in New-OfficeWebAppsFarm and Set-OfficeWebAppsFarm.
Read more here: Licensing Office Web Apps for editing Office files
Remember also, that in 2013 the Office Web Apps server/farm is a shared resource between SharePoint Server 2013, Lync Server 2013 and Exchange Server 2013.
Browser support, see image:
As you can see, owa now supports most common browsers
Enjoy!
Regards
SharePoint Conference 2012 in Las Vegas report part7
The Conference is over for this time, but I just wanted to report one last time on the downside of the event for us Europeeans at least…the travelling…
My friday/saturday went like this:
(4:30 AM Las Vegas time)
0:00 hrs - Wakeup call from the Mandalay Bay lobby.
0:30 hrs – Checkout and can to McCarran Airport.
1:00 hrs – Checkin, got the bag checked by a nice lady from United, thanks to her, I could get away with quite a lot of overweight.
1:30 hrs – After security and the tram over to D terminal, I got a nice cup of Gingerbread Latte at Starbucks followed by an American breakfast with bacon, eggs and hashbrowns.
(7:35 AM)
3:35 hrs – Takeoff to Newark Airport.
8:35 hrs – Touchdown at Newark Airport.
9:00 hrs Lunch at Smack Burger…and some last minute shopping to the kids.
(14:20 AM)
10:20 hrs – Takeoff to Stockholm Sweden.
18:30 hrs – Touchdown at Arlanda Airport Stockholm Sweden.
(8:00 AM Stockholm time / 12:00 AM Las Vegas time)
19:30 hrs – Arrived at home
About 14 hours more to stay awake until it’s time for bed…We’ll see if I can even make it that far.
Thanks all for listening/reading, it has been a pleasure!
(If you have missed any or of the previous parts of the SPC report, use the links below.)
Part 1 of this report
Part 2 of this report
Part 3 of this report
Part 4 of this report
Part 5 of this report
Part 6 of this report
![]()
_________________________________________________________
Enjoy!
Regards
SharePoint Conference 2012 in Las Vegas report part6
Thursday, fourth Session day! Today is the last session day and the final day of the conference…
I had only two sessions scheduled out of three possible slots, one on Reporting Services and one Customer Case on Search.
The day started as usual with breakfast, this was different though…no bacon. Who can live without a good stack of bacon at breakfast?
Today they also offered a drink that was new to me, a green juice…see for yourself..


Spinache and broccoli? Grass??
It was ok I guess…but one was enough. After breakfast I had as the first session for the day a session on SSRS:
Running Reporting Services in SharePoint Integrated Mode: How and Why
(Spc199) Riccardo Mutti
Very good walkthru of setting up Reporting services in Integrated mode, both on SHarePoint 2010 and SQL 2008 R2 and on SharePoint 20103 with SQL 2012.
We also got to know what is good with using integrated mode instead of native, and what makes Microsofts integrated mode real, not compared to aothers that claim to have SharePoint integration. Tings like using built in security and that existing features can be utilized.
It was a very good walkthru and I will probably use the session recording as a good guide, but it could have been better as well, Riccardo used a demo Environment with Everything on the same box, meaning no kerberos and no permissions, which really are the things that make SSRS hard…
We did get to see the new 2013 Service Application model, whach will make SSRS easier to comprehend.
I got a good explanation as to what using a trusted account means, that was good. I Think that many customers and users can make do with a trusted account and thus not have to go thru all of the painstaking issues of setting up the environemnt to support kerberos.
The differnces:
Interensting stuff.
Next session, a customer session.
Customer Showcase: Telenor and Search with SharePoint
(SPC050) Andreas Hogberg, Denis Heliszkowski, Marius Pedersen
Andreas Högberg from Telenor, a Norwegian telecom Company explained how they quickly moved to use SharePoint 2013 search to get a better result even from their existing 2007 environment.
The end goal was to move completely to 2013 and do that without any ciustomizations, something which 2013 offered as a possibility.
The current global SharePoint 2007 environment had 171 customizations, the new SharePoint 2013 farm had 0(zero).
The plan was to have the two Environments coexist, then step by step move data from 2007 to 2013.
One interesting thing was the use of IaaS, Azure and Infrastructure as a service, they put all of their test and demo Environments there to save Money and time, and the environemnt did at its peak use 300+ cores in the cloud model.
Interesting session, nice to hear from a ‘real’ customer.
With on the session were two Consultants from MCS. Since most of the Project was done under the RDP program, they had MCS in on it to get the knowledge and inside help only MCS could offer.
That was it, last session for me.
I spent some time after that at the Exibit hall, talking to partners and perticipating in the raffles…
I did actually win a Windows 8 phone! Thanks Nintex!! I really love what you do! (Really, they do great workflows!)
I did not win the Ducati Monster motorbike that AvePoint gave away today…that Went to Another happy gentleman…
A few hours of shopping at the Premier Outlet North and I’m ready to go home. I’m flying home on the early bird tomorrow!
This is Thomas Balkeståhl signing out from the 2012 edition of the SharePoin t Conference for the last time. It has been great! I recommend going to everyone who havent been here and that works Close with SharePoint. It’s a uniqe opportunity to get knowledge and insight that you can’t really get anywhere else in the world.
The Mandalay Bay Hotel
Part 1 of this report
Part 2 of this report
Part 3 of this report
Part 4 of this report
Part 5 of this report
![]()
_________________________________________________________
Enjoy!
Regards
SharePoint Conference 2012 in Las Vegas report part5
Wednesday, third Session day! Today is the first Spencer Harbar day…
Another day with all sessions, then after that Ask the Experts Night. Nice…
I started out with the obvious selection this day. Spencer Harbar on UPS. For those of you who don’t know that name. He is the GOD on UPS, he has probably saved more UPS installations than anyone else.
User Profile Synchronization Best Practises in SharePoint Server 2013
(SPC245) Spencer Harbar
Spencer talked about the new and improved UPS in SharePoint 2013, what really is new (because a lot isn’t) is the 3 modes you can choose between.
-AD Import (That was available in SharePoint 2007 has been reintroduced and improved)
-UPS
-Custom
The reintroduced AD Import probably does what the majority of all customers want, a simple synch of user profile data to SharePoint.
It is import only and simpler than UPS, but it gets you the basics and more.
The Profile data is even entered into the Managed metadata Term store. Really nice.
Simple to configure and really a nice new option.
UPS, same as before, the real deal.
Planning!
All in all, a really great session that gave a lot of good info and most of all, hope, that UPS will be better this time.
And, Spencer Harbar is the man, no question!
See his blog here: http://www.harbar.net/
Migrating to SharePoint online in office 365 – strategy and best practices
(SPC152) Phil Cohen, Kimmo Fors
Again, a very good session. Things to think about from two Consultants from Microsoft Consulting Services. Really valuable content, experiences from real migrations that is hard to come by.
Key, same as with UPS and Everything else, planning!
Planning and Creating well designed Intranet Sites in SharePoint online
(SPC015) Randy Drisgill, john Ross
This was not really what I was hoping for, but still a very good session. What to Think about before setting up your Intranet in the cloud. How to make it useable and to look good. Again…plan plan plan…:-)
They started of with a few numbers:
Of all Projects setting up SharePoint the following is actually true:
62% over time
49% over budget
28% do not fit requirements
Proper planning could have made them all 100% successfull.
Deep dive to plan and Prepare for your users to interact with SharePoint from their Mobile devices.
(SPC164)
A very good Eye-opener on what can be done to make the Smartphone users experience better or even good. The new default Mobile view in SharePoint teamsites is really good. Try it out. No more basic text…
With apps coming out, like the Office hub and the SharePoint news reader, it will be a good offering to SmartPhone users.
Customizing the way SharePoint 2013 looks.
(SPC065)
A session on theme’ing and branding in SharePoint 2013. A really good session that showed us how to build your own themes and theme colors and also masterpages and css. The story on branding in 2013 just got a lot better.
Ask the experts.
The traditional ask the experts evening shared it with the exibit, all partners were in Place and showeed their solutions and companies to all that were interested. I spent some time today here at lunch as well and by now, it feels like I have seen most and talked to the ones I am interested in.
I got to talk to the creator of passphrases in SharePoint (Sean Livingston) and ask him if they were needed…(See privious post)
He unfortunately took it the wrong way and got almost upset…I still believe though, even after talking to the father of the Farm PassPhrase, that it is not really needed…it is more for percieved security, not security in itself…
And yes, do get me right, it is used!, to encrypt data in the db, but what I’m saying is that we don’t really need to see it or even know about it. It could just as well be hidden behind the scenes and be 200 chars long…in my opinion(until someone really proves me wrong…)
Ok, that was it. More fun tomorrow. That is the last day of the Conference and sessions are only planned for half the day. We’ll see what happens then.
I’ll try to keep reporting to all off you directly each and every day during the conference in order to share some parts of the great experience…
Stay tuned, this me, signing out, from day two of my SharePoint conference experience.
Part 1 of this report
Part 2 of this report
Part 3 of this report
Part 4 of this report
![]()
_________________________________________________________
Enjoy!
Regards





























































