Web analytics:: Where are the reports?

Web analytics is a great tool to get an insight of what´s going on in our farm at performance level . Sometimes when the customer asks me where to find a specific report after a while I find myself looking in every possible place where those reports are available and I waste some time looking for them. So here it goes, a collection of where to find the reports, it shouldn´t take me time to find them now!

Localization of the Reports:

Site collection/site > Site´s configuration > acciones del sitio >
	informes de web analytics del sitio
	Informes de web analytics of the Site  Collection
Central Administration > Search service application > Web analytics
Central Administration > Monitoring >  Reporting: Web Analytics : reports by web application
Central Administration > Monitoring > Reporting: View health reports:
	Slowest pages
	Top Active Users

This post (thanks!!) explains how to get the Slowest Pages report quering the DB:

If you need you can get top slowest pages directly from Usage and Health Data Collection database (WSS_UsageApplication by default) calling proc_GetSlowestPages stored procedure

declare @webApp uniqueidentifier

select @webApp = WebApplicationId from dbo.RequestUsage where ServerUrl = 'http://myWebApplicationUrl'

declare @stime datetime

declare @etime datetime

set @stime = getDate() - 10

set @etime = getDate()

exec dbo.proc_GetSlowestPages

@StartTime = @stime,

@EndTime = @etime,

@WebApplicationId = @WebApp,

@MachineName = null

 

In this great post you might find details regarding to each report: http://blogs.msdn.com/b/ecm/archive/2010/05/03/web-analytics-in-sharepoint-2010-insights-into-reports-and-metrics.aspx