We are making SA - Arcsight integration using oracle tablesTo be able to perform this integration, they would like to know the tables where the session logs reside in database.
We make a sql statement like below.But this query can't get package informatipn.
We want to add the package name info(which is installed during the session) to the sql statement but we couldn’t find where it’s.
Could you help us on this issue?
SELECT s.SESSION_ID,s.AGENT_NAME,s.SESSION_DESC,s.START_DT,s.SCHED_DT,s.STATUS,s.END_DT,s.TRAN_ID,u.USER_ID,u.USERNAME,d.DVC_ID,d.SYSTEM_NAME from DEVICES d, SERVICE_INSTANCES si, SESSION_SERVICE_INSTANCES ssi, SESSIONS s, USERS u where s.USER_ID = u.USER_ID AND d.DVC_ID = si.DVC_ID AND si.SRVC_INST_ID = ssi.SRVC_INST_ID AND ssi.SESSION_ID = s.SESSION_ID;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.