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.
`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.