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.
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.
Database Column |
Details |
---|---|
RegionID
|
Type: integer. Key The region consumption is being recorded for. Foreign key to the |
SoftwareLicenseID
|
Type: integer. Key The license being assessed. Foreign key to the |
SoftwareTitleProductID
|
Type: integer. Key The software title product the consumption is being recorded for. Foreign key to the |
HostID
|
Type: integer. Key The host machine.
For standalone computer, this will be the computer itself. Foreign key to the |
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 |
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 |