Ovid Logo

Ovid Technologies, Inc.

 

Ovidstat Report Program

 

 

 

 

Overview

Ovidstat is designed to produce statistical reports on many aspects of Ovid usage. The program takes raw statistics files and makes reports, using attributes like: types of full-text publications viewed; general database usage; and peak system and data base usage. Ovidstat can also create tab-delimited output that can be imported into spreadsheets and limit output by user, group, database, client types, and IP address. In addition, the Ovidstat program can create and save customized report definitions t hat can be reused.

As it is used, Ovid creates an ASCII file containing raw statistics about program and database usage. Those statistics can include: the user ID, date, time, and length of each search session; the databases searched; the number of search sets made; and other data.


Ovidstat makes user-friendly reports from the statistics. From raw data similar to:

USER jhc TIME 31-dec-96 0:19 LEN 0:24 SESSIONTYPE WEB
DB hstr SETCOUNT 10 VIEW 16 PRINT 0 SAVE 0 LEN 0:22
USER dewalddd TIME 31-dec-96 1:28 LEN 0:31 SESSIONTYPE -
DB mesz SETCOUNT 27 VIEW 78 PRINT 0 SAVE 5 LEN 0:30
USER griffikm TIME 31-dec-96 4:04 LEN 0:10 SESSIONTYPE -

Ovidstat produces a report similar to the following:

Statistics for all databases

Total

Average

Search Sessions

19501

-

Session Length in Minutes

196144

10.058

Search Statements

140924

7.227

Records Viewed

711152

36.467

Records Printed

112046

5.746

Records Saved

164448

8.433

 

Getting Started

To log in, go to http://stats.ovid.com and enter your user ID and password. If you have more then one statistics file you will be taken to a page titled Ovid Online Statistics and prompted to select the group for which you want to generate statistics reports for.

Creating Reports

Custom Reports - Using the Report Generator

On the Report Generator screen, select and set the parameters you wish to use. (Parameters and their functions are listed below.)

The following parameters must be used in order to successfully generate a report in Ovidstat: Type of Report and Report Format. In addition, you will probably want to enter a Report Title for your report so that you can identify it in the future.

To set parameters for a report, enter text in the appropriate boxes as explained below.

Ovidstat Parameters

Report Title

Use this parameter to name the report. Enter a name in the Report Title: text box. Any characters may be used. The name will appear in the upper left hand corner of the report that is generated. For example: Ovid_Usage_Stats

Type of Report

Ovidstat can make several kinds of reports. Click on the drop-down window next to Type of Report: to choose a type of report. Report types are as follows: Fulltext: A list of types of full-text publications viewed, (su ch as article, book, report, etc.), sorted by journal name. Dbsession: Ovidstat's default output, tab-delimited for use in spreadsheets. A wide variety of usage information is presented, sorted by user and session. Dbusage: A list of cumulative average usage statistics, sorted by database. License: Counts the number of "license exceeded" messages, for both Ovid and database licenses. Peak: Displays peaks – that is, times at which the largest number of users were searchi ng – for system and database usage by month, day, and hour.

To the right of this is a second window where you choose among the options by database, by group, and by user, which allow you to create reports that are sorted by one of these criteria. The default option is < B>by database. Regardless of which is selected, however, the resulting report will contain statistics on session length, items viewed, search statements, bibliographic records used, etc.

Report Format

Tab-delimited format should be selected if you wish to save report data for use in a spread sheet. Although the default format dbsession report is tabbed, the default format for other reports is ASCII. To change other report types to tab-delimited format, click the drop-down window and select tabbed.

Limiting the Report

If you are only interested in certain aspects of the statistics available, you can limit report output by one or more raw statistics fields. You can select single limits or multiple limits for each field. Multiple limits mus t be in a comma-delimited list (do not use any spaces) in the appropriate text box for each parameter. The following limits are available:

Time/Date Range

Use the drop down boxes to enter a time range to limit a report to.

Limit to User

Enter a user ID or IDs in the User text box.

Limit to Group

Enter a group name or names in the Group text box.

Limit to Database

Select one or more databases from the drop down box. By default all databases are selected

Limit to Session Type

You can also limit the report output by type of interface used when searching. Click the drop-down window next to Session Type to choose an interface type. The default is all interfaces.

Limit to Address

Enter a portion of or a full IP address, or a range of addresses in the Address text box. The range of IP addresses should specify the complete first and last IP address, separated by a comma with no space. (Entering a portion of an IP address limits output to sessions with IP addresses beginning with the numbers you specify.)

Generating, Saving, and Printing Reports

Custom Reports

Once you have specified and set parameters, you may generate your report by using either the Generate Report or Save Report buttons. The difference is that the Save Report button will both generate the report and automatically save it (under the name you choose) for future use. When generated, the report will appear on a new page.

At this point, you may also save a report to your own hard or floppy disk by using your browser’s "save" function or print it using the "print" function. When saving, PC users should add a .txt extension to the file name so that it will be saved as a text file that can be opened in database programs. Macintosh users should just check to make sure that it is saved as a text file. (This should be the default setting.) Users of both platforms should also be sure that you ar e saving in tabbed format – see explanation of "Format" parameter above.

Accessing Existing Reports

You can retrieve reports at any future time by pressing the Saved Reports link that appears beneath the input form. When you have done this, you will see a list of all the names of the reports that you have saved. You can display the report or delete it by clicking on the appropriate link.

Saving and Reusing Report Definitions

If you want to save the parameters that you have specified in order to run an identical report without entering the parameters again, enter a name for the report definition in the text box next to the Save Report Definition button reading and then press the button.

Note: Saving report definitions allows you to run cumulative reports. These may include either the entire set of data, or data from a particular date forward. If you specify a start and end date that hav e already passed, your saved report will only generate the same information over and over again. If you save a report definition, therefore, you should either leave the date fields blank, or you should specify a starting date from which you wish to begin, and an end date which is very far in the future. (e.g. "200512312300", or 11:00 p.m. on December 31, 2005).

To access a saved report definition or execute the corresponding report, click on the Report Definitions link at the bottom of the screen. You will be presented with a list of the reports for which you have saved definitions. You can display de finitions, execute reports, or delete listings by pressing on the appropriate link.

Viewing Statistics Files

There are two types of statistics files available. The raw statistics are "master.log" (the current week only) and "master.log.archive" (a archive of all previous master.log files). There are also summary files that have the f ile the extension ".f".

You can see which statistics files are available to you by clicking on the Statistics Files link. You will see a list of files that may be displayed by clicking on the appropriate link. Viewing raw statistics files is u seful for confirming any format names you choose to enter in the database field when creating your report. The format name for the database immediately follows the designation DB in the raw data record.