ComputerResourceHierarchySCD Table

ComputerResourceHierarchySCD is a table defining relationships between computer resources

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

Database Column

Details

ComputerResourceID

Type: integer. Key

The guest resource in the relationship. Foreign key to the ComputerResourceData table.

HostComputerResourceID

Type: integer. Key

The host resource in the relationship. For an unhosted computer and for a host computer this value will be identical to the ComputerResourceID value. Foreign key to the ComputerResourceData table.

ParentComputerResourceID

Type: integer. Key. Nullable

The direct parent of the guest resource (which might be, for example, a resource pool). Is NULL when the guest resource has no parents within the hierarchy. Foreign key to the ComputerResourceData table.

ValidFrom

Type: datetime. Key

Date from which this relationship record became valid.

ValidTo

Type: datetime. Key

Date this hierarchy was valid to, or 9999-12-31T23:59:59.997 if it is currently valid. (This string is used to represent an indefinite future.)