SoftwareLicensePVUPointsConsumedPoolsSCD Table

SoftwareLicensePVUPointsConsumedPoolsSCD records pool details and relationships for devices consuming PVU points on a PVU license.

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 SoftwareLicensePVUPointsConsumedPoolsSCD 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 of this pool. Foreign key to the ComplianceComputer table.

PoolID

Type: integer. Key

The identifier of this resource pool. Primary key referenced by the SoftwareLicensePVUPointsConsumedComputersSCD table.

PoolPathID

Type: text (max 128 characters)

A numerical representation of the path of this pool, constructed from PoolID values (something like: “1.2.”).

ParentPoolID

Type: integer. Nullable

The parent identifier of this resource pool.

PoolFriendlyName

Type: text (max 256 characters)

The friendly name of the pool.

VMPoolTypeID

Type: integer

The type of pool. Foreign key to the VMPoolType table.

CoreSubcapacityLimit

Type: integer

The maximum number of cores that can be consumed for the license on this resource pool.

CoreSubcapacity

Type: integer. Nullable

The number of cores consumed for the license on the resource pool.

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.