SharePoint 2013: How to Configure the Usage Service Application using PowerShell

Last Updated March 28, 2014  


Description

This post describes how to configure the SharePoint Server 2013 Usage Service Application using PowerShell.


Solution

1)  Plan and Document the Naming Convention.
Document a naming convention for each of the Service Application components.  

Example:
Application Pool Service Account:  Domain\SvcAccount (this should already be created)
Application Pool: SvcApp_SPServiceApplicationPool_02 (this should already be created)
Service Application: SvcApp_SPUsageApplication_01
Service Application Database:  SvcApp_SPUsageApplication_01_DB_01 
Service Application Proxy:  SvcApp_SPUsageApplication_01_Proxy_01

2)  Open the SharePoint 2013 Management Shell. 

3)  Verify the Name of the Application Pool.
Get-SPServiceApplicationPool | Select Name

4)  Get the existing Application Pool.
$SvcAppPool02 = Get-SPServiceApplicationPool "SvcApp_SPServiceApplicationPool_02"

5)  Create the Service Application and assign it to the Application Pool.
$SvcApp = New-SPUsageApplication –Name “SvcApp_SPUsageApplication_01” -DatabaseName "SvcApp_SPUsageApplication_01_DB_01" –DatabaseServer “SQL Alias Name” 

The Proxy is created automatically when the New Service Application cmdlet is run.  It does not appear that the name of the Proxy may be set or changed independently for this Service Application at the time of creation.

6)  Verify Service Application.
Get-SPServiceApplication | Select Name 

7) Verify Service Application Proxy.
Get-SPServiceApplicationProxy | Select Name   

8) Get the Usage and Health Data Collection Proxy.
$SvcAppProxy = Get-SPServiceApplicationProxy | Where {$_.TypeName -like “Usage and Health*”}

9) Start the Usage and Health Data Collection Proxy.
$SvcAppProxy.Provision()

References

Microsoft TechNet (2012).  New-SPUsageApplication.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ff607699.aspx.

Microsoft TechNet (2012).  Service application cmdlets in SharePoint 2013.  Retrieved January 22, 2014 from http://technet.microsoft.com/en-us/library/ee906561.aspx.

Microsoft TechNet (2012).  SharePoint 2013 - Service Applications.  Retrieved January 22, 2014 from http://social.technet.microsoft.com/wiki/contents/articles/12512.sharepoint-2013-service-applications.aspx.