Is there any mechanism to alter the CA SDM Search Server initial load parameters?

Document ID : KB000119919
Last Modified Date : 05/11/2018
Show Technical Document Details
Question:
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
Answer:
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 statement used for the CA SDM Search Server load.

***Please note that the below steps are NOT SUPPORTED by CA 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 at https://docops.ca.com/ca-service-management/17-1/en/administering/configure-ca-service-desk-manager/configure-the-xflow-analyst-interface/perform-initial-load-and-refresh-index-and-data-on-the-search-server#PerformInitialLoadandRefreshIndexandDataontheSearchServer-RefreshIndexandDataontheSearchServer
Additional Information:
https://docops.ca.com/ca-service-management/17-1/en/administering/configure-ca-service-desk-manager/configure-the-xflow-analyst-interface/perform-initial-load-and-refresh-index-and-data-on-the-search-server#PerformInitialLoadandRefreshIndexandDataontheSearchServer-RefreshIndexandDataontheSearchServer

https://docops.ca.com/ca-service-management/17-1/en/installing/installing-ca-service-management/installing-ca-service-desk-manager/search-server-configuration-details