LicenseSimulationSWDetails Table

LicenseSimulationSWDetails stores a complete snapshot of software data for simulations. The LicenseSimulationHWDetails record associated with each LicenseSimulationSWDetails record could be part of an original snapshot of data, or a user modifiable scenario.

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 LicenseSimulationSWDetails table

Database Column


LicenseSimulationSW DetailsID

Type: integer. Key. Generated ID

A unique identifier for a software installation that is part of a simulation scenario.

LicenseSimulationHW DetailsID

Type: integer. Key

The hardware item that this software title is installed on. Foreign key to the LicenseSimulationHWDetails table.

LicenseSimulation ScenarioID

Type: integer. Key

The simulation scenario this softare installation is part of. Foreign key to the LicenseSimulationScenario table.

OriginalLicense SimulationSWDetailsID

Type: integer. Key. Nullable

The original version of this software installation, that has not been modified by a simulation user.


Type: text (max 512 characters)

The friendly name of this software installation.


Type: integer. Key

The software title that is installed here. Foreign key to the SoftwareTitle table.


Type: integer. Key

The software license that this install is assigned to. Foreign key to the SoftwareLicense table.

LicenseSimulation ChangeTypeID

Type: integer

Tracks the state of the softare installation, as it gets modified by the simulation user. Foreign key to the LicenseSimulationChangeType table.


Type: boolean

Set this field to True if the software title is installed according to usage thresholds in the SoftwareTitle table.