STATISTICS

Chapter 4. VIEWING DATABASE STATISTICS

   

 

< PREVIOUS Chapter 3 Downloading Statistics Reports

CONTENTS INDEX

NEXT > Chapter 3 Graphical Statistics Report

---

Viewing the Daily Transaction Log

The daily transaction log provides detailed information related to login, search, cataloging and interlibrary loan transactions for all libraries defined in your system for a selected one-month period. The report is saved as a text (.TXT) file, in tab-delimited format, for import into a spreadsheet application such as Microsoft Excel.

NOTE: The Daily Transaction Log feature is available with Advanced Statistics only.

To view the Daily Transaction Log:

The Daily Transaction Log is organized in chronological order, from oldest to most recent transaction, for the selected report period, with each transaction listed on a separate line. Each line in the Daily Transaction Log provides the following information:

• tid (transaction identifier) – the system-assigned transaction identifier number.
• TranLogged – the date and time at which the associated transaction took place.
• Type – numeric code identifying the specific type of transaction. Type identifiers for each transaction category (login, search, cataloging and interlibrary loan) are described below:

NOTE: For login transactions by users who are granted access to multiple staff modules, the transaction is recorded for the user's default staff mode.

• LibraryProfileKey – license key assigned by Auto-Graphics for the library at which the associated transaction occurred.
• AGLibID – library code for the library at which the associated transaction occurred.
• LibraryName – name of the library at which the associated transaction occurred.
• RecCount – Not implemented.
• DatabaseName – the name of the database to which the associated search request transaction was submitted (this field is blank for login transactions).

  NOTE: For search request transactions submitted simultaneously to multiple databases, a separate transaction is listed for each database.

• DatabaseType - two-character code indicating the database type, as described below:

AG - Union Catalog (Auto-Graphics' Impact database)
AV - AGent VERSO
HP – Hoopla
OD – OverDrive
VS - Library OPAC
WB - Web Database
WL - Web Link
WM – OCLC WorldCat Database
WS - Web Service
XL - Reference Site
ZN – Zinio
ZZ - Virtual Library (Z39.50 Site)

• SearchTerm1 – search string entered in the Search For text box for Simple Search and Alpha Browse; search string entered in the first Search For text box for Advanced Search.

  NOTE: Alpha Browse functionality is not currently supported by the system.

• Index1 – numeric code indicating the search index selected for SearchTerm1. Index codes for each database and search type available through the system are described below:

NOTE: For Web Databases (WB) and Web Links (WL), this column always contains "0" (not applicable).

• SearchTerm2 – search string entered in the second Search For text box for Advanced Search. If no search term was entered, this field is blank.
• Index2 – numeric code indicating the search index selected for SearchTerm2 (see Index1, above, for an explanation of index codes).
• SearchTerm3 – search string entered in the third Search For text box for Advanced Search. If no search term was entered, this field is blank.
• Index3 – numeric code indicating the search index selected for SearchTerm3 (see Index1, above, for an explanation of index codes).
• QScoping – indicates whether or not a scoping qualifier was applied against the search. This field contains either "TRUE" (scoping qualifier was applied against the search) or "FALSE" (scoping qualifier was not applied against the search). Qualifiers are not valid with all databases.
• QDate – indicates whether or not a date qualifier was applied against the search. This field contains either "TRUE" (date qualifier was applied against the search) or "FALSE" (date qualifier was not applied against the search). Qualifiers are not valid with all databases.
• QLanguage – indicates whether or not a language qualifier was applied against the search. This field contains either "TRUE" (language qualifier was applied against the search) or "FALSE" (language qualifier was not applied against the search). Qualifiers are not valid with all databases.
• QMedia – indicates whether or not a media qualifier was applied against the search. This field contains either "TRUE" (media qualifier was applied against the search) or "FALSE" (media qualifier was not applied against the search). Qualifiers are not valid with all databases.
• QForm – indicates whether or not a form qualifier was applied against the search. This field contains either "TRUE" (form qualifier was applied against the search) or "FALSE" (form qualifier was not applied against the search). Qualifiers are not valid with all databases.
• QMisc – indicates whether or not a miscellaneous qualifier was applied against the search. This field contains either "TRUE" (miscellaneous qualifier was applied against the search) or "FALSE" (miscellaneous qualifier was not applied against the search). Qualifiers are not valid with all databases.
• SearchID – the system-generated search identification number.

  NOTE: For search request transactions submitted simultaneously to multiple databases, the same SearchID is listed for each database.

• UserName – the name of the user that performed the associated transaction.
• InLib – indicates whether the associated transaction was initiated “in library” or from a remote location. This field contains either "TRUE" (the associated transaction was initiated from within the library) or "FALSE" (the associated transaction was initiated from a remote location).

  NOTE: Only those workstations with registered “valid IP addresses” are logged as “in library” transactions. Valid IP ranges are managed from within the User Administration module (see the User Administration User Guide for more information).

• DataID – the database identification number for the associated database. All reference databases and web services are assigned a unique DataID. A "0" is shown for all other resources.

 

 

---

< PREVIOUS Chapter 3 Downloading Statistics Reports

CONTENTS INDEX

NEXT > Chapter 3 Graphical Statistics Report