Restricting the records or data to be written to the Event_log table

Document ID : KB000031077
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

How to exclude data or records from being written to the CA Service Desk Manager MDB Event_Log table?

Answer:

The Event_log MDB table stores all the different activities that take place within CA SDM. In the Event_log table there is a column called Event. This column value varies from 1-21. 

Event - Value 

Login - 1 

Logout -2 

CR_CREATE - 3 and so on.. ...

The system environment variable @NX_EVENT_LOG_EXCLUDE, which is set in the NX.env file, controls the amount of data that is stored in the event log (event_log MDB table). This variable stores only the events to track, report on and use as part of the Recent Activity that can be launched as a button from the Quick Profile page. 

Within this variable, commas separate list items (for example, @NX_EVENT_LOG_EXCLUDE = FAQ,KD_OPEN).

For example, if you use the LOGIN, LOGOUT events from the following table (@NX_EVENT_LOG_EXCLUDE value of LOGIN,LOGOUT), CA SDM will not record login and logout events. 

For more details on Event_Log values and how to exclude specific item, please refer to Page 354 - Event Log Data Storage Customization of the CA SDM Implementation Guide.

Run the below commands to install this Option:

pdm_options_mgr -c -s EVENT_LOG_EXCLUDE -v "CR_CREATE,TICK_OPEN,TICK_SEARCH,LOGIN,LOGOUT,CHG_CREATE" -a pdm_option.inst 

pdm_options_mgr -c -s EVENT_LOG_EXCLUDE -v "CR_CREATE,TICK_OPEN,TICK_SEARCH,LOGIN,LOGOUT,CHG_CREATE " -a pdm_option.inst -t

NOTE:  As with any changes to the NX.ENV file, changes to the @NX_EVENT_LOG_EXCLUDE variable requires a restart of the CA SDM service for the change to take effect.