Clearing policy violation

Hi,

here is a way to clear alert on monitored targets :

 select target_name,t.target_type ,collection_timestamp ,MESSAGE ,'exec sysman.em_severity.delete_current_severity('''

|| t.target_guid || ''',''' ''',''' || metric_guid || ''',''' || key_value || ''');'

''',''' || key_value || ''');' ''');' em_severity FROM sysman.mgmt_targets t INNER JOIN sysman.mgmt_current_severity s ON t.target_guid = s.target_guid FROM sysman.mgmt_targets t INNER JOIN sysman.mgmt_current_severity s ON t.target_guid = s.target_guid WHERE target_name LIKE '%myserver%' target_name LIKE