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 LMS CVS files in zip archive.
`AuditEvidenceDate`	Type: datetime. Nullable Date and time the Oracle LMS 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.