BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_HOST_CLOUD_INSTANCE - Discovered Cloud Instance data

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
HOST_ID number 0  √  null Unique host ID
INSTANCE_TYPE nvarchar2 256  √  null Instance Type
ARN nvarchar2 256  √  null Amazon Resource Name (Instanceid + Ownerid + Region)
INSTANCE_OWNER_ID nvarchar2 256  √  null Instance Owner ID
AVAILABILITY_ZONE nvarchar2 256  √  null Instance Availability Zone
ARCHITECTURE nvarchar2 256  √  null Architecture of Image
LAUNCH_TIME date 7  √  null Instance Launch Time
STATE nvarchar2 255  √  null Current state of the instance (pending, running, shutting-down, terminated, stopping, stopped)
TENANCY nvarchar2 255  √  null Tenancy of an instance (dedicated | default | host )
HYPERVISOR nvarchar2 255  √  null Hypervisor Type of Instance
VIRTUALIZATION_TYPE nvarchar2 255  √  null Virtualization Type of Instance
REGION nvarchar2 255  √  null Region Information
RESERVATION_ID nvarchar2 255  √  null Instance Reservation ID
IMAGE_ID nvarchar2 256  √  null ID of the AMI used to launch the instance
IMAGE_NAME nvarchar2 256  √  null Name of the Image
IMAGE_DESC nvarchar2 1024  √  null Description of the Image
IMAGE_LOCATION nvarchar2 256  √  null Location of the Image
IMAGE_OWNER_ID nvarchar2 256  √  null Owner of the Image
IS_PUBLIC nvarchar2 256  √  null Is Image Public or not
PLATFORM nvarchar2 256  √  null Platform of the Image
ROOT_DEVICE_NAME nvarchar2 256  √  null The root device name (for example, /dev/sda1 or /dev/xvda ). / boot device
IMAGE_OWNER_ALIAS nvarchar2 256  √  null Name of creator/provider
ROOT_DEVICE_TYPE nvarchar2 256  √  null Storage Option
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
INVENTORY_ID number 18  √  null Inventory ID for this row
TASK_ID number 18  √  null Task ID for this row

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + HOST_ID Primary key Asc/Asc/Asc PK_DISC_HOST_CLOUD_INSTANCE These unique columns are also nullable
Confidential and Proprietary to BDNA