Restricting the data written to the Event_log MDB table

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

How to exclude data from being written to the MDB Event_Log table?

Environment

Service Management 17.x

Resolution

The Event_log MDB table stores all the different activities that take place within CA Service Desk Manager. 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 the following documentation

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.