Chuck wrote:
In case anyone else needs to do this, I used this solution:

Log on to the repository DB as SYSMAN and run the following procedure.
Modify the cursor to fit your needs.

DECLARE
CURSOR c1 IS
SELECT s.target_guid,
s.metric_guid,
s.key_value
FROM mgmt_targets t JOIN mgmt_current_severity s
ON s.target_guid = t.target_guid
WHERE LOWER(t.target_name) LIKE '%myhost%'
AND t.target_type = 'host';
BEGIN
FOR r IN c1 LOOP
em_severity.delete_current_severity(r.target_guid,
r.metric_guid,
r.key_value);
DELETE from sysman.mgmt_severity
WHERE
target_guid = r.target_guid AND
metric_guid = r.metric_guid AND
key_value = r.key_value;
END LOOP;
COMMIT;
END;