SoftwareLicensePVUPointsConsumedComputersSCD Table

SoftwareLicensePVUPointsConsumedComputers relationship between a consuming computer and the computers involved in the consumption. This should include VMs with installations of only supplementary titles as well.

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 `SoftwareLicensePVUPointsConsumedComputersSCD` table
Database Column	Details
`RegionID`	Type: integer. Key The region consumption is being recorded for. Foreign key to the `Region` table. If NULL, device not belonging to any region
`SoftwareLicenseID`	Type: integer. Key The license being assessed. Foreign key to the `SoftwareLicense` table.
`SoftwareTitleProductID`	Type: integer. Key The software title product the consumption is being recorded for. Foreign key to the `SoftwareTitleProduct` table.
`HostID`	Type: integer. Key The host machine. For standalone computer, this will be the computer itself. Foreign key to the `ComplianceComputer` table.
`ComplianceComputerID`	Type: integer. Key The machine involved in consuming PVU point under the host. For standalone computer, this will be the computer itself. Foreign key to the `ComplianceComputer` table.
`ParentPoolID`	Type: integer. Nullable The identifier of the resource pool this device resides in.
`CoreCount`	Type: integer Number of cores at the time of consumption calculation
`IsEligibleInventory`	Type: boolean Is the device eligible for inventory at consumption calculation
`Pool1Name`	Type: text (max 256 characters). Nullable Name of 1st level pool of this consuming device (assumption: max up to 2 levels of pool hierarchy).
`Pool1CoreCount`	Type: integer. Nullable Core count of 1st level pool of this consuming device (assumption: max up to 2 levels of pool hierarchy).
`Pool2Name`	Type: text (max 256 characters). Nullable Name of 2nd level pool of this consuming device (assumption: max up to 2 levels of pool hierarchy).
`Pool2CoreCount`	Type: integer. Nullable Core count of 2nd level pool of this consuming device (assumption: max up to 2 levels of pool hierarchy).
`IsCapped`	Type: boolean Does this layer implement hard partitioning for this license?
`ValidFrom`	Type: datetime. Key The start time of the PVU usage
`ValidTo`	Type: datetime The end time of the PVU usage
`LicenseMeasurementID`	Type: integer. Key The snapshot ID. Foreign key to the `LicenseMeasurement` table.