从oracle的create session的审计日志提取ip地址
使用如下sql:
SELECT DISTINCT REGEXP_SUBSTR(COMMENT_TEXT,
'((2[0-4]\d|25[0-5]|[01]?\d\d?)\.){3}(2[0-4]\d|25[0-5]|[01]?\d\d?)') AS STR
FROM DBA_AUDIT_TRAIL
WHERE ACTION_NAME = 'LOGON';
使用如下sql:
SELECT DISTINCT REGEXP_SUBSTR(COMMENT_TEXT,
'((2[0-4]\d|25[0-5]|[01]?\d\d?)\.){3}(2[0-4]\d|25[0-5]|[01]?\d\d?)') AS STR
FROM DBA_AUDIT_TRAIL
WHERE ACTION_NAME = 'LOGON';
近期评论