Create Statistics Log Report

The Create Statistics Log (Createstatlogs) report consists of the Basic Tab: Reports.

This report is in the Housekeeping Group Reports.

This report creates statistical transaction logs with the suffix .stat from consolidated history logs with the suffix .statprep. Statistics logs contain dated entries for anonymous transactions. The Create Statistics Log report copies history transactions into a statistics file, removes specific patron and title information, and substitutes user and item demographics. Batch log files which may be loaded from standalone transactions are compiled automatically into the monthly statistics when the Create Statistics Log report runs.

Run this report daily.

Once the statistics logs have been created, they can be used to create a variety of analytical reports including the Activity Report, Transaction Statistics, and all of the My Statistics reports. After you have run the desired reports using the statistics logs, they should be deleted or copied to storage media at regular intervals to save disk space.

History and Statistics Data

A statistics log contains exactly the same transactions as the history log, except that each specific user and item transaction is replaced with general demographic information. For each suitable transaction in the history file, the system can take the user ID, if present, and the item ID and pull from the database all of the demographics associated with these two IDs. Commands like Charge Item and Create Hold contain both user and item IDs, so the Statistics Log process replaces them with the appropriate user and item demographics.

For example, this is a standard history log.

02/02/2005,13:51:43 Station: 029 Request: Sequence #: 13 Command: Bill User user access:ANNE-UACS station library:GREELEY user ID:ANN amount billed:1.75 bill reason:DAMAGED item ID:1114-1001 call number:PN6081 .R435 1987 copy:1 paid in full flag:N

This is the statistics log created from the above history log.

02/02/2005,13:51:43 Station: 029 Request: Sequence #: 13 Command: Bill User user access:ANNE-UACS user material type:GRADUATED user status:DELINQUENT department:LOST profile name:LOST user location:DRAFT user library:GREELEY call number:PN6081 .R435 1987 current status:CHECKEDOUT record format:MARC shelf location:ON-SHELF library:GREELEY type:BOOK permanent:Y year of publication:1989 station library:JSDL

The Create Statistics Log report should be run every day after you have performed your daily backup. If you do not use the Backup Daily Files Report, the Consolidate Daily Logs Report will create the files required to run the Create Statistics Log report. One of the consolidation options combined with the Create Statistics Log report allows you to create statistical reports for the previous day1s activity.

For more information, see Getting Information and Statistics from Your System’s Logs.