Article Original Creation Date: 2011-06-20

Overview

The article details the process of resetting the Success, Skipped, and Failed counts for policies in SG4.x.

NOTE: If you are unsure of the queries or code changes mentioned in this article, please reach out to support for clarification and direction.

Environment

• Solaris 10
• Oracle 10
• Jboss 4.0.4-GA
• Tomcat 5.5.25
  
  

Information

The various counts for the policies are saved in the sprt_sg_policy_exec_history table. To alter the counts, you need to update the sprt_sg_policy_exec_history table.

Before updating the table, stop the Front_end and Timer services and, after executing the queries, commit the changes.

The SQL query to reset all count to 0, is as follows:

UPDATE sprt_sg_policy_exec_history
SET success_count=0,
    failed_count=0,
    skipped_count=0;

COMMIT;

In case you want to delete count for a specific policy, you need to fetch its guid from the sprt_sg_policy table.

To fetch the guid of a sample policy say 'sample_policy,' execute the following query:

SELECT *
FROM sprt_sg_policy
WHERE name='<sample_policy>';

The guid found in the above query can be used to reset the count of that specific policy. Following is the SQL query to reset count for a sample policy with guid as 'sample_policy_guid':

UPDATE sprt_sg_policy_exec_history
SET success_count=0,
    failed_count=0,
    skipped_count=0
WHERE sg_policy_guid ='sample_policy_guid';

COMMIT;