Sa- Archsight integration

Sa- Archsight integration

0 Votes

Hello;

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;

 

 

 

Kind regards..

1 Comment
Micro Focus Expert
Micro Focus Expert
Status changed to: New Idea

Hello. Since this request is framed like a question about the current model of SA, I would advise posting the question on the SA user discussions forum.

https://community.softwaregrp.com/t5/Server-Automation-User/bd-p/sws-SA_SUP#.W5IneegzZPY

If you wish to submit an enhancement request to implement and SA - Arcsight integration, please provide more details about the use cases that are targeted.

Thanks.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.