The usage database contains several tables; however, the only table that may be accessed is named usage. The other tables are for authentication purposes only.

The contents of the usage table are described below.

Table name

Columns

Description

usage

(id integer primary key, time integer, action text, comment text, auth text)

This table contains usage information. Each row in the table contains a timestamp, an action that occurred, comments on additional information if applicable, and authentication information.

The time format used in the time integer column is "time_t," which you can find out more about by going to: http://en.wikipedia.org/wiki/Time_t.

The action text column will contain one of the following:

Action

Description

STARTUP

Indicates the license server started up. The comment text column is empty.

SHUTDOWN

Indicates the license server was shut down. The comment text column is empty.

CHECKOUT

Indicates a checkout was performed. The comment text column contains additional information related to the checkout, including the feature name, a unique id of the specific feature (in case there are multiple licenses on the server of the same feature name), and a count. For example, (FEATURE: UNLIMITED UNIQUEID: 5E7100EE3F98F68F559AB09D57AA8BA154F77907A48D2487 COUNT: 1 SOFTLIMIT_EXCEEDED: FALSE).

SOFTLIMIT_EXCEEDED indicates whether the number of licenses specified for softlimit licensing has been exceeded.

CHECKIN

Indicates a checkin was performed. The comment text column contains additional information related to the checkin, in the same manner as for CHECKOUT.

USAGE

Specifies the current usage of a particular feature. This is the sum of all checkouts, checkins, and borrows that have occurred. The comment text column contains additional information related to the usage, in the same manner as for CHECKOUT. For example, (FEATURE: UNLIMITED UNIQUEID: 1ECA6DB5DDEAA15E565AE7C78AFBB6F67DC9F35593CCBFB0 COUNT: 2 SOFTLIMIT_EXCEEDED: FALSE USERNAME: Administrator HOSTNAME: amilo IPADDRESS: ::1)

The above example shows the syntax for USAGE_LEVEL set to EXTENDED, which includes USERNAME, HOSTNAME, and IPADDRESS (see Enabling and using usage databases).