Recovery Manager for SharePoint Premier Edition
Migration Manager for Sharepoint
Server Administrator for SharePoint
Migration Suite for SharePoint
Migrator for SharePoint Online
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?
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.