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). |
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) |