CloudServiceInstance Table

CloudServiceInstance stores information for cloud service 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 CloudServiceInstance table

Database Column

Details

CloudServiceInstanceID

Type: big integer. Key. Generated ID

A unique identifier for cloud service instance on a computer.

ComplianceComputerID

Type: integer. Key. Nullable

The computer where this cloud service instance is linked to. Foreign key to the ComplianceComputer table.

HostComplianceComputerID

Type: integer. Key. Nullable

The instance’s host computer. Foreign key to the ComplianceComputer table.

HostID

Type: text (max 256 characters). Nullable

The ID of the dedicated host instance.

CloudServiceProviderID

Type: integer. Key

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.

CloudServiceInstance TypeID

Type: integer. Nullable

Cloud instance type defined by provider. Foreign key to the CloudServiceInstanceType table

CloudServiceRegionID

Type: integer. Nullable

Region of the instance. Foreign key to the CloudServiceRegion table.

AvailabilityZoneID

Type: integer. Nullable

Location of the instance. Foreign key to the AvailabilityZone table

InstanceTenancyID

Type: integer. Nullable

Instance tenancy of the instance. Foreign key to the InstanceTenancy table

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.

LifecycleMode

Type: text (max 256 characters). Nullable

The lifecycle state of the instance.

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.

VMEnabledStateID

Type: integer. Nullable

The operational state of the instance. Foreign key to the VMEnabledState table.

MacAddress

Type: text (max 256 characters). 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.

MatchingRuleID

Type: integer. Nullable

Matching rule is used to match the instance with an inventory in Compliance Computer. Foreign key to the CloudServiceInstanceMatchingRule table.

InventoryDate

Type: datetime. Key. Nullable

The time the cloud instance was reported by inventory.

CloudServiceProvider InventoryDate

Type: datetime. Nullable

The time the cloud instance was reported by an adapter.

CloudTenantID

Type: text (max 36 characters). Nullable

The cloud Tenant ID of the instance.

CloudSubscriptionID

Type: text (max 36 characters). Nullable

The cloud subscription ID of the instance.

CloudServiceTypeID

Type: integer. Nullable

The cloud service type ID of the instance.

RDSCloudLicenseTypeID

Type: integer. Nullable

The RDS cloud license type ID of the instance.