RPT_USAGE_LIC_DEVENT_153 Table

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

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_VERSION	String	100	The version of the FEATURE or INCREMENT line in the license files of the vendor daemon.	Not nullable.
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	8	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.
FEATURE_ID	Integer	4	An ID assigned to the feature record in the table. It is unique across all the feature records in a section of a report log; hence the two IDs, CATALOG_SECTION_ID and FEATURE_ID form the unique key for RPT_FEATURE Table.	Not nullable. Part of the primary key of the table.