Tuesday, 21 October Sharepoint web analytics reports are not getting updated If you ever tried to change the processing schedule or manually run the processes for the SharePoint Web Analytics, you probably realized fairly quickly that it is a less-than-intuitive and rather frustrating endeavor.
Hopefully this post can demystify some of the moving pieces for you. Web Analytics has several timer jobs. Web Analytics data is, by nature, a reporting mechanism with a daily granularity i. It is responsible for collecting site inventory information from each site collection in the farm. It is responsible for importing usage data into the logging database. It is responsible for processing data that has been accumulated in the Staging database.
It is responsible for starting the workflows that allow for automatic distribution of analytic reports. This property is set via PowerShell. By default, the property is set to an integer value of 3 3 am. If your numbers have ever been incorrect and you tried to manually run the timer jobs, you would have seen that the Web Analytics reports did not update. That is because the Report Consolidation needs to execute before the reports get re-generated.
Finally, run the final timer job to distribute the reports, if your users are leveraging that functionality. Force an update of Web Analytics With the service Web Analytics in SharePoint you can either see statistics reports in Central Administration or retreive information from it to display on your pages.
There is one big drawback. The statistics are updated only once a day, and this cannot be changed anywhere in Central Administration. To check what the current settings of your Web Analytics service application, use the following Power Shell command: It is possible to change the time when the update is made with the following Power Shell command: Note that the number, 12 in my example, must be an integer value between 1 and I haven't tried this myself yet, but this should mean that in theory you could write a Power Shell script, or something, that runs every half hour and pushes the start time forward one hour.
This should force the report consolidation to run every hour instead of once each day. But to get up to one hour old statistics is usually not good enough, but it's the best you can do with the Web Analytics service.