Except for fiscal and calendar year reports, SFX statistic queries are set up as cron jobs, running on the 14th of the following month, 6:00-7:15 a.m. Central/Chicago time. Crons send files to DRMS email or files can be found in SFX Admin>UNIX File Manager>dbs/scratch. Statistics reports crons can be rescheduled through SFX Admin>Statistics>Queries>(Query#)>Schedule. Crons can be removed UNIX side (da>“crontab -l” to list jobs, “crontab -e” to edit). SFX statistics are automatically archived by ExLibris each month, leaving 12 months in the file for running year and FY stats. Archived files may be retrieved through server_admin_util → 5 → 3. To avoid re-instating archived files, do fiscal and calendar stats soon after January and July 1.
Here is a historical list of statistics files when we archived manually.
Aug 2005 archive is stats.20051109-161917.saf
Sept-Nov 2005 archive file is called stats.20060105-173540.saf
December 2005 stats archive file is called stats.20060202-12:56:28.saf
Jan-April 2006 file is called stats.20060601-12:06:44.saf
May 2006 file is called stats.20060601-14:08:46.saf
Summer (June-Aug) 2006 file is called stats.20060901-14:23:18.saf
Fall 2006 (Sept – Dec) is called stats.20070104-10:43:08.saf
Spring 2007 (Jan – May 07) is called stats.20070620-10:52:51.saf
Summer 2007 (June – Aug 07) is called stats.20070904-13:16:18.saf Note that due to two table crashes, clickthrough data is missing.
Sept – Nov 07 is called stats.20080110-15:06:42.saf
December 07 is called stats.20080102-15:50:34.saf
Jan – Feb 08 is called stats.20080523-10:51:04.saf
March – April 08 is called stats.20080522-13:49:49.saf
May – July 08 is called stats.20080902-09:52:58.saf
Aug – Sept 08 is called stats.20081104-14:20:55.saf
Oct – Nov 08 is called stats.20090901-12:49:37.saf
December 08 - February 09 is stats.20090402-12:33:28.saf
March - April 2009 is stats.20090601-11:21:42.saf
May - July 2009 is stats.20090820-09:59:38.saf
August 2009 is stats.20091001-12:46:16.saf
Sept - Oct 2009 = stats.20091201-08:57:45.saf
November - December 2009 = stats.20100201-08:43:50.saf
Jan - Feb 2010 = stats.20100407-11:57:53.saf
March 2010 = stats.20100504-15:35:33.saf
April - May 2010 = stats.20100701-08:30:50.saf
June - August 2010 = stats.20101004-11:00:15.saf
August 2010 = stats.20110425-12:42:01.saf
September 2010 = stats.20101101-11:15:45.saf
October 2010 = stats.20101201-07:07:07.saf
November 2010 = stats.20110105-09:48:18.saf
December 2010 = stats.20110207-09:13:37.saf
January 2011 = stats.20110308-07:27:35.saf
February 2011 = stats.20110404-06:46:18.saf
March 2011 = stats.20110425-09:05:15.saf
April 2011 = stats.20110912-07:07:07.saf
May-July 2011 = stats.20110801-12:56:55.saf
Aug-Oct 2011 = stats.20111205-07:19:43.saf
Nov-Dec 2011 = stats.20120206-06:55:22.saf
Jan-Jun 2012 = stats.20130123-07:16:13.saf
July-Dec 2012 = stats.20130715-06:51:32.saf
Jan-Jun 2013 = stats.20140128-06:58:22.saf
July-Dec 2013 = stats.20140728-07:05:48.saf
Jan-Jun 2014 = stats.20150204-06:58:43_from_2014-06-02_06:42:53_to_2014-01-27_07:52:53.saf
Jun-Dec 2014 = (Archived by EL)
Jan-Jun 2015 = (Archived by EL)
July-Dec 2015 (see wiki edit screen for actual text) = stats.20170620-07:15:20_from2015-07-01_00:04:53_to2015-12-31_23:51:34.saf
Archived by ExLibris support….
To restore an archived file to the offline table for analysis, remember to empty the offline table first.
Archived files are located in “/exlibris/sfx_ver/sfx4_1/umass3/archive/” subdirectory.