Archive
Enterprise Edition of SharePoint Server 2013 – what’s in it?
Why get the Enterprise edition of SharePoint Server 2013?
That is a question you should ask yourself at the beginning of every new SharePoint Project where you are planning to set up a new farm. Depending on what features and functionality you are planning to use, the editions will offer you a different solution.
Obviously, the Enterprise edition has a bigger prisetag, but if so only one of the features is what you or your customer is looking for, you could end up saving money by using a built in feature instead of developing your own.
Say that you only need one of the Enterprise features and you end up getting the Enterprise license, you get the functionality you was looking for, but in addition, you will have all the other Enterprise features available for use at a later time. The odds tell us that the farm will evolve and new functionality will be asked for.
| Note: The complete list of all features in all editions of SHarePoint 2013 can be found here: SharePoint 2013 feature comparison chart all editions |
The top 10 lost of features that make customers buy Enterprise edition, at least from my experience (feedback on this is welcomed and will be considered for implementation)
Enough with the planning and strategy/sales/aquisitions dravel…lets dive into the features!
The ‘shortlist’ of ENT features looks like this, these are the features that you DO NOT get unless you have the Enterprise edition:
|
SharePoint Server 2013 Enterprise Edition feature Title |
|
|
Link to feature list |
References, links |
| Developer - Access Services Build web databases and publish them to a SharePoint site. SharePoint visitors can use your database application in a web browser by using SharePoint permissions to determine who can see what. And you can start with a template so that you can start collaborating immediately. |
|
| Access Services | MSDN: What’s new in Access 2013 Habanero Consulting: Access Services in SharePoint 2013 |
| Developer - BCS - Rich Client Integration Business Connectivity Services (BCS) uses a complimentary client and server-side architecture that allows for Office clients, such as Outlook and Excel, to work directly with external data exposed to SharePoint through external content types. Learn more about Business Connectivity Services Client Runtime. (Not available to SharePoint Online customers) |
|
| BCS: Rich Client Integration | MSDN: BCS client object model |
| Developer - BCS - Tenant-level external data log Tenant-level external data logging allows for logging of transactions that affect specific SharePoint tenancies. |
|
| BCS: Tenant-level external data log | N/A |
| Developer – Custom Site Definitions SharePoint Server 2013 customers can create their own site definitions that customize and extend standard SharePoint site templates. (Not available to SharePoint Online customers) |
|
| Custom Site Definitions | MSDN: Overview of Creating Custom Site Definitions |
| Developer - Custom Site Provisioning SharePoint Server 2013 customers get a quick and easy way for users to make their site requests and to start using their sites quickly. (Documentation states that this is Not available to SharePoint Online customers, but it is and it is available from the SharePoint administration, settings, ‘Start a site’.) |
|
| Custom Site Provisioning | Steve Paeschka(MS): Configuring Self Service Site Creation in SharePoint 2013 Navantis: Self-Service Site Creation in SharePoint 2013–Are the Changes Enough to Make this Feature Viable in the Enterprise? |
| Developer - InfoPath Forms Services Forms Service provides a Web browser form-filling experience in SharePoint, based on form templates that are designed in InfoPath. |
|
| InfoPath Forms Services | MSDN: InfoPath Forms Services |
| IT Pro - Analytics Plattform SharePoint Server 2013 customers can use the Analytics Platform, which replaces the Web Analytics service application, to help identify and surface the content that users consider to be the most useful and relevant. (Not available to SharePoint Online customers) |
|
| Analytics Platform | Analytics Platform |
| IT Pro - Improved Self-Service Site Creation SharePoint Server 2013 customers can use self-service site creation to configure things such as: whether to use a custom form to create the site, whether to create a subweb or site collection, what path should be used when the site collection is created, and whether to ask or require that a site policy be selected when the site is created. |
|
| Improved Self-Service Site Creation | Steve Paeschka(MS): Configuring Self Service Site Creation in SharePoint 2013 Navantis: Self-Service Site Creation in SharePoint 2013–Are the Changes Enough to Make this Feature Viable in the Enterprise? |
| Content - eDiscovery Electronic Discovery, or eDiscovery, features allow organizations to identify, hold, search, and export content from Exchange mailboxes, SharePoint sites, and file shares to support case management in addition to preservation and compliance. Learn more about. |
|
| eDiscovery | Office: Planning and managing eDiscovery cases |
| Content - Preservation hold library Content that is placed on hold is preserved, but users can still change it. The state of the content at the time of preservation is recorded. If a user changes the content or even deletes it, the item is retained at the time of deletion and the original, preserved version is still available. |
|
| Preservation hold library | TechNet: In-place holds Office: Placing content sources on hold |
| Web Content Management – Video Search An Asset Library is pre-configured to use special features that help you manage rich media assets, such as image, audio, and video files. |
|
| Video Search | Office: Setting up an Asset Library to store image, audio, or video files Jasper Oosterveld: SharePoint 2013 – The new and improved asset library TechNet: Digital asset libraries |
| Web Content Management – Catalog A catalog is a library or list that is shared across other sites and site collections. (Not available to SharePoint Online customers) |
|
| WCM: Catalog | TechNet: Catalog content for SharePoint authoring sites |
| Web Content Management – Cross Site Publishing Cross-site publishing allows SharePoint Server 2013 customers to use one or more authoring site collections to author and store content, and one or more publishing site collections to control the design of the site and to show the content. The authoring site collection contains catalogs, such as Pages libraries and lists, which contain content that is tagged with metadata. These catalogs are indexed by the search system and made available to the publishing site collection. The publishing site collection issues queries for data that was indexed and shows it on web pages by using Web Parts that use search technology. Learn more about (Not available to SharePoint Online customers) |
|
| WCM: Cross-site publishing | TechNet: Cross-site publishing in SharePoint Server 2013 |
| Web Content Management – Faceted Navigation Faceted navigation help users browser for content more easily by filtering on refiners that are tied to terms in a term set. By using faceted navigation, SharePoint Server 2013 administrators can configure different refiners for different terms in a term set without having to create additional pages. (Not available to SharePoint Online customers) |
|
| WCM: Faceted navigation | TechNet: Refiners and faceted navigation |
| Web Content Management – Image Renditions Image renditions let organizations have large source images on a SharePoint Server 2013 site and also have places on a site where pages only use smaller versions. (Not available to SharePoint Online customers) |
|
| WCM: Image Renditions | Content authoring improvements |
| Web Content Management – Host Named Site Collections/Multiple Domains SharePoint Server 2013 can create host-named site collections with the host header. Host-named site collections in SharePoint provide URL management and scalability of sites within a single web application. (Not available to SharePoint Online customers) |
|
| WCM: Multiple Domains | TechNet: Plan for host-named site collectionsSharePoint Blues: Host Named Site Collections and Apps Host |
| Web Content Management – Category/Catalog item Pages Category pages and catalog item pages are page layouts that you can use to show structured catalog content consistently across a SharePoint Server 2013 site. (Not available to SharePoint Online customers) |
|
| WCM: Topic Pages | TechNet: Cross-site publishing |
| BI/Insights – The Business Intelligence Center The Business Intelligence Center site enables you to store data connections, workbooks, reports, scorecards, and dashboards in a central, secure location. |
|
| Business Intelligence Center | TechNet: configuring Business Intelligence Center |
| BI/Insights – Calculated Measures and Members When you create PivotChart reports of PivotTable reports that use data that is stored in SQL Server Analysis Services, you can create calculated measure and calculated members for that report. |
|
| Calculated Measures and Members | Office: Business intelligence capabilities in Excel Services. |
| BI/Insights – Data Connection Library A data connection library is a special SharePoint library that is designed to store and manage shared data connections. These can include ODC files that you create by using Excel. |
|
| Data Connection Library | TechNet: Trusted Data Connection Libraries in SharePoint Server 2013 |
| BI/Insights – PivotTable/PivotChart When you create a PivotChart report, a corresponding PivtoTable report is automatically created. New in Excel 2013, you do not have to display a PivotTable report on the same worksheet as its corresponding PivotChart report. You can choose to display only the PivotChart report. This capability is called “decoupled PivotTables and PivotCharts”. |
|
| Decoupled PivotTables and PivotCharts | Office: PivotTables and PivotCharts |
| BI/Insights – Excel Services Excel Services enables you to share workbooks with others, view and explore information in a browser window, and refresh data. Excel Services enables you to view and interact with reports, scorecards, and dashboards in a browser window, much like you would use the Excel client. Excel Services also enables you to share all or parts of workbooks with others, and control what information is displayed in those workbooks. |
|
| Excel Services | Office: Excel Services |
| BI/Insights – Field List and Field Well Excel Services enables you to open the Field List and Field Well for PivotChart reports and PivotTable reports that are viewed in a browser windows. This capability makes it easy to temporarily change the information that is displayed in a PivotChart report or a PivotTable report without having to open Excel. |
|
| Field list and Field Support | TechNet: Business intelligence capabilities in Excel Services |
| BI/Insights – Slicers Slicers are a kind of filter that you can use to select one or more items to use as a filter for reports and scorecards in a worksheet. For example, suppose that you want to see sales information for different colors of items, such as shirts that your company carries. You can create a slicer that lists shirt colors, connect it to a sales report, and then use the slicer to view sales information for the colors that are selected in the slicer. |
|
| Filter Enhancements – Slicers | TechNet: Business intelligence capabilities in Excel Services |
| BI/Insights – Filter Search You can search on filter results, which makes it easy to jump to a particular item in a long list. |
|
| Filter Search | Use filters and slicers to focus on specific information |
| BI/Insights – PerformancePoint Services PerformancePoint Services enables SharePoint Server 2013 customers to create interactive dashboards that display key performance indicators (KPIs) and data virtualizations in the form of scorecards, reports, and filters. (Not available to SharePoint Online customers.) |
|
| PerformancePoint Services | PerformancePoint Services in SharePoint Server 2013 overview |
| BI/Insights - Dashboard Migration With Dashboard Migration, SharePoint Server 2013 customers will be able to copy complete dashboards and dependencies. This includes the .aspx file, to other users, servers, or site collections. This feature also allows the ability to migrate single items to other environments and migrate content by using Windows PowerShell commands. (Not available to SharePoint Online customers) |
|
| PerformancePoint Services (PPS) Dashboard Migration | TechNet: Create Dashboards by using PerformancePoint Services |
| BI/Insights – Power View Power View is an add-in for Excel that enables organizations to visualize and interact with modeled data by using highly interactive visualizations, animations, and smart querying. Organizations can present insights with other through storyboard presentation capabilities. Power View is powered by BI Semantic Model and the VertiPaq engine. |
|
| Power View | Office: Power View: Explore, visualize, and present your data |
| BI/Insights – PowerPivot PowerPivot is an add-in that organizations can use to perform powerful data analysis and create sophisticated data models. PowerPivot also enables organizations to mash up large volumes of data from various sources, analyze data quickly, and share insights. |
|
| PowerPivot | Office: PowerPivot – Powerful data analysis and data modeling in Excel |
| BI/Insights – Quick Explore Quick Explore enables organizations to select a value in a PivotChart report or a PivotTable report and see additional information about that value. For example, if you are viewing a sales report and you select a value that represents total sales amounts, you can use Quick Explore to view additional information such as sales amounts across different product categories or geographical areas. |
|
| Quick Explore | Office: What’s new in Excel 2013 - Instant data analysis |
| BI/Insights – Scorecards and Dashboards A scorecard shows at a glance whether performance is on or off target for one or more key performance indicators (KPIs). A dashboard is a collection of views that can include scorecards and other reports. Scorecards and dashboard are designed to show current performance information and are typically rendered in a site such as a SharePoint Server 2013 site. (Not available to SharePoint Online customers) |
|
| Scorecards & Dashboards | Office: Create and use a report or a scorecard |
| BI/Insights – Reporting Services When SQL Server 2012 Reporting Services is integrated with SharePoint, you can use powerful SharePoint collaboration and centralized document management features for SQL Server 2012 Reporting Services content. Reports are stored in SharePoint document libraries, alongside other reports such as Excel Services files. SharePoint permissions can be used to control access to Reporting Services content, and people are able to start Report Designer, Model Designer, and Report Builder within a document library. |
|
| SQL Server Reporting Services (SSRS) Integrated Mode | TechNet: Reporting Services Report Server (SharePoint Mode) |
| BI/Insights – Report Viewer Web Part The SQL Server 2012 Reporting Services Web Part enables people to display an existing Reporting Services report in its own Web Part in a SharePoint site. If the Reporting Services report contains parameters, people can connect filters to that report using the Web Part settings. |
|
| SQL Server Reporting Services (SSRC) Web Part | TechNet: Using the Report Viewer Web Part |
| BI/Insights – Timeline Controls A timeline slicer is a control that can be added to a dashboard created by using Excel. A timeline control enables people to view information for a particular period of time. (The use of existing Timeline Controls is available to SharePoint Online customers) |
|
| Timeline Slicer | Office: Business intelligence capabilities in Excel Services |
| BI/Insights – Visio Services Visio Services is a service application that lets users share and view Microsoft Visio Drawing (*.vsdx) and Visio 2010 Web drawing (*.vdw) files. |
|
| Visio Services | TechNet: Visio Services in SharePoint Server 2013 |
| Search – Content Search Web Part The Content Search Web Part is a SharePoint Server 2013 feature that displays content that was crawled and added to an organization’s search index. It is a very powerful and versatile Web Part, especially when it is used in combination with managed navigation and category pages. The Content Search Web Part allows you to select a result source. This makes it very easy to specify which content should be searched. You can also use Keyword Query Language to add more filters and search terms to the query in this Web Part. (Not available to SharePoint Online customers) |
|
| Content Search Web Part | MSDN: Content Search Web Part in SharePoint 2013 TechNet: Configure Search Web Parts in SharePoint Server 2013 |
| Search – custom entity extraction SharePoint Server 2013 administrators can create and deploy custom entity extraction dictionaries to configure the search system to look for specific words or phrases (entities) in unstructured content. The extracted entities are stored in separate managed properties, and you can use them to improve your organization’s search experience, for example by creating refiners. (Not available to SharePoint Online customers) |
|
| Custom entity extraction | TechNet: Create and deploy custom entity extractors |
| Search – Content Enrichment Developers can call out to an external content enrichment web service to change the managed properties of crawled items before they are indexed. The ability to change managed properties for items during content processing is helpful for tasks such as data cleansing, entity extraction, classification, and tagging. (Not available to SharePoint Online customers) |
|
| Extensible content processing | MSDN: Custom content processing with the Content Enrichment web service callout |
| Search – Query rules advanced In this query rule, specify conditions and correlated actions. When a query meets the conditions in a query rule, the search system performs the actions specified in the rule. |
|
| Query rules—advanced actions | Steve Peschka: Query Rule Conditions in SharePoint 2013 Search SharePoint ITPro blog: What happened to Best Bets? Introducing Query Rules |
| Search – Results formatted for Video A targeted search experience that displays results that are custom filtered and formatted for video content. |
|
| Search vertical: “Video” | TechNet: What’s new in search in SharePoint Server 2013 |
I hope that this compilation of facts will help you in some way, I was looking for a similar list and I know I have many times before with 2003, 2007 and 2010.
___________________________________________________________________________________________________
Enjoy!
Regards
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 Branding and SharePoint Foundation part 2
A guide to Branding and SharePoint Foundation
Part 2
This is the part two of the series trying to cover the tweaks needed to get a starter branding going on a SharePoint Foundation installation.
In part 1 I tried to explain why the most common method of using the $PUrl to get the relative path does not work and also how to customize the masterpage in order to insert a custom favicon without the use of $SPUrl. Now I will cover how to add a custom CSS to your master without the use of $SPUrl.
The most common method on a SharePoint server is to add this line:
<SharePoint:CssRegistration name=”<% $SPUrl:~sitecollection/Style Library/My Branding/MyStyles.css %>”After=”corev4.css” runat=”server” />
After the default CSS loader:
<SharePoint:CssLink runat=”server” Version=”4″/>
But since the use of $SPUrl is unavailable to us, we need to find something else. If we use a hardcoded path it will work as long as the master is deployed only in the site collection root, but if we want to use the same master in all subsites(spwebs) as well, then we need a way to get the relative path from the sitecollection root. In my SharePoint Branding Project Foundation adaptation I solved it like this:
<asp:literal runat=”server” Text=”<link href=’”/>
<SharePoint:ProjectProperty Property=”SiteUrl” runat=”server” />
<asp:literal runat=”server” Text=”/Style Library/My Branding/MyStyles.css’ rel=’stylesheet’ type=’text/css’/>”/>
What the code does is that it builds a new href link that point to the custom css deployed to the site collection style library, same as the <SharePoint:CssRegistration would, it renders a link and loads the css. If we want the custom css to be applied after the default, then we also need to add these lines before the default css line.
The trick to this is the use of the webcontrol SharePoint:ProjectProperty that is available for use in Foundation as well as Server. This will give you the URL to the Site Collection root, for example:
http://www.mycompany.com/sites/finance
Putting two literal contols before and after the webcontrol to fill in the text needed for a complete link tag is all that is needed.
This solution works very well for me, I hope that you will also find some help in my suggestion.
See also part 1, on how to add a custom favicon to your Foundation master
Stay tuned!
Regards
A guide to Branding and SharePoint Foundation part 1
A guide to Branding and SharePoint Foundation
Part 1
SharePoint branding is something that most everyone wants to do, the default design is pretty good and stylish but it get dull and it does not fit in with any organizations brand book or design policy. A lot of posts have been written on the subject of SharePoint branding, many books have been published and most of what can be covered has been covered. What I found though during my work with the SharePoint Branding Project, is that there is a lack of information about branding and Foundation. Lots of organizations run Foundation, the reasons for doing so are many but the facts remains, SharePoint Foundation 2010 has a very large installed base. So, can’t we just buy the book on SharePoint branding and implement it in our Foundation farm? The answer to that question is most of the time no, or rather, not very likely. SharePoint Server has one vital component that Foundation lacks, it has a publishing infrastructure feature. In most cases the publishing components are used for some vital parts of a branding package, the most common one that you will see in almost every post is the
<% $SPUrl:~sitecollection/pathtosomething/%>
The SPUrl token is very handy when storing files in a centralized location in SharePoint, like for example the ‘sites/mycompany/style library/’. Lets use the FavIcon as an example in the first part.
<link rel=’shortcut icon’ href=’<% $SPUrl:~sitecollection/Style Library/My Branding/Images/favicon.ico %>’/>
This tag would in Server farm pick the FavIcon image out from the site collection root. In Foundation you would see an error similar to this:
‘The expression prefix ‘SPUrl’ was not recognized. Please correct the prefix or register the prefix in the <expressionBuilders> section of configuration.’
Accessing CSS or Image files in the Style Library is easy using the $SPUrl expression builder to get the relative Site Collection Root URL(/sites/mycompany) or even the current Web Root URL. In Foundation the SPUrl token can’t be used so we need something else. One solution is pretty easy, just enter the relative path:
<link rel=’shortcut icon’ href=’sites/mycompany/style library/my branding/Images/favicon.ico’/>
For the Site Collection Root the path would resolve to:
http://webapplication/sites/mycompany/Style Library/My Branding/Images/favicon.ico
Perfectly allright, the favicon would be loaded. This is a great solution, with one huge flaw. If you have the branding implemented in all of your subsites then the path will be correct only in the root. Since the path is relative, it would in an example subsite look like this in the master:
<link rel=’shortcut icon’ href=’sites/MyCompany/Style Library/My Branding/Images/favicon.ico %>’/>
For my SubDivision subsite the path would resolve to:
http://webapplication/sites/mycompany/subdivision/Style Library/My Branding/Images/favicon.ico
Not ok! The load would fail since the favicon.ico is not located there. So, the permanent relative is only good for a site collection root with no subsites. You could obviously add the file to every subsite so that the path would work, but that is not really an option in most cases. So, how do we do it then…? In my own SharePoint branding project I use this workaround to replace the <link rel=’shortcut icon’ token:
<asp:literal runat=”server” Text=”<link rel=’shortcut icon’ href=’”/>
<SharePoint:ProjectProperty Property=”SiteUrl” runat=”server” />
<asp:literal runat=”server” Text=”/style library/my branding/images/favicon.ico’/>”/>
It is a workaround, but it works. This will in reality build a relative path to the Site Collection Root even in the subsites and it will build up the <link> token by using 2 literal asp controls and the SharePoint:ProjectProperty control that is available in Foundation. The result in runtime will be the same as for a URL built on the $SPUrl expression builder.
<link rel=’shortcut icon’ href=’sites/mycompany/style library/my branding/Images/favicon.ico’/>
Add this to your Masterpage and you will have a functional FavIcon that uses a relative path.
Stay tuned!
Best regards
I have a site called SITE_2 in IIS, whats this…?
This is just a really short instruction and explaination on the SITE_2 phenomenon.
This site is created for some reason in IIS after you have uninstalled SharePoint from a server.
Delete it by selecting the ‘Sites’ container and then right-clicking in the right pane on SITE_2, Remove.
If you click on it in the leftpane you will get an error…’The application / does not exist’
‘Til next time.
_________________________________________________________
Enjoy!
Regards
SharePoint prerequisites, this is how you do it!
This post will cover most of what you need to know about the prerequisites of SharePoint Server 2010.
There are a few tricks to it that can help you out, there are a few things never before documented…and there are links that need to be collected into one place.
That, is what will show up in this post eventually…
Adding the obvious starting point for now, this is an absolute must before starting to fiddle with alternate ways of installing the prerequisites:
Install prerequisites from a network share (SharePoint Server 2010)
http://technet.microsoft.com/en-us/library/ff686793.aspx
Finding them and Collecting them:
All of the requirements needed for a successful installation of SharePoint Server 2010 or SharePoint Foundation 2010 are listed in the technet article:
Hardware and software requirements (SharePoint Server 2010)
http://technet.microsoft.com/en-us/library/cc262485.aspx
There is a full set of prerequisites that have to be on the servers before installing the SharePoint binaries.
IIS:
Server (IIS) role
Application Server role
Add-ons:
Microsoft .NET Framework version 3.5 SP1
SQL Server 2008 Express with SP1
Microsoft Sync Framework Runtime v1.0 (x64)
Microsoft Filter Pack 2.0
Microsoft Chart Controls for the Microsoft .NET Framework 3.5
Windows PowerShell 2.0
SQL Server 2008 Native Client
Microsoft SQL Server 2008 Analysis Services ADOMD.NET
ADO.NET Data Services Update for .NET Framework 3.5 SP1
Windows Identity Foundation (WIF) (If the Geneva framework is previouisly installed, it needs to be uninstalled before WIF is installed)
(A hotfix for the .NET Framework 3.5 SP1 that provides a method to support
token authentication without transport security or message encryption in WCF.)
For Windows Server 2008 SP2, download the Windows6.0-KB979917-x64.msu (Vista) file.
For Windows Server 2008 R2, download the Windows6.1-KB979917-x64.msu (Win7) file.
The prerequisites installer will take care of it for you in most cases, but in a controlled environment you do not want everyserver to download every package from the internet.
Either you have full access to internet when setting up your server nd don’t care about downloading them over and obver, then there is no real need to download the files separately or even know here to find them. But, if you are looking for a way to install from local files, then this is the way, use the script download.ps1 at the end of this post to down load all of the prereqs to a specified subfolder, name it PrerequisiteInstallerFiles and you can use the installer script as well.
If you don’t want to run the script, collect the prerequisites one by one:
http://download.microsoft.com/download/C/9/F/C9F6B386-824B-4F9E-BD5D-F95BB254EC61/Redist/amd64/Microsoft%20Sync%20Framework/Synchronization.msi
http://go.microsoft.com/fwlink/?LinkID=141237&clcid=0×409
Microsoft Sync Framework Runtime v1.0 (x64)
http://download.microsoft.com/download/c/c/4/cc4dcac6-ea60-4868-a8e0-62a8510aa747/MSChart.exe
http://go.microsoft.com/fwlink/?LinkID=141512
Microsoft Chart Controls for the Microsoft .NET Framework 3.5
http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe
http://go.microsoft.com/fwlink/?LinkId=131037
Microsoft .NET Framework 3.5 Service Pack 1
http://download.microsoft.com/download/2/8/6/28686477-3242-4E96-9009-30B16BED89AF/Windows6.0-KB968930-x64.msu
http://download.microsoft.com/download/2/8/6/28686477-3242-4E96-9009-30B16BED89AF/Windows6.0-KB968930-x64.msu
Windows PowerShell 2.0
http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu
http://go.microsoft.com/fwlink/?LinkID=166363
Windows Identity Framework (Win2008 R2)
http://download.microsoft.com/download/6/8/1/681F5144-4092-489B-87E4-63F05E95079C/Windows6.0-KB976394-x64.msu
http://go.microsoft.com/fwlink/?linkID=160770
WCF fix for Win2008 SP2
http://download.microsoft.com/download/E/C/7/EC785FAB-DA49-4417-ACC3-A76D26440FC2/Windows6.1-KB976462-v2-x64.msu
http://go.microsoft.com/fwlink/?LinkID=166231
WCF fix for Win2008 R2
http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.0-KB974405-x64.msu
http://go.microsoft.com/fwlink/?LinkID=160381
Windows Identity Framework (Win2008 SP2)
http://download.microsoft.com/download/3/5/5/35522a0d-9743-4b8c-a5b3-f10529178b8a/sqlncli.msi
http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0×409
SQL Server 2008 Native Client
http://download.microsoft.com/download/b/9/a/b9a78047-d269-4a25-88a1-9c4321d90677/SQLSERVER2008_ASADOMD10.msi
http://go.microsoft.com/fwlink/?LinkId=130651&clcid=0×409
Microsoft SQL Server 2008 Analysis Services ADOMD.NET
http://download.microsoft.com/download/1/7/1/171CCDD6-420D-4635-867E-6799E99AB93F/ADONETDataServices_v15_CTP2_RuntimeOnly.exe
http://go.microsoft.com/fwlink/?LinkId=158354
ADO.NET Data Services v1.5 CTP2 (Win2008 SP2)
http://download.microsoft.com/download/B/8/6/B8617908-B777-4A86-A629-FFD1094990BD/iis7psprov_x64.msi
“,
http://go.microsoft.com/?linkid=9655704
IIS management cmdlets
http://download.microsoft.com/download/1/0/F/10F1C44B-6607-41ED-9E82-DF7003BFBC40/1033/x64/rsSharePoint.msi
http://go.microsoft.com/fwlink/?LinkID=166379
SQL 2008 R2 Reporting Services SharePoint 2010 Add-in
http://download.microsoft.com/download/8/D/F/8DFE3CE7-6424-4801-90C3-85879DE2B3DE/Platform/x64/SpeechPlatformRuntime.msi
http://go.microsoft.com/fwlink/?LinkID=166378
Microsoft Server Speech Platform Runtime
http://download.microsoft.com/download/E/0/3/E033A120-73D0-4629-8AED-A1D728CB6E34/SR/MSSpeech_SR_en-US_TELE.msi
http://go.microsoft.com/fwlink/?LinkID=166371
Microsoft Server Speech Recognition Language – TELE(en-US)
Or you can create and run the script download.ps1 mentioned at the bottom of this post. This will put all of the requirement add-on’s into one folder to be used during intall.
For the server roles to be added and configured no extra software is needed.
Applying them:
Ok, to install and apply all of the prerequisites you can choose one out of several options.
Online.
Online will be the simplest way to install the prerequisites, perhaps in a lab or test environemnt, on a single server, but in a real scenario, perhaps not.
Online 1.
Install manually…I guess this is an option but I can’t think of why you would want to…pick the roles you need manually and install them, install all of the add-ons one by one…
This is not a good or safe way to do it, but possible.
Online 2.
The absolutely simplest way, no major braining needed, execute the PrerequisitesInstaller.exe. Done!
It can be that simple…and it usually is. The prerequisites installer is one of the best little helpers you have ever seen, thank you Microsoft for this. It collects all the software and installs them all into the right place. This works…if you are only installing one server, and you have a fast internet connection, and your server is connected to Internet, and you enjoy not having full control…
Normally, if you are installing a single server environment and the server is fully connected to the Internet and all is swell, run the PrerequisitesInstaller and let it fix up the server for you. (For all other scenarios, I would have a look at the Offline section below.)
But, what if you were…offline…
Offline.
Offline is a completely different matter. The PrerequisitesInstaller.exe is still a great tool and you will want to use it, but you need to do some thinking first. How will the Installer get the files it needs to install if it can’t download them from the internet?
Offline 1.
Run the prerequisitesinstaller with an Arguments file in order to use the add-on files you have downloaded.
Create a textfile, name it PrerequisitesInstaller.Arguments.txt (Important! this has to be exactly right) and paste the second scripttext located at the end of this post.
Offline 2.
Create and run a script that will do it all for you, add the roles, use the local files….
This is a pretty good solution, it will be the same every time and you will only download the files once. The indiciduals installing SharePoint can only be told to run a script that does it all.
In order to do this, you can create a textfile, name it installPrerequisitesFromShare.ps1 and paste the code under InstallPrerequisitesFromFileshare.ps1 at the bottom of the post. This script assumes that you have all of the requirements in one folder located in a subfolder named PrerequisiteInstallerFiles. This method works very well and will install it all for you, you will only have to execute one powershellscript and it will install it all, roles, add-ons and all.
What if:
You uninstall SharePoint from the server, what then?
I will try to ad dmore value here later, but I can say one thing for certain now, uninstall SharePoint and the RSservice will be broken. The Resporting services add on for SharePoint, installs before SHarePoint, during SharePoint install(or before?) it adds a lot of folders and files under the 14 Hive. If you uninstall SHarePoint and delete the 14 hive to get the server clean, you will have to first uninstall the rsservice, then install it again, then reinstall SharePoint.
You uninstall a prereq, what then?
This will hopefully be covered later. Time did not permit it at this point in time.
* * * * SCRIPTS * * * *
Paste into a textfile, rename to: ‘download.ps1′.
Start copy ‘download.ps1′ here:
Import-Module BitsTransfer ## Prompt for the destination path $DestPath = Read-Host -Prompt "- Enter the destination path for downloaded files" ## Check that the path entered is valid If (Test-Path "$DestPath" -Verbose) { ## If destination path is valid, create folder if it doesn't already exist $DestFolder = "$DestPath\PrerequisiteInstallerFiles" New-Item -ItemType Directory $DestFolder -ErrorAction SilentlyContinue } Else { Write-Warning " - Destination path appears to be invalid." ## Pause Write-Host " - Please check the path, and try running the script again." Write-Host "- Press any key to exit..." $null = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown") break } ## We use the hard-coded URL below, so that we can extract the filename (and use it to get destination filename $DestFileName) ## Note: These URLs are subject to change at Microsoft's discretion - check the permalink next to each if you have trouble downloading. $UrlList = (" http://download.microsoft.com/download/C/9/F/C9F6B386-824B-4F9E-BD5D-F95BB254EC61/Redist/amd64/Microsoft%20Sync%20Framework/Synchronization.msi ", # http://go.microsoft.com/fwlink/?LinkID=141237&clcid=0x409 - Microsoft Sync Framework Runtime v1.0 (x64) " http://download.microsoft.com/download/c/c/4/cc4dcac6-ea60-4868-a8e0-62a8510aa747/MSChart.exe ", # " http://go.microsoft.com/fwlink/?LinkID=141512 " - Microsoft Chart Controls for the Microsoft .NET Framework 3.5 " http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe ", # http://go.microsoft.com/fwlink/?LinkId=131037 - Microsoft .NET Framework 3.5 Service Pack 1 " http://download.microsoft.com/download/2/8/6/28686477-3242-4E96-9009-30B16BED89AF/Windows6.0-KB968930-x64.msu ", # " http://download.microsoft.com/download/2/8/6/28686477-3242-4E96-9009-30B16BED89AF/Windows6.0-KB968930-x64.msu " - Windows PowerShell 2.0 " http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu ", # " http://go.microsoft.com/fwlink/?LinkID=166363 " - Windows Identity Framework (Win2008 R2) " http://download.microsoft.com/download/6/8/1/681F5144-4092-489B-87E4-63F05E95079C/Windows6.0-KB976394-x64.msu ", # http://go.microsoft.com/fwlink/?linkID=160770 - WCF fix for Win2008 SP2 " http://download.microsoft.com/download/E/C/7/EC785FAB-DA49-4417-ACC3-A76D26440FC2/Windows6.1-KB976462-v2-x64.msu ", # http://go.microsoft.com/fwlink/?LinkID=166231 - WCF fix for Win2008 R2 " http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.0-KB974405-x64.msu ", # " http://go.microsoft.com/fwlink/?LinkID=160381 " - Windows Identity Framework (Win2008 SP2) " http://download.microsoft.com/download/3/5/5/35522a0d-9743-4b8c-a5b3-f10529178b8a/sqlncli.msi ", # " http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409 " - SQL Server 2008 Native Client " http://download.microsoft.com/download/b/9/a/b9a78047-d269-4a25-88a1-9c4321d90677/SQLSERVER2008_ASADOMD10.msi ", # " http://go.microsoft.com/fwlink/?LinkId=130651&clcid=0x409 " - Microsoft SQL Server 2008 Analysis Services ADOMD.NET " http://download.microsoft.com/download/1/7/1/171CCDD6-420D-4635-867E-6799E99AB93F/ADONETDataServices_v15_CTP2_RuntimeOnly.exe ", # " http://go.microsoft.com/fwlink/?LinkId=158354 " - ADO.NET Data Services v1.5 CTP2 (Win2008 SP2) " http://download.microsoft.com/download/B/8/6/B8617908-B777-4A86-A629-FFD1094990BD/iis7psprov_x64.msi ", # http://go.microsoft.com/?linkid=9655704 - IIS management cmdlets " http://download.microsoft.com/download/1/0/F/10F1C44B-6607-41ED-9E82-DF7003BFBC40/1033/x64/rsSharePoint.msi ", # http://go.microsoft.com/fwlink/?LinkID=166379 - SQL 2008 R2 Reporting Services SharePoint 2010 Add-in " http://download.microsoft.com/download/8/D/F/8DFE3CE7-6424-4801-90C3-85879DE2B3DE/Platform/x64/SpeechPlatformRuntime.msi ", # http://go.microsoft.com/fwlink/?LinkID=166378 - Microsoft Server Speech Platform Runtime " http://download.microsoft.com/download/E/0/3/E033A120-73D0-4629-8AED-A1D728CB6E34/SR/MSSpeech_SR_en-US_TELE.msi " # http://go.microsoft.com/fwlink/?LinkID=166371 - Microsoft Server Speech Recognition Language - TELE(en-US) ) ForEach ($Url in $UrlList) { ## Get the file name based on the portion of the URL after the last slash $DestFileName = $Url.Split('/')[-1] Try { ## Check if destination file already exists If (!(Test-Path "$DestFolder\$DestFileName")) { ## Begin download Start-BitsTransfer -Source $Url -Destination $DestFolder\$DestFileName -DisplayName "Downloading `'$DestFileName`' to $DestFolder" -Priority High -Description "From $Url..." -ErrorVariable err If ($err) {Throw ""} } Else { Write-Host " - File $DestFileName already exists, skipping..." } } Catch { Write-Warning " - An error occurred downloading `'$DestFileName`'" break } } ## View the downloaded files in Windows Explorer Invoke-Item $DestFolder ## Pause Write-Host "- Downloads completed, press any key to exit..." $null = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")
:End copy ‘download.ps1‘ here.
Paste below into a textfile, name it ‘PrerequisitesInstaller.Arguments.txt‘ and put it in your SharePoint media folder, same folder as the PrerequisitesInstaller.exe. The string has to be formatted exactly like it is here, with a single newline and a space between each argument and nothing else.
Start copy ‘PrerequisitesInstaller.Arguments.txt‘ here:
/SQLNCli:Prerequisites\sqlncli.msi /ChartControl:Prerequisites\MSChart.exe /Sync:Prerequisites\Synchronization.msi /KB976462:Prerequisites\Windows6.1-KB976462-v2-x64.msu /IDFXR2:Prerequisites\Windows6.1-KB974405-x64.msu /FilterPack:Prerequisites\FilterPack\FilterPack.msi /ADOMD:Prerequisites\SQLSERVER2008_ASADOMD10.msi /ReportingServices:Prerequisites\rsSharePoint.msi /Speech:Prerequisites\SpeechPlatformRuntime.msi /SpeechLPK:Prerequisites\MSSpeech_SR_en-US_TELE.msi /NETFX35SP1:Prerequisites\dotnetfx35.exe
:End copy ‘PrerequisitesInstaller.Arguments.txt‘ here.
Paste below into a textfile, name it ‘InstallPrerequisitesFromFileshare.ps1′
Start copy ‘InstallPrerequisitesFromFileshare.ps1′ here:
# get current folder $folder = Get-Location # install requirements Start-Process "$folder\PrerequisiteInstaller.exe" -Wait -ArgumentList "/unattended ` /SQLNCli:`"$folder\PrerequisiteInstallerFiles\sqlncli.msi`" ` /ChartControl:`"$folder\PrerequisiteInstallerFiles\MSChart.exe`" ` /NETFX35SP1:`"$folder\PrerequisiteInstallerFiles\dotnetfx35.exe`" ` /PowerShell:`"$folder\PrerequisiteInstallerFiles\Windows6.0-KB968930-x64.msu`" ` /KB976394:`"$folder\PrerequisiteInstallerFiles\Windows6.0-KB976394-x64.msu`" ` /KB976462:`"$folder\PrerequisiteInstallerFiles\Windows6.1-KB976462-v2-x64.msu`" ` /IDFX:`"$folder\PrerequisiteInstallerFiles\Windows6.0-KB974405-x64.msu`" ` /IDFXR2:`"$folder\PrerequisiteInstallerFiles\Windows6.1-KB974405-x64.msu`" ` /Sync:`"$folder\PrerequisiteInstallerFiles\Synchronization.msi`" ` /FilterPack:`"$folder\PrerequisiteInstallerFiles\FilterPack\FilterPack.msi`" ` /ADOMD:`"$folder\PrerequisiteInstallerFiles\SQLSERVER2008_ASADOMD10.msi`" ` /ReportingServices:`"$folder\PrerequisiteInstallerFiles\rsSharePoint.msi`" ` /Speech:`"$folder\PrerequisiteInstallerFiles\SpeechPlatformRuntime.msi`" ` /SpeechLPK:`"$folder\PrerequisiteInstallerFiles\MSSpeech_SR_en-US_TELE.msi`""
:End copy ‘InstallPrerequisitesFromFileshare.ps1′ here.
* * * * END SCRIPTS * * * *
SharePoint 2010 Language packs, finding them, collecting them and deploying them
A few thousand years ago, humans were a race of hunter/gatherers. We also lived in caves and were a very simple and crude race. At times when working with SharePoint, you can find that the old mindset is coming back…if only for a few seconds.
Language Packs.
I have been in the situation myself where I find myself lost regarding language packs, so I was forced to find all these things out and here are my findings for you to reuse at will.
This post will not cover what language to use when and when you need to do some more work to get a site completely localized, that is for another post. This is about deploying them, getting the correct bits onto the servers and getting them to work.
What do I need to install:
First: Technet states that: SharePoint Foundation 2010 language packs are not required for SharePoint Server 2010.(Deploy language packs (SharePoint Server 2010))
Perhaps there are different opinions as there are about what to install regarding CU’s, but I have followed this advise without any issues or missing language bits.
Now, you have a series of different LP’s and namings are different in different places, I’ll focus on the clean SharePoint 2010 Foundation and Server. No Project or other unrelated stuff touched here…
At the very end of this post you will find the complate list of Languages available. (Updated 11-11-04)
1. Foundation:
You need the Language Pack files for the language you need to have present in your sites. English, German, French, Arabic…at this point in time, I would recommend that you install the LP and its SP1.
2. Server
The same goes for Foundation as well as for server.
Find the binaries:
Correct me if you think that I’m wrong, but it was never easy to find the files you need. I have simply collected the links you need in one place.
1. Foundation
Language Packs for SharePoint Foundation 2010
http://www.microsoft.com/download/en/details.aspx?id=4731
Service Pack 1 for Microsoft SharePoint Foundation 2010 Language Pack (KB2460059) (Naming is brilliantly describing, thank you Microsoft)
http://www.microsoft.com/download/en/details.aspx?id=26629
Description from Microsoft, judging by the english LPSP1 at 9MB there has not been many updates which is a good thing:
Service Pack 1 (SP1) for Microsoft SharePoint Foundation 2010 Language Pack contains new updates which improve security, performance, and stability.
Additionally, the SP is a roll-up of all previously released updates.
The KB:
http://support.microsoft.com/kb/2460059
See Server for details on the actual downloads. Difference here is that the name of the complate package for foundation is ‘SharePointLanguagePack.exe’ instead of ‘ServerLanguagePack.exe’ for Server. I would rename the ‘SharePointLanguagePack.exe’ to ‘SPFoundationLanguagePack_en-us.exe’ . The LPSP1 for foundation has a nice spf in front of it (spflanguagepack2010sp1-kb2460059-x64-fullfile-en-us.exe), placing it on your foundation servers. Although, maybe ‘FoundationLanguagePackSP1_en-us.exe’ would be easier and more explaining…
2. Server
2010 Server Language Packs for SharePoint Server 2010, Project Server 2010, Search Server 2010, and Office Web Apps 2010 (is the ‘short’ name of this LP)
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=3411
Service Pack 1 for Server Language Pack 2010 (KB2460056) (again, naming is a bit off…no mentioning of SharePoint which can throw you off a bit…)
http://www.microsoft.com/download/en/details.aspx?id=26621
The KB:
http://support.microsoft.com/kb/2460056
The design of the downloadpage will change based on what language you select, and in a few languages you must press ‘Change’ or the button that corresponds in that language. After you have pressed change, or as in for example the english page, that will redirect on the dropdown-select and a click on the page, you can start the download (you will get it). The file you will get is named ‘ServerLanguagePack.exe’ no matter what language it is for. A nice best practise is to rename it during or after it is downloaded to something like SPServerLanguagePack_en-us.exe or similar, so that you can separate your different language pack files later on.
For the Language Pack Service Pack 1, you obviously have something completely different. The site will look a little different but generally the same, it will just like the LP page look different in different languages, so that needs no further description.
What is really different is the files you get. They are here named as: serverlanguagepack2010sp1-kb2460056-x64-fullfile-en-us.exe, Obviously…I rename them simply ServerLanguagePackSP1_en-us.exe as they will most likely end up together in one folder.
All download pages and packages are localized in itself, so if you need to install for example an arabic LP and don’t speak arabic, make sure to memorize the location and meaning of the buttons, but also remember that they will be mirrored.
Install the binaries:
1. Foundation
This is the official technet version:
http://technet.microsoft.com/en-us/library/cc288518.aspx
Use any method you prefer, clicking on them one by one and wait for it to finish, then click the next, and so on. Or…you do as I usually do, create a script. In a multitier farm this is essential so that you can save time to do other great things.
My simple script looks like this for the Swedish and German LP’s + LPSP1: (saved in a text file as Install_LP.cmd)
“C:\Updates Binaries\SPFoundationLanguagePack_sv-se.exe” /quiet
“C:\Updates Binaries\SPFoundationLanguagePack_de-de” /quiet
“C:\Updates Binaries\SPFoundationLanguagePackSP1_sv_se.exe” /quiet
“C:\Updates Binaries\SPFoundationLanguagePackSP1_de-de.exe” /quiet
Install the binaries on every Application and Web server in your farm!
This is the only approach that will be accepted when you want to run the PSConfig/Config Wizard to finalize the update in the farm. The technet instruction above is a bit shaky on this particular subject but this is a fact, you need the exact same Language Packs’s on all of your servers, except off course the Database servers and the email servers…
In order to run PSConfig, I also use a script to do it, save a text file in the same folder as the updates and name it Install_PSConfig.cmd (or something you like better). It needs a single line:
“C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN\psconfig” -cmd upgrade -inplace b2b -wait
Direct it to where your 14 Hive is located. This way, you don’t have to look up the exact functions of the PSConfig tool every time…
(if you have a multitier farm with many servers, store the scriptfiles on a fileshare and the path will be the same on all servers, you will also only have to update it in one place.)
2. Server
This is the official technet version:
http://technet.microsoft.com/en-us/library/cc262108.aspx
Same store as for FOundation, the files are different but the method needs to be the same. The script would now look something like:
“C:\Updates Binaries\SPServerLanguagePack_sv-se.exe” /quiet
“C:\Updates Binaries\SPServerLanguagePack_de-de” /quiet
“C:\Updates Binaries\SPServerLanguagePackSP1_sv_se.exe” /quiet
“C:\Updates Binaries\SPServerLanguagePackSP1_de-de.exe” /quiet
(The SP1′s takes very long time to apply…if memory serves me right)
Slipstreaming the SharePoint Language Packs, do or not to do?
During the SharePoint installation, the answer is NO! Not supported, can’t do it! The /Updates folder is only for SharePoint updates and SharePoint updates alone, ServicePacks and Cumulative updates and the likes, functional add-ons like LP’s not included. Try it if you will, but it will simply not work.
During the Language Pack installation…given the way I do it with a silent script, I would say Do NOT. Slipstreaming the LP updates is possible but it does not really save you a lot of time and I know that there have been issues. You will easily loose more than you win.
Verify:
After you have found, downloaded and installed your Languages, how do you see that they are installed at all…? There are a few places to look.
Control panel on one of your SharePoint Web or Application servers:
The Language Pack.
View in Control Panel, Uninstall or change a program
The Language Pack Service Pack 1
View in Control Panel, Uninstall an Update
In CA you will find information on upgrades in 3 places, Servers in farm, Check Product And Patch Istallation Status and Check Upgrade Status. If your Check Upgrade statyus looks like this you can relax, for this time…
All Done!
I almost forgot! Powershell. Check out installed and missing updates by running:
Get-SPProduct | select *
and
Get-SPProduct | select -ExpandProperty PatchableUnitDisplayNames
(Requires that you first run add-pssnapin Microsoft.SharePoint.powershell)
Summary
There are probably things that should be here that I have missed, or that you think is incorrect or that should be included. Please let me know so that I can correct this and make this a better place of information on Language pack finding, collection and deployment.
1 down, at least 3500 steps left to get your ultimate SharePoint 2010 farm in order…
List of available languages (list updated September 16, 2010 at
http://technet.microsoft.com/en-us/library/ff463597.aspx
)
Arabic 1025
Basque 1069
Bulgarian 1026
Catalan 1027
Chinese (Simplified) 2052
Chinese (Traditional) 1028
Croatian 1050
Czech 1029
Danish 1030
Dutch 1043
English 1033
Estonian 1061
Finnish 1035
French 1036
Galician 1110
German 1031
Greek 1032
Hebrew 1037
Hindi 1081
Hungarian 1038
Italian 1040
Japanese 1041
Kazakh 1087
Korean 1042
Latvian 1062
Lithuanian 1063
Norwegian (Bokmål) 1044
Polish 1045
Portuguese (Brazil) 1046
Portuguese (Portugal) 2070
Romanian 1048
Russian 1049
Serbian (Latin) 2074
Slovak 1051
Slovenian 1060
Spanish 3082
Swedish 1053
Thai 1054
Turkish 1055
Ukrainian 1058
