Skip to Content
0
Aug 30, 2017 at 01:09 PM

Enhancement - CONTENT report - add queries for PlatofrmSearch Surrogate files

124 Views

Sometimes we see PlatformSearch backlogs.

Sometimes in certain older versions, we can see the CMS DB grow due to a bug with NOT deleting the Surrogate files.

something similar to:

SELECT COUNT (SI_ID) FROM CI_SYSTEMOBJECTS WHERE

SI_KIND = 'PlatformSearchContentSurrogate'

(I can't seem to find them using SI_KIND - might be a bug)

or this works:

select * from ci_systemobjects where si_name like '%Surrogate%'

(but, soemhow filter out the results for Deployment files/DFOs)

or use this:

select COUNT (SI_ID) from ci_systemobjects where SI_NAME = 'CrystalEnterprise.PlatformSearchContentSurrogate'