Failed Login for Specific User -
SELECT * FROM SY920.F9312 WHERE SHUSER='xxxxx' AND SHEVTYP='01' and SHEVSTAT='02'
User Added year For Eg date 01-01-2025 or greater
SELECT * FROM SY920.F9312 where SHEVTYP='05' and SHUPMJ>=125001
User Delete For Eg date 01-01-2025 or greater
SELECT * FROM SY920.F9312 where SHEVTYP='06' and SHUPMJ>=125001
Here is a List of all Event Tyoe (SHEVTYP)
