GRC10.1 EAM consolidated log - where are descriptions stored?

[Former Member]

Hi,

when Firefighter logs on to a system via EAM, user can give description for reason code and planned activity and during the session, add additional activity.

After completing the session, where is this information stored? It is not in any of the tables that are mentioned to store FF log information:

• GRACAUDITLOG
• GRACCHANGELOG
• GRACOSCMDLOG
• GRACSYSTEMLOG
• GRACFFLOG
• GRACROLEFFLOG

I have found some structures that use this information and the field names (REASON_CODE_DESCN, ACTIVITY_DESCN, ADDNL_ACTIVITY_DESCN) that are used in the structures:

I can't find any tables with these fields included. What is the actual table where this data is stored? I'm starting to think there isn't one but how does this work in that case - how does the information go to consolidated log in NWBC?

BR,

Anni

[former_member604810]

I needed this details, when i was unable to fetch the FF logs from NWBC due to Memory issue.

one user who used LTMC (data loading) and that caused Huge logs that exceeds the memory that results in inability to approve the logs.

1. Check the FF Log in NWBC- Search FF requests, for which you want to see the description/information.

2. In SAP system, open the Table SE16-> GRACFFLOG search for the same log by inputting the FF user's ID and FF owner's ID to see the logs. You will get all the logs used by user, choose the entry by seeing the Logon time/date

3. Go to SE24 -> CL_GRFN_SAPSCRIPT

4. Click RETRIEVE_EN_STRING, enter IV LANGUAGE as EN, IV CLASS: LTXT, IV TOKEN: SPM_RC, IV_APPLICATION: GRC and in the OBJECT_ID, paste the value copied from table FFLOG_ID.

you will get the Reason Code used:

Similarly, in the IV_TOKEN, enter SPM_ACT then you will get the information entered in the Actions box:

There are no Tables to see this information. I did debug with help of ABAPer to find this details for an Audit reference.

Hope this is helpful, Thanks.

Regards,

Giridharan Dhamodharan

SAP Security & GRC consultant