Enhancement - CONTENT report - add queries for PlatofrmSearch Surrogate files

[former_member50823]

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'

[former_member398039]

Hey Rob, there will be an alert added for the upcoming 2.1 release in hopes to make customers aware of this bug. Getting the actual count could be tricky as that could timeout (as per Leslie).

[Toby_Johnston]

Thanks Rob. We will add this for the next version