Where is the Site Hits information stored? - SharePoint Management - SharePoint for All - Dell Community

Where is the Site Hits information stored?

Where is the Site Hits information stored?

This question is not answered

I am working to develop a custom SQL report using Site URL and Hits (daily, monthly and queterly). I could not find the table which stores the Site ID and Hits information.

Does anyone knows where it is?

All Replies
  • Current version (4.5.1 or higher) of Site Administrator for SharePoint does not store this info in SQL. It aggregates information requested from SharePoint databases.

    SharePoint 2007 store this info as BLOB structure in DailyUsageData field of AllWebs table.

    SharePoint 2010 Foundation has WSS_Logging database for hits and also supports DailyUsageData field.

    SharePoint 2010 Server makes additional aggregation and put info to webanalytics_reporting database.