After usage reporting is enabled, site administrators and site collection administrators can view site usage summary pages that have the following information for their sites and site collections (SpUsageSite.aspx):
- Requests and queries in the last day and the last 30 days.
- Average number of requests per day over the last 30 days.
- A chart of requests per day over the last 30 days.
- A list of the top page requests over the last 30 days.
- A list of top users over the last 30 days.
- A chart of top referring hosts over the last 30 days.
- A chart of top referring pages over the last 30 days.
- A list of top destination pages over the last 30 days.
- Top queries for the last 30 days (if search usage reporting is enabled).
- Search results top destination pages (if search usage reporting is enabled).
- Number of queries per day over the previous 30 days.
- Number of queries per month over the previous 12 months.
- Top queries over the previous 30 days.
- Top site collections originating queries over the previous 30 days.
- Queries per search scope over the previous 30 days.
- Total amount of storage used by the site collection.
- Percent of storage space used by Web Discussions.
- Maximum storage space allowed.
- Number of users for all sites in the hierarchy.
- Total hits and recent bandwidth usage across all sites.
Enable Office SharePoint Usage Reporting
After Windows SharePoint Services usage logging is enabled in the server farm, SSP administrators must enable the Office SharePoint Usage Reporting service. SSP administrators can control the complexity of usage analysis processing, and select whether or not reporting is enabled for search queries. Please refer the following steps to enable portal usage reporting:
- On Central Administration home page, click the Shared Service Provider listed under Shared Services Administration in the Quick Launch bar.
- On the SSP home page, in the Office SharePoint Usage Reporting section, click Usage reporting.
- On the Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing.
- In the Search Query Logging section, select Enable search query logging.
- Click OK.
Note: If advanced usage analysis processing is not selected, usage reporting statistics will be minimal.
Reset Internet Information Server
- Go to the Start button and click Run
- Type IISReset and click OK.
Activate Office SharePoint Usage Reporting
After Office SharePoint Usage Reporting is enabled for the SSP, site collection administrators must activate the reporting feature. Until the reporting feature is activated on a site collection, usage reports are not available.
Please refer the following steps to activate the reporting feature:
- On the Site Actions menu, click Site Settings.
- On the Site Settings page, in the Site Collection Administration section, click Site collection features.
- On the Site Collection Features page, click the Activate button for the Reporting feature.
More Information
Whenever Usage Analysis is enabled, the Web Application Servers begin creating usage analysis logs in the ' ' path. There will be a separate folder named with a GUID that represents the web application. Within each of these folders will be a subfolder for each days logs which in turn contains usage logs in the format 01.log, 02.log etc. The usage analysis job runs against the data collected from the previous day(s) logs. For this reason running the Usage Analysis job more than once per day will not update usage data.
- On a high level, this is how the usage reports are generated
- IIS keeps all the SharePoint usage records in memory and will only dump it into physical file (the usage log) when memory is full or IISRESET
- By default, MOSS has daily timer job (Office SharePoint Usage Analytics Log Import ) to process these physical files into database's temp usage tables
- Be default, MOSS has another hourly or minutely timer job (Office SharePoint Usage Analytics Processing) that process data in those temp/shadow tables into the real usage tables.
- Once this is completed, usage report would then be available for viewing.
In MOSS, the two important timer jobs which are responsible for parsing, processing and updating the SSP DB (the ANL tables) are
‘Office SharePoint Usage Analytics Log Import’ and 'SharePoint Usage Analytics Log processing'.
These jobs run on each WFE in the farm on a daily basis to process the data in the shadow tables and write the final usage data into another set of tables like ANLHit.
‘Office SharePoint Usage Analytics Log Import’ job is responsible for parsing and populating the usage report data in the SSP DB’s analytics tables (that use the ANL prefix) and runs daily to pick up yesterday and only yesterday’s usage log files and parse them into the SSP table like 'ANLShadowHit' while 'SharePoint Usage Analytics Log Processing' job runs on hourly or minutely basis to process the data in the above shadow tables and write the final usage data into another set of tables like ANLHit.
The following categories are the most relevant for usage reports
- Office SharePoint Usage Analytics Processing
- Office SharePoint Usage Analytics Log Import
- Microsoft.SharePoint.Administration.SPUsageAnalysisJobDefinition
- Microsoft.SharePoint.Portal.Analytics.UsageProcessingJobDefinition
- Microsoft.SharePoint.Portal.Analytics.LogImportJobDefinition
Report pages
- View site collection reports > http://sitecollection/_layouts/SpUsageSite.aspx
- View site reports > http://sitecollection/_layouts/SpUsageWeb.aspx
- Site Usage Report > http://sitecollection/_layouts/usageDetails.aspx
- Site Usage Summary > http://sitecollection//Usage.aspx
- The http://_layouts/usageDetails.aspx even shows you the total hits for the documents which are very useful information.
- usage.aspx
- usageDetails.aspx
- SpUsageSite.aspx
- SpUsageWeb.aspx
- SpUsageSiteQueries.aspx
- SpUsageSiteResults.aspx
No comments:
Post a Comment