ConsolidatedOracleDatabaseUser Template

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

Table 1. Columns included with ConsolidatedOracleDatabaseUser templates

Column

Details

UserID

Type: big integer. Key

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

Destination:

ImportedInstanceUser.ExternalID

ImportedLicenseUser.ExternalID

ComputerID

Type: big integer. 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.

Destination:

ImportedInstanceUser.ExternalID

ImportedInstanceUser.ComputerID

ImportedLicenseUser.ExternalID

InstanceName

Type: big integer. 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 or this row will be skipped.

Destination:

ImportedInstanceUser.ExternalID

ImportedInstanceUser.InstanceID

ImportedLicenseUser.ExternalID

Name

Type: text (max 256 characters)

The name of the user.

Destination:

ImportedLicenseUser.UserName

AccountStatus

Type: text (max 256 characters). Nullable

The current status of the end-user account.

Destination:

ImportedInstanceUser.AccountStatus

CreationDate

Type: datetime. Nullable

The date and time when the end-user was created. The date must be entered in one of the supported formats.

Possible values:

  • yyyy/MM/dd
  • yyyy/MM/dd HH:mm:Ss
  • yyyy/MM/dd HH:mm
  • yyyy-MM-dd
  • yyyy-MM-dd HH:mm:Ss
  • yyyy-MM-dd HH:mm
  • yyyyMMdd
  • yyyyMMdd HH:mm:Ss
  • yyyyMMdd HH:mm

Destination:

ImportedInstanceUser.CreationDate

LastLogonDate

Type: datetime. Nullable

The date and time when the end-user last logged on to the computer. The date must be entered in one of the supported formats.

Possible values:

  • yyyy/MM/dd
  • yyyy/MM/dd HH:mm:Ss
  • yyyy/MM/dd HH:mm
  • yyyy-MM-dd
  • yyyy-MM-dd HH:mm:Ss
  • yyyy-MM-dd HH:mm
  • yyyyMMdd
  • yyyyMMdd HH:mm:Ss
  • yyyyMMdd HH:mm

Destination:

ImportedInstanceUser.LastLogonDate

DefaultTablespace

Type: text (max 256 characters). Nullable

The default tablespace for an Oracle end-user.

Destination:

ImportedInstanceUser.DefaultTablespace

TempTablespace

Type: text (max 256 characters). Nullable

The temporary tablespace for an Oracle end-user.

Destination:

ImportedInstanceUser.TempTablespace

DisplayName

Type: text (max 256 characters). 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 and InstanceName or this row will be skipped.

Destination:

ImportedInstanceUser.ApplicationID

Version

Type: text (max 72 characters). 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 and InstanceName or this row will be skipped.

Destination:

ImportedInstanceUser.ApplicationID

Publisher

Type: text (max 200 characters). 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 and InstanceName or this row will be skipped.

Destination:

ImportedInstanceUser.ApplicationID

Evidence

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

Identifier for the type of installer evidence.

Destination:

ImportedInstanceUser.ApplicationID

AccessMode

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

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.

Possible values:

  • Local
  • App-V
  • Citrix Virtual Apps
  • Citrix Virtual Desktops
  • VMware View
  • Office 365
  • Horizon VDI

Destination:

ImportedInstanceUser.ApplicationID