RPT_USAGE_NOLIC_EVENT_153 Table

This table holds information about the client processes that executed events found in the report logs that were imported.

RPT_USAGE_NOLIC_EVENT_153 Table

Column Name

Data Type

Data Length

Description

Constraints

EVENT_ID

Integer

1

An ID denoting the event type. The values are:

4 for a CHECK-IN event
5 for an ordinary DENIAL event
10 for a UNSUPPORTED event
12 for a ULTIMATE DENIAL event
14 for a DEQUEUED event

Not nullable. Part of the primary key of the table.

EVENT_TIME

Integer

4

The start time of the event. The time is given in seconds from Jan 1, 1970.

Not nullable. Part of the primary key of the table.

CLIENT_DISPLAY

Nullable String

255

The user’s display name (UNIX only).

 

CLIENT_FLEX_VERSION

Nullable String

255

The product’s FlexNet Licensing version.

 

CLIENT_PLATFORM

Nullable String

255

The name of the platform on which the user’s application was compiled to run.

 

CLIENT_PROJECT

Nullable String

255

The user’s LM_PROJECT environment variable (or the related value in the Windows registry).

 

FEATURE_NAME

String

255

The name of the FEATURE.

Not nullable.

FEATURE_POOLKEY

Nullable String

255

The poolkey of the feature (if one is associated with this event). The poolkey of the license feature is normally taken from the RPT_FEATURE Table using the feature referenced by the FEATURE_ID column. In the case of UNSUPPORTED events, however, the feature is not available in the RPT_FEATURE Table, so this column in the RPT_EVENT table is used as an alternate source for the feature poolkey.

 

USER_NAME

Nullable String

255

The user’s user name (from report log files), in uppercase.

If the user name is in mixed case or lowercase, FlexNet Manager for Engineering Applications converts the string to uppercase before storing it in the reporting database.

 

USER_HOSTNAME

Nullable String

255

The user’s host name.

 

USER_IPADDR

Nullable String

255

The user’s IP address in string form.

 

USER_GROUPS

Nullable String

1024

A string that is the concatenation of the names of all the user groups to which the user belongs. The user's group membership is defined in the options file.

The user group names are surrounded by double quotes and separated by commas.

 

HOST_GROUPS

Nullable String

1024

A string that is the concatenation of the names of all the host groups to which the user's host belongs. The user's host's group membership is defined in the options file.

The host group names are surrounded by double quotes and separated by commas.

 

CATALOG_SECTION_ID

Integer

4

The ID of the section in the imported report log from where this feature was extracted.

Not nullable. Part of the primary key of the table.

EVENT_TIME_OFFSET

Integer

2

A running count of the number of events in a section of a report log registered for the same second.

This provides a means to sequence the events as they were found in the report log. If multiple events occurred at the same point in time, they are assigned unique offset numbers depending on their order in the report log.

By sorting on this column, you can see events coming from the same report log section, in the order they were logged by the vendor daemon.

Not nullable. Part of the primary key of the table.

PROCESS_ID

Integer

8

The ID of the user's process that initiated the event.

 

LIC_COUNT

Nullable Integer

2

The number of licenses in request.

This column is NULL for START and END events.

 

REASON_ID

Nullable Integer

1

An identifier referencing the reason a license was denied or checked in.

 

PRODUCT_VERSION

Nullable String

255

The version of the product used by the user.

 

VENDOR_DEF

Nullable String

255

The value of the CHECKOUT_DATA passed by the user's application to the license server when the license was checked out.