[SDP 5][ED2CCC6C-B080-4B65-BE51-5F99F1BE39E8] SharePoint Web Analytics Troubleshooter (SPWebAnalytics)

Summary
This SharePoint Web Analytics (SPWebAnalytics) manifest detects certain problematic conditions that may exist with Web Analytics in Microsoft SharePoint Server 2010 and Microsoft SharePoint Server 2013.

This article describes the operation of this manifest file. 

Required permissions

The rules in the diagnostic package use the SharePoint Windows PowerShell snap-in to get information about your farm. Therefore, the account that is used to run the diagnostic package must either be the farm account or have been given the required permissions through the Add-SPShellAdmin command. Note that the farm account is the account under which the timer service and central administration site's application pool are running.

Some rules in this diagnostic package must also have local server administrative privileges to use remote and local administrative tools and also to access secure system locations such as the registry. The following table can be used to reference the permissions that are required for each rule. 
Permission codeDescriptionRequired permission
1 Use SharePoint Windows PowerShell cmdlets to interact with the SharePoint farm.Farm administration
2 Run queries against SharePoint databases.Farm administration
3 Access server administrative tools.Server administrative
4 Access files and other resources on the server.Server administrative
This article describes the information that may be collected from a computer when you run SPWebAnalytics.
More information
Description File Name
This is the actual results of the SPWebAnalytics manifest. This is what is displayed to the user to indicate that status of each rule that is executed.ResultReport.xml
This is the internal file generated as a by-product of the execution of the manifest. It contains no customer data.Results.xml
This is an xlst transform that formats the results in the ResultReport.xml file. It contains no customer data.Results.xsl
This file contains additional debug information for the manifest execution. It may contain customer data. However, every attempt has been made to minimize the amount.SPWebAnalytics.O.debugreport.xml
This file contains debug information that may be generated during the execution of the manifest. It also contains timings on each of the rules that are run. It may contain customer data. However, every attempt has been made to minimize the amount.Stdout.log
This file contains the environmental information for each computer in the farm. The information that is captured includes the following:
  • Computer name
  • Operating system name
  • Last reboot/uptime
  • Computer model
  • Processors
  • Computer domain
  • Role
  • Operating system language
  • Time zone
  • Total RAM
  • Drives (total and free space available)
%COMPUTERNAME%_cfg_%LANG%_FarmEnvironment.txt
This file contains SQL Server information from the SQL instance that hosts the SharePoint Configuration database. The information that is captured includes the following:
  • ProductVersion
  • ProductLevel
  • Edition
  • ServerName
  • InstanceName
  • MaxDegreeOfParallelism
  • LastUpdateDate
  • IsClustered
  • IsFullTextInstalled
  • IntegratedSecurity
%COMPUTERNAME%_cfg_%LANG%_FarmEnvironment.txt
This file contains the SharePoint information about each computer in the farm. The information that is captured includes the following:
  • SharePoint Configuration Database info
  • SharePoint services on server
%COMPUTERNAME%_cfg_%LANG%_FarmInformation.txt

System logs

Rule IDTitleDescription
Basic system information
3CAE6F84-C3F5-4DB2-80D1-66C15B7BEF2EFarm environment
FB2C97D5-3681-49B8-972F-8EF0379D7F80Farm Information


Analytics for SharePoint 2010

Rule IDTitleRequired PermissionsDescription
27E640FE-76FB-424D-8D2A-DA5AA3EC63C0Check dbo account for Web Analytics Staging Database1, 2
C77C20EF-E1BC-4ED1-8905-C38819DEC30BCheck if State Service App Exists1http://technet.microsoft.com/library/ee704548.aspx
6E27B8FF-9641-4771-A791-F1E87E3CC395Check if State Service App is online1http://technet.microsoft.com/library/ee704548.aspx
D06406D6-1C82-4382-962E-2E0F1A2524A2Check if State Service App Database exists in SharePoint1http://technet.microsoft.com/library/ee704548.aspx
005E4AE4-4F0A-4A78-A3E6-45B4AED984E3Check if State Service App Database exists in SQL1http://technet.microsoft.com/library/ee704548.aspx
0CB953A1-1454-41AC-99FC-B90709D555B4Check status of Usage and Health Data Collection Proxy1
89477BC6-2D52-4EFA-88DF-70D9EFB16C7BCheck if Usage Health Data Log location is accessible1
575644E0-13A2-4C71-B716-765C328F2D4ECheck status of Usage and Health Data Collection Service1
2B5D32EA-722D-4950-B3A2-0573A8639048Check LastLoggingExtractionTime and LastAggregationTime1, 2http://blogs.msdn.com/b/sharepoint_strategery/archive/2012/03/16/troubleshooting-sharepoint-2010-web-analytics.aspx
C6502BA7-7CAD-44D9-9A12-80A3FF54355ECheck if Web Analytics Service App Exists 1http://technet.microsoft.com/library/gg266382.aspx
E4FBC135-5A3E-462B-A09E-D6174FE17E52Check if Web Analytics Service App is Online1http://technet.microsoft.com/library/gg266382.aspx
1140A34E-6FB1-441B-BBE5-440D71B1BEB5Check if Web Analytics Service App Proxy Exists1http://technet.microsoft.com/library/gg266382.aspx
F0A9A30F-89BA-4C36-9F7D-8B80E66880CECheck if Web Analytics Service App Proxy is Online1http://technet.microsoft.com/library/gg266382.aspx
E925549B-6379-4768-948A-7AAB8585A91DWeb Analytics Service App Informational Rule1http://technet.microsoft.com/library/ff608102(v=office.14).aspx
EF24B664-72AA-44FE-89E9-29CC182BFE83Check if Web Analytics Web Service Instance is started 1http://technet.microsoft.com/library/ee704549(v=office.14).aspx
D862B13C-72CA-46F1-9CE9-8E34BEA1B9D8Check if Web Analytics Data Processing Service Instance is started 1http://technet.microsoft.com/library/ee704549(v=office.14).aspx
0A6B6F85-A86A-4055-A9FE-2E6C2B3023ECCheck if Usage and Web Analytics Timer Jobs exist1
0BDE296B-989A-4747-9F1B-9413C2AFE90BCheck if Usage and Web Analytics Timer Jobs have ran recently1
0CDC5445-AB25-4C02-9F6C-706D9B710FF3Check if Usage and Web Analytics Timer Jobs are enabled 1
A9C1511C-AF45-4DB4-9456-A858817623F3Check if Usage Definitions exist1
A9C2B04A-530A-4BDB-8990-57E619FA5C1ACheck if Usage Definition receivers are enabled1
A9C574B1-2086-427D-B7BD-486A9E45A7F0Check if Usage Definitions are enabled1
74B418B9-84CD-491D-9251-A0B6C572FCE5Check SharePoint application pool .Net Framework version1, 4


Analytics for SharePoint 2013


Rule IDTitleRequired PermissionsDescription
0CB953A1-1454-41AC-99FC-B90709D555B4Check status of Usage and Health Data Collection Proxy1
575644E0-13A2-4C71-B716-765C328F2D4ECheck status of Usage and Health Data Collection Service1
A9C1511C-AF45-4DB4-9456-A858817623F3Check if Usage Definitions exist1
A9C2B04A-530A-4BDB-8990-57E619FA5C1ACheck if Usage Definition receivers are enabled1
A9C574B1-2086-427D-B7BD-486A9E45A7F0Check if Usage Definitions are enabled1
74B418B9-84CD-491D-9251-A0B6C572FCE5Check SharePoint application pool .Net Framework version1, 4
0035FD9A-4924-4227-AF8D-57E33BDE5CABCheck if Usage or Web Analytics Timer Job is removed from the farm1
00421F8F-7922-44A9-BE1E-80C5BD18781ECheck if Usage or Web Analytics Timer Job has ran recently, within it's schedule1
00B78160-394F-46EF-9BB7-FAD52E05EB0CCheck if Usage or Web Analytics Timer Job schedule is changed from default1
00F58998-9E18-41A6-8B7F-F49DEB175A73Check if Usage or Web Analytics Timer Job is Online1
3913E70E-980D-4AF1-99DE-613ACFC27942Check if Usage Analysis State is Paused or Failed1
EBAAB241-277F-4FAE-B099-4C7918CE915ECheck Tail Trimming for Views and Search Queries1https://technet.microsoft.com/library/dn794239.aspx
B4B9A380-CABC-44EC-9379-5AA7B456F4A0Check Usage Definition for Max Total Size and Retention Period1


References
973559 Frequently asked questions about the Microsoft Support Diagnostic Tool (MSDT) when it is used with Windows 7 or Windows Server 2008 R2
SharePoint Web Analytics SPWebAnalytics
Properties

Article ID: 2916970 - Last Review: 11/03/2015 22:59:00 - Revision: 15.0

Microsoft SharePoint Foundation 2010, Microsoft SharePoint Server 2010

  • kbprosharepoint kbdiagnostics KB2916970
Feedback