Click HERE to see how Saviynt Intelligence is transforming the industry. |
05/28/2024 02:17 AM
Hi Team -
I am looking for help with generating detailed audit report for firefighter access from SAP. The documentation regarding this does not really help with understanding the process involved. Has someone already generated Level 2 - Audit Logs Report? Please can you let me know the process
https://docs.saviyntcloud.com/bundle/SAP-v24x/page/Content/Generating-Firefighter-Reports.htm
Thank you
05/28/2024 07:35 AM
Check these posts :
FireFighter sessions report - Saviynt Forums - 40513
05/28/2024 10:57 AM
SELECT DISTINCT RA.request_accesskey AS REQACCKEY,
RA.startdate AS STDATE,
AREQ.jbpmprocessinstanceid AS REQID,
RA.enddate AS EDATE,
RA.status AS STTS,
EP.endpointname AS EPNAME,
EP.displayname AS EPDISPNAME,
U.username AS USERNAME,
A.NAME AS NAME,
arstasks.status AS TASKSTATUS
FROM request_access RA
JOIN arstasks
ON RA.request_accesskey = arstasks.requestaccesskey
JOIN ars_requests AREQ
ON RA.requestkey = AREQ.requestkey
JOIN users U
ON RA.userkey = U.userkey
JOIN accounts A
ON RA.accesskey = A.accountkey
JOIN endpoints EP
ON A.endpointkey = EP.endpointkey
WHERE RA.accesstype = 8
AND RA.requesttype = 24
AND EP.status = 1
AND RA.status NOT IN ( 4, 7, 6 )
ORDER BY RA.request_accesskey DESC;
05/28/2024 10:22 PM
Thanks @rushikeshvartak @Manu269 . I am looking for a more detailed audit report that contains the details of transactions user performed in SAP with the FFID access as mentioned in this documentation - https://docs.saviyntcloud.com/bundle/SAP-v24x/page/Content/Generating-Firefighter-Reports.htm
I have configured the Level 1 firefighter transaction report but it does not contain more information regarding all the actions user performed in SAP during the FFD session. Not sure if Level 2 audit report would help with this.