This table is typically used by Unicenter Asset Management. Asset Management allows you to create company policies based on database queries. A policy usually triggers one or more policy jobs or actions. An example of a policy could be the "Remove DOOM games" policy, which is based on a query that finds all Computers with the game DOOM installed. A policy action is executed when a new computer with DOOM installed is found, and the policy action will schedule a job to delete the DOOM files from the computer. Each Policy in the system is defined by one entry in this table. The DOMAINID and POLID fields key each Policy. A policy in the Asset Management system is based on a database query and triggers one or more policy actions (jobs). The policy name can be read in the POLNAME field. The POLSEV field describes the severity ("alarm", "warning" and "message" - displayed as red, green and yellow icons in the Admin Console) and only values of 1, 2 and 3 are allowed: Red ("alarm") = 1 Yellow ("warning") = 2 Green ("message") = 3 The POLMEMO contains a few scheduling and general display settings for the policy. The LRUNDATE is the date/time the policy was last updated by an Engine. It is used when an Engine is scheduled to update the policy at an hourly interval.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| polid | integer | not null | Unique Policy ID |
| domainid | integer | not null | Domain ID |
| polsev | integer | with null | Policy severity |
| polname | nvarchar(127) | with null | Unique Policy name |
| polmemo | nvarchar(15000) | with null | Description of Policy |
| lrundate | integer | with null | Last Rundate for this policy (Last updated if configured at Interval times) |
| query_uuid | byte(16) | with null | Query uuid that this Policy depends on. Foreign key to ca_query_def |
| evaluation_uuid | byte(16) | with null | Engine uuid. Foreign key to ca_engine |
| eval_freq | integer | with null | Evaluation frequency. Seconds. |
| auto_rep_version | date | with null | Modification Date. Automatically maintained by Rule. Used for replication. |
| policy_uuid | byte(16) | with null | Policy UUID. Will be filled but not used as primary key in this version. Used for user security definitions. |
| creation_user | nvarchar(255) | with null | User that has created Policy |
| creation_date | integer | with null | Creation date in text |
| last_update_user | nvarchar(255) | with null | Last updated by User in Text |
| last_update_date | integer | with null | Last Updated Date in Text |
| notify_user_uuid | byte(16) | with null | User to notify when policy is violated |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| polid domainid |
polijob | polid domainid |