Instance Table

Instance stores information about database instances.

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 Instance table

Database Column

Details

InstanceID

Type: integer. Key. Generated ID

A unique identifier for an instance.

ParentInstanceID

Type: integer. Key. Nullable

The parent of the instance. Foreign key to another instance in the Instance table.

EnterpriseManager InstanceID

Type: integer. Key. Nullable

The Oracle Enterprise Manager database that manages this Oracle instance. Foreign key to the Instance table.

InstalledSoftwareID

Type: integer. Key. Nullable

The installation associated with the instance. Foreign key to the InstalledSoftware table.

InstanceTypeID

Type: integer

The type of this database instance. Foreign key to the InstanceType table

ComplianceComputerID

Type: integer. Key

The host server running this database instance. Foreign key to the ComplianceComputer table.

SoftwareTitleID

Type: integer. Key

The instance’s application. Foreign key to the SoftwareTitle table

InstanceName

Type: text (max 256 characters). Key. Nullable

The name of the database instance.

SerialNo

Type: text (max 256 characters). Nullable

The serial number of the database instance.

InstallationPath

Type: text (max 512 characters). Nullable

The installation path of the database instance.

BusinessApplicationName

Type: text (max 512 characters). Nullable

The business application that uses the database instance.

IsLicensable

Type: boolean

Set this to False if this instance does not require a license. The default is True, which means a license is required.

IsLicensableForLicenseRec

Type: boolean

Set this to True if this instance should be included in license reconciliation. False means that this instance will not be accounted for in license reconciliation.

NeverDelete

Type: boolean

When a computer does not return any inventory for a specified period of time, it may be deleted. Set this field to True to ensure that the instance record does not get deleted when there is no inventory.

SoftwareLicenseID

Type: integer. Key. Nullable

The software license covering this instance. Foreign key to the SoftwareLicense table.

UsedInInventory

Type: boolean

If the inventory importer detects that this database instance instance is used, it will set thie field to True.

UsedOverride

Type: boolean. Nullable

An operator may manually specify whether this database instance is to be considered used (set this field to True), or not (set this field to False). This overrides the importer result (UsedInInventory) described above.

InventorySourceTypeID

Type: integer

Whether this instance has ever been reported in inventory, or has been manually created and maintained. Foreign key to the ComplianceComputerInventorySourceType table.

AuditEvidence

Type: binary. Nullable

Oracle GLAS CSV files in zip archive.

AuditEvidenceDate

Type: datetime. Nullable

Date and time the Oracle GLAS audit evidence was collected by Flexera Inventory Manager

CreationUser

Type: text (max 256 characters)

The operator who created the database instance record.

CreationDate

Type: datetime

The date and time when this instance record was created.

UpdatedUser

Type: text (max 256 characters). Nullable

The operator who most recently updated the database instance record.

UpdatedDate

Type: datetime

The date and time when this instance record was last updated.