Inventory Object: ConsolidatedOracleDatabaseUser

FlexNet Manager Suite 2020 R1 (On-Premises)

ConsolidatedOracleDatabaseUser objects are uploaded to the ConsolidatedOracleDatabaseUser table in the operations (inventory) database. Multiple imports will merge updated data with existing records, and add new records as applicable.

ConsolidatedOracleDatabaseUser provides a list of the users for each Oracle database instance.

Attributes are listed here in alphabetical order.

Property Attributes Notes
AccessMode Alpha-numeric text (maximum 128 characters). Default: 1. Mandatory. Database key.

The access mode of the installer evidence. Leave this blank unless this row is a virtualized application. In that case choose one of the values below that matches your application or desktop virtualization infrastructure.

Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.
AccountStatus Alpha-numeric text (maximum 256 characters). May be null.

The current status of the end-user account.

ComputerID Unsigned integer (bigint). Mandatory. Database key.

The identifier used in the source connection for the computer. It must match the ComputerID from the Computer spreadsheet or the row will be ignored.

CreationDate Date/time field. May be null.

The date and time when the end-user was created.

DatabaseName Unsigned integer (bigint). Mandatory. Database key.

This field specifies the name of the database. It must match a row in the InstallerEvidence spreadsheet for the same ComputerID or this row will be skipped.

DefaultTablespace Alpha-numeric text (maximum 256 characters). May be null.

The default tablespace for an Oracle end-user.

DisplayName Alpha-numeric text (maximum 256 characters). Mandatory. Database key.

The display name of the software as reported by the installer evidence. It must match a row in the InstallerEvidence spreadsheet for the same ComputerID, Version, Publisher, DatabaseName and InstanceName or this row will be skipped.

Evidence Alpha-numeric text (maximum 32 characters). Default: . Mandatory. Database key.

Identifier for the type of installer evidence.

Note: Strictly, this attribute may be null, because it forms part of a compound database key. However, null values may cause import errors (where this object does not get imported), and multiple records from the same connection having nulls may cause data loss through over-writing. It is therefore best practice to treat this field as mandatory.
InstanceName Unsigned integer (bigint). Mandatory. Database key.

This field specifies the name of the database instance. If there are multiple instances, create a row for each instance in this spreadsheet. It must match a row in the InstallerEvidence spreadsheet for the same ComputerID and DatabaseName or this row will be skipped.

LastLogonDate Date/time field. May be null.

The date and time when the end-user last logged on to the computer.

Name Alpha-numeric text (maximum 256 characters).

The name of the user.

Publisher Alpha-numeric text (maximum 200 characters). Default: . Mandatory. Database key.

The publisher of the software as reported by the installer evidence. It must match a row in the InstallerEvidence spreadsheet for the same ComputerID, DisplayName, Version, DatabaseName and InstanceName or this row will be skipped.

TempTablespace Alpha-numeric text (maximum 256 characters). May be null.

The temporary tablespace for an Oracle end-user.

UserID Unsigned integer (bigint). Mandatory. Database key.

The identifier used in the source connection for the instance end-user. This may be an integer or a string.

Version Alpha-numeric text (maximum 72 characters). Default: . Mandatory. Database key.

The version of the software as reported by the installer evidence. It must match a row in the InstallerEvidence spreadsheet for the same ComputerID, DisplayName, Publisher, DatabaseName and InstanceName or this row will be skipped.

FlexNet Manager Suite (On-Premises)

2020 R1