ImportedCloudServiceInstance Table

The ImportedCloudServiceInstance table holds all of the data which have been retrieved from the cloud instance.

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 `ImportedCloudServiceInstance` table
Database Column	Details
`ComplianceConnectionID`	Type: integer. Key. Nullable The identifier for a data source connection in the `ComplianceConnection` table.
`ExternalComputerID`	Type: big integer. Key. Nullable The identifier used in the source connection for the computer.
`HostID`	Type: text (max 256 characters). Nullable The ID of the dedicated host instance.
`HostComputerID`	Type: big integer. Key. Nullable The identifier used in the source connection for the CloudServiceInstance’s host computer.
`CloudServiceProvider`	Type: text (max 256 characters). Key. Nullable The cloud service provider for this instance. Foreign key to the `CloudServiceProvider` table.
`InstanceCloudID`	Type: text (max 256 characters). Key The ID of the cloud instance.
`InstanceAffinity`	Type: text (max 256 characters). Nullable The affinity setting for the instance on the Dedicated Host.
`ImageID`	Type: text (max 256 characters). Nullable The ID of the image used to launch the instance.
`LaunchTime`	Type: datetime. Nullable The time the cloud instance was launched or the Reserved Instance started.
`NetworkID`	Type: text (max 256 characters). Nullable The ID of the Virtual Private Cloud.
`ServiceName`	Type: text (max 256 characters). Nullable The name of this service. For AWS RDS instances, the database name.
`ServiceEndpoint`	Type: text (max 256 characters). Nullable The endpoint uri of this service.
`ServiceEndpointPort`	Type: integer. Nullable The endpoint port of this service.
`MACAddress`	Type: text (max 256 characters). Key. Nullable The MAC address of the computer. This may be a comma-separated list if there is more than one active network adapter in the system. Do not include inactive network adapters and network adapters with invalid MAC addresses.
`LifecycleMode`	Type: text (max 256 characters). Nullable The time the instance was launched.
`ExpiryTime`	Type: datetime. Nullable The time when the Reserved Instance expires.
`InstanceCount`	Type: integer. Nullable The number of reservations purchased.
`OfferingClass`	Type: text (max 256 characters). Nullable The offering class of the Reserved Instance.
`OfferingType`	Type: text (max 256 characters). Nullable The Reserved Instance offering type.
`Scope`	Type: text (max 256 characters). Nullable The scope of the Reserved Instance.
`Account`	Type: text (max 256 characters). Nullable The Account that is used to create the instance.
`CoreCount`	Type: integer. Nullable The number of core of the instance.
`ThreadsPerCore`	Type: integer. Nullable The number of thread per core of the instance.
`InstanceType`	Type: text (max 256 characters). Nullable Cloud provider instance type.
`Region`	Type: text (max 256 characters). Nullable Region of the instance.
`AvailabilityZone`	Type: text (max 256 characters). Nullable Location of the instance.
`InstanceTenancy`	Type: text (max 256 characters). Nullable Instance tenancy of the instance
`VMEnabledStateID`	Type: integer. Key. Nullable The state of the machine (powered on, off, etc).
`InventoryDate`	Type: datetime. Nullable The time of inventory date.
`CloudTenantID`	Type: text (max 256 characters). Nullable The cloud Tenant ID.
`CloudSubscriptionID`	Type: text (max 36 characters). Nullable The cloud Subscription ID.
`ServiceType`	Type: text (max 36 characters). Nullable The cloud service type.
`LicenseType`	Type: text (max 36 characters). Nullable The license model information.
`ResourceID`	Type: text (max 256 characters). Nullable The Resource ID of the cloud instance.
`VMScaleSetName`	Type: text (max 256 characters). Nullable The Virtual machine scaleset name of the cloud instance.