RPT_USAGE_LIC_EVENT_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
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	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.
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.
LINKED_EVENT_TIME_ OFFSET	Integer	2	The linked event time offset of the event. For more details, see the description for EVENT_TIME_OFFSET property. The time is given in seconds from Jan 1, 1970. See the note in the LINKED_EVENT_TIME description for information about how CHECK\_OUT and QUEUED events are treated.
LINKED_EVENT_SYNTHESIZED	Integer	1	An ID denoting whether the linked event was an actual event or if it was synthesized. For more details, see the description for SYNTHESIZED. See the note in the LINKED_EVENT_TIME description for information about how CHECK\_OUT and QUEUED events are treated.
SYNTHESIZED	Integer	1	An ID indicating whether this event was an actual event or if it was synthesized. Some events do not actually take place, but are synthesized by the vendor daemon. For example, when a section is ended by the vendor daemon, all features that are still in a checked-out state are forcibly checked in by the vendor daemon by synthesizing a check-in event for each outstanding check-out. In addition, when a section starts because of a report log rotation or a reread of the license files, all outstanding check-outs that were forcibly checked in at the end of the previous section are forcibly checked out again by the vendor daemon by synthesizing checkout events for each synthesized check-in at the previous section end. Thus, when a report log is rotated or a reread is performed, there may be several pairs of check-ins and check-outs that are synthesized at the section end and start, respectively. These events did not actually occur; however, by synthesizing them, the vendor daemon guarantees that every section contains a pair of check-out and check-in events that match.	Not nullable.
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.
HANDLE	Nullable Integer	4	An identifier assigned by a vendor daemon to a license check-out event.
SHARED_HANDLE	Nullable Integer	4	An identifier assigned by the vendor daemon for a previous license checkout with which this checkout was shared.
SHARED_GROUP	Nullable Integer	4	An identifier assigned by a vendor daemon, representing a group of one or more license checkouts which were satisfied with the same license.
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.
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.
BORROW_FLAGS	Nullable Integer	2	BORROW indicator from FlexNet Publisher.
BORROW_DURATION	Nullable Number	19	Time (in seconds) during which the license is being borrowed.