select l.TS_ID, l.TS_SUBMITDATE, l.TS_LEVEL_2_TECHNICIAN from TSM_INCIDENTS l where ( tsm_incidents .ts_id in (select ts_itemid from ts_changeactions where ts_tableid=(select ts_tables.ts_id from ts_tables where ts_name = 'Incidents') and ts_userid=(select ts_users.ts_id
Oracle – Service Request Violations in last month @where TSM_INCIDENTS .TS_ID in (SELECT ITEM_ID FROM SLA_ITEM where RISK_CATEGORY=’V’ AND START_DATE >= add_months(trunc(sysdate,'mm'),-1) and START_DATE < trunc(sysdate, 'mm' and ITEM_TABLE_ID=1011
ORACLE Example for all items in last month that violated their SLA: @where TSM_INCIDENTS .TS_ID in (SELECT ITEM_ID FROM SLA_ITEM where (RISK_CATEGORY='V' OR RISK_CATEGORY='L' OR RISK_CATEGORY='M') AND START_DATE >= add_months(trunc(sysdate,'mm'),-1)
