SELECT CALLING_STATION_ID, AUTHENTICATION_PROTOCOL, PASSED
FROM RADIUS_AUTHENTICATIONS
WHERE CALLING_STATION_ID = 'AA:BB:CC:DD:EE:FF'
ORDER BY TIMESTAMP_TIMEZONE DESC
FETCH FIRST 5 ROWS ONLY
Department Progress
SELECT FRAMED_IP_ADDRESS, AUTHENTICATION_PROTOCOL
FROM RADIUS_AUTHENTICATIONS
WHERE FRAMED_IP_ADDRESS LIKE '10.50.10.%' -- Department subnet
AND TIMESTAMP_TIMEZONE > SYSDATE - 1