ComputerResourceHierarchySCD Table

FlexNet Manager Suite 2020 R1 (On-Premises)

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

FlexNet Manager Suite (On-Premises)

2020 R1