HP Operations Manager for Windows

Table OV_PM_PolicyOnNode


The OV_PM_PolicyOnNode table keeps the inventory information about policies installed on different nodes. The IsEnabled flag shows the enabled/disabled status of a policy on a managed node. The Owner field specifies the management server system that owns a policy on the managed node. Records in this table are cascaded, and so are removed automatically when the corresponding policy or managed node is removed.

Column Name Constraint Column Type Description
PolicyVersionId PK, FK1, I1 uniqueidentifier ID of the policy version that is installed on the referenced node.
NodeId PK, FK2, I1 nvarchar(64) ID of the node where the referenced policy version is installed.
IsEnabled   bit If true, the policy version is enabled on the node.
Owner   nvarchar(256) Name of the server that has deployed the policy to the node.
DeployedBy   nvarchar(64) Name of the user who has deployed the policy to the node.
DeployedOn   datetime Deployment time of the policy.