[Fortify] SSC DB 정리 SQL

-- Fortify SSC DB 정리 SQL (MySQL/Fortify SCA 4.31 기준)
--
-- 1. 관리자 패스워드 유효기간 제거
-- 2. 스케줄러 초기화
-- 3. 오류가 발생한 Artifact 제거
--
-- ※ db_ssc_0431는 DB명

-- 관리자 패스워드 유효기간 제거
UPDATE db_ssc_0431.fortifyuser SET passwordNeverExpire="Y" WHERE userName="admin";

-- 스케쥴러를 초기화 한다.
DELETE FROM db_ssc_0431.qrtz_blob_triggers;
DELETE FROM db_ssc_0431.qrtz_calendars;
DELETE FROM db_ssc_0431.qrtz_fired_triggers;
DELETE FROM db_ssc_0431.qrtz_paused_trigger_grps;
DELETE FROM db_ssc_0431.qrtz_scheduler_state;
DELETE FROM db_ssc_0431.qrtz_simple_triggers;
DELETE FROM db_ssc_0431.qrtz_simprop_triggers;
DELETE FROM db_ssc_0431.artifact WHERE status="PROCESSING" OR status="ERROR_PROCESSING" OR status="ERROR_DELETING";
DELETE FROM db_ssc_0431.jobqueue WHERE userName="admin";

FLUSH PRIVILEGES;