To perform the rollback, do the following:

1. Enter the Admin database:

   /opt/trend/imss/PostgreSQL/bin/psql imss sa

2. EXPAND ALL

    

   Option 1 

   1. Check the current value:

      imss=# select * from tb_global_setting where name='detection_aggressive_level';
       section |            name            | value | inifile  |      notes       
      ---------+----------------------------+-------+----------+------------------
       general | detection_aggressive_level | 3     | imss.ini |                 
      (1 row)
      

   2. Update the value to "4":

      imss=# update tb_global_setting set value='4' where name = 'detection_aggressive_level';
      UPDATE 1
      

   3. Confirm the new value:

      imss=# select * from tb_global_setting where name='detection_aggressive_level';         
       section |            name            | value | inifile  |      notes       
      ---------+----------------------------+-------+----------+------------------
       general | detection_aggressive_level | 4     | imss.ini |                 
      (1 row)
      

   4. Revert to the original value of "3":

      imss=# update tb_global_setting set value='3' where name = 'detection_aggressive_level';
      UPDATE 1
      

   5. Confirm if the value is reverted to "3":

      imss=# select * from tb_global_setting where name='detection_aggressive_level';         
       section |            name            | value | inifile  |      notes       
      ---------+----------------------------+-------+----------+------------------
       general | detection_aggressive_level | 3     | imss.ini |                 
      (1 row)
      

   Option 2 

   1. Check if the following row exists:

      imss=# select * from tb_global_setting where name = 'rules_included';                   
       section | name | value | inifile | notes
      ---------+------+-------+---------+-------
      (0 rows)
      

   2. Insert new values:

      imss=# insert into tb_global_setting values('general','rules_included','HEUR_VBA.O1;HEUR_VBA.O2;HEUR_VBA.D;HEUR_VBA.E;HEUR_VBA.E2;HEUR_VBA.E3', 'imss.ini', NULL);
      INSERT 0 1
      

   3. Confirm if the new row is added:

      imss=# select * from tb_global_setting where name = 'rules_included';                                                                                             
       section |      name      |                                 value                                 | inifile  | notes
      ---------+----------------+-----------------------------------------------------------------------+----------+-------
       general | rules_included | HEUR_VBA.O1;HEUR_VBA.O2;HEUR_VBA.D;HEUR_VBA.E;HEUR_VBA.E2;HEUR_VBA.E3 | imss.ini |
      (1 row)
      

   4. Delete the new row:

      imss=# delete from tb_global_setting where name = 'rules_included';
      DELETE 1
      

   5. Confirm if the new row is deleted:

      imss=# select * from tb_global_setting where name = 'rules_included';
       section | name | value | inifile | notes
      ---------+------+-------+---------+-------
      (0 rows)
      

   6. Quit the database.

      imss=# \q