Differences

This shows you the differences between two versions of the page.

--- sfx_statistics_archives_files [2017/12/04 16:41]
cknapp
+++ sfx_statistics_archives_files [2019/01/07 17:20]
127.0.0.1 external edit
@@ Line 1: / Line 1: @@
 ====== SFX Statistics and Archives Files ======
-**As of 12/2017**, SFX statistics will be automatically archived 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.
-**As of 3/2016**, SFX statistics will be automatically archived from the offline file by ExLibris. ExLibris will leave the previous year, meaning that by Dec31 there can be up to 18 months of statistics remaining. We should be able to upload archived statistics via ./server.admin.util but may need to request file name from EL support. (7/1/2015-6/30/16 was archived 10/22/17)
+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.
-**As of 2016** we are running SFX Queries 2,3,4,5,6,8,10,11,12 by cron monthly, adding 14 and 19 for calendar and fiscal year stats.
+**MONTHLY AND YEARLY:** SFX Queries 2,3,4,5,6,8,10,11,12 are run by cron monthly, adding 14 and 19 for calendar and fiscal year stats. Calendar and fiscal year stats are done manually.  **RUN TOP 100 ONLY** for queries 2,10,11,12,14,19. Stat reports are manually opened from email file, checked, and stored at Q:/DRMS/SFX/SFX_statistics.
-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, sending files to Catherine's email. Statistics reports can be rescheduled through SFX Admin>Statistics>Queries>(Query#)>Schedule. Previously scheduled reports need to be removed UNIX side (da>"crontab -l" to list jobs, -e to edit). Stat reports are manually opened from email, checked, and stored at W:\DEPARTMENTAL_FOLDERS\Acquisitions\SFX_Project\2013 Statistics.
+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