SoftwareLicensePVUPointsConsumedComputersSCD Table

FlexNet Manager Suite (Cloud)

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.

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.

FlexNet Manager Suite (Cloud)

Current