Monday, October 6, 2008

Get oracle client IP address from AUD$

select distinct
terminal||'^'||
substr(substr(comment$text,instr(comment$text,'HOST=')+5,100),1,instr(substr(comment$text,instr(comment$text,'HOST=')+5,100),')')-1)
from sys.aud$;