Alter CA SDM Search Server initial load parameters

Products

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

Issue/Introduction

Is there any mechanism to alter the CA SDM Search Server initial load parameters?  For example, limit the initial load to only 3 months worth of ticket data? 

Environment

CA Service Desk Manager 17.x
All Supported Operating Systems

Resolution

There is no out of the box mechanism to control the CA SDM Search Server initial load parameters.

However, you can tweak the behind the scenes SQL statements used for the CA SDM Search Server load.

***Please note that the below steps are NOT SUPPORTED by Broadcom Support and are only provided as a guide.  We recommend testing in a non-PROD environment first.**

1. During the install of the CA SDM Search Server, deselect the option to perform the initial load.
2. On the CA SDM Search Server, navigate to the C:\Program Files\CA\SC\CASearchServer\search\config directory and open the SQL.JSON file with a text editor
3. Modify the relevant SQL queries and save the file
4. Manually run the CA SDM Search Server load by running the 'pdm_es_rebuild_index.bat' command as documented

Additional Information

Perform Initial Load and Refresh Index and Data on the Search Server

Search Server Configuration Details