ImportedVMHostManagedBySoftware Table

The ImportedVMHostManagedBySoftware table contains relationships between installer evidence of management software and VM hosts it manages.

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 ImportedVMHostManagedBySoftware table

Database Column

Details

ComplianceConnectionID

Type: integer. Key

The identifier for a data source connection in the ComplianceConnection table.

ExternalInstallerID

Type: big integer. Key

The identifier used in the source connection for an installer evidence of management software.

ExternalComputerID

Type: big integer. Key

The identifier used in the source connection for the computer that the management software installer evidence is installed on.

RelationType

Type: text (max 100 characters). Key

Identifier for the type of relation, to be matched against ImporterString column of RelationType table.

ExternalVMHostID

Type: big integer. Key

The identifier used in the source connection for the VM host computer that is managed by a management software.