How to recalculate statistics using old IIS log files starting from a particular date?
utility is run, either manually or during daily maintenance, it performs the following actions to calculate statistics for each domain:
Parse IIS log files for the domain and only select non-processed records.
Merge the selected records with the records from the default website log file.
Process the resulting log file with the native statistics backend (AWStats or Webalizer).
The recalculation can be performed using PowerShell scripts for Plesk 17. Download the script to the server, unzip it and right-click the script file, select “Run with PowerShell”.
Alternatively, follow the steps below to recalculate statistics from a given date to the current date:
- Ensure Log Rotation is enabled and configured
- Go to IIS > Sites > example.com > Logging and enable all fields for W3C logging:
Verify that domain log files are not compressed and contain data:
Use this command to find the log’s location:
C:> “%plesk_dir%”adminbin64websrvmng.exe –get-vhost-log-dir –vhost-name=example.com
Unzip and place all the log files that should be processed by statistics into the folder above. Make sure they have the
extension. It also may be a good idea to merge them all into a single
Change the value of
for the domain in the registry:
Retrieve the domain ID from Plesk database:
C:> “%plesk_bin%”dbclient.exe –direct-sql –sql=”SELECT id, name FROM domains WHERE name=’example.com'”
Change the value of this registry key to the date from which statistics will be recalculated:
(where “40” is the domain ID obtained above from the
If there is no
in the registry, all available log files will be recalculated.
If it is needed to recalculate statistics for a part of the current month, edit this file (in this example, the current month is November 2019):
Remove the lines starting with the following keywords from the file above:
If it is needed to recalculate statistics for one or more months, delete the AWStats databases from the very first month for which the statistics need to be recalculated. For example, to recalculate statistics for September 2019 (and it is now November 2019), delete the following files:
If this step is forgotten, AWStats will ignore all log files as if they only contained old records.
Remove the DNS cache file: