Every record in the OV_PM_PolicyVersion table represents one policy version. The main policy identifier is a set of three values: PolicyId, MajorVersion, and MinorVersion. The PolicyVersionId is an internal unique identifier for every policy version. The policy version is linked to the logical policy it belongs to using the PolicyId.
The MinPolicyTypeVersion specifies the minimal version of the Policy Type that can interpret the syntax of the policy version.
Column Name | Constraint | Column Type | Description |
---|---|---|---|
PolicyVersionId | PK, I1 | uniqueidentifier | ID of this policy version. |
PolicyId | FK1,I2 | uniqueidentifier | ID of the logical policy. |
MinPolicyTypeVersion | smallint | Syntax version of this policy version. It corresponds to the minimum required policy type version, which determines the minimum agent package version that must be installed on the node to interpret the syntax of the policy. | |
MajorVersion | I2 | smallint | Major version of this policy version. |
MinorVersion | I2 | smallint | Minor version of this policy version. |
Description | nvarchar(256) | Purpose of this policy version. | |
CreatedBy | nvarchar(64) | Name of the user who created this policy version. | |
CreatedOn | datetime | Time when this policy version was created. | |
RegisteredOn | datetime | Time when this policy was added to (registered with) the server. | |
ConflictIndex | I2 | smallint | If the value of this column is greater than zero (for example, one or two), there are two or more instances of the same policy version registered with the policy management server. Although rare, this could happen if the same policy version is modified on different management servers, saved under the same version number, and then imported on the same management server. If, for example, you modify a SPI policy, save it under the next higher major version number, and then a new version of this SPI is installed on the server that registers the same policy version, you run into this conflict scenario. In such a case, the policy version with a conflict index of one or two appears in the UI with one or two asterisks (* or **) at the end of the policy name. You must decide which of the two or more instances of the policy version should be deleted. |