How to exclude data or records from being written to the CA Service Desk Manager MDB Event_Log table?
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
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.