InstanceUser Table

FlexNet Manager Suite (Cloud)

InstanceUser links end-users in LicenseUser with a particular instance of a database for license counting purposes.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for InstanceUser table

Database Column

Details

InstanceID

Type: integer. Key

The instance used by the end-user. Foreign key to a database instance in the Instance table.

LicenseUserID

Type: integer. Key

The end-user using the instance. Foreign key to the account name in the LicenseUser table.

Quantity

Type: integer

The number of actual end-users of the database instance logging in to the Oracle database through this account. For example, if there is one “Shop Floor” account for all fork lift drivers, this field stores the number of individual drivers that must be accounted for.

AccountStatus

Type: text (max 256 characters). Nullable

The current status of the end-user account.

CreationDate

Type: datetime. Nullable

Date and time when the end-user was created.

LastLogonDate

Type: datetime. Nullable

Date and time when the end-user last logged on.

DefaultTablespace

Type: text (max 256 characters). Nullable

The default tablespace for an Oracle user.

TempTablespace

Type: text (max 256 characters). Nullable

The temporary tablespace for an Oracle user.

IsManualUser

Type: boolean

Whether or not the user was created manually (or through Oracle).

FlexNet Manager Suite (Cloud)

Current