• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
Has anyone come up with a report to pull “OPAC” statistics monthly or annually?

We would want ADM specific results within a multi-ADM consortium.

Resolution:
Generally, z69 is the table you want to use for this. (Knowledge Base record 8192-2055 describes the advantages of z69 vs. z35.)

One question is whether you want statistics for the searches by "target library" or by the home library of the person doing the search.

If the former, the Search Base is the first 20 bytes of the z69_search_info and the Scan Base is the first 20 bytes of the z69_scan_info. Note: when the user is searching the Union catalog, the base will be "U-ODN01", so there is no differentiation.

If the latter, you can use the z69_client_address (the ip address) to determine location -- at least for PC's which are in a library.

Note: the z69 does have a "z69_bor_id" but that is written to only for z69_event_type 35 ("save on local drive") and, thus, is of limited use.

• Article last edited: 10/8/2013