Security History Application and F9312

 

Failed Login for Specific User - 

SELECT * FROM SY920.F9312 WHERE SHUSER='xxxxx' AND SHEVTYP='01' and SHEVSTAT='02' 

User Added this year (2025)

SELECT * FROM SY920.F9312  where SHEVTYP='05' and SHUPMJ>=125001

User Delete this year (2025)

SELECT * FROM SY920.F9312  where SHEVTYP='06' and SHUPMJ>=125001

Here is a List of all Event Tyoe (SHEVTYP)