Operating a search function

Use a search function to construct a IBM®Content Cortex Content Engine SQL query to generate new or retrieve from in-cache values of the counters.

1. In the administration console for Content Engine, navigate to object store > Administrative > Storage > Advanced Storage > Advanced Storage Areas > storage area and determine its Display name.

   For example, advanced storage area name ASAOS3.

2. In the Search dialog, create a New Object Store Search
3. In the SQL View, paste a Content Engine SQL query to use the search functions that fetch the desired information.

   For example, the following Content Engine SQL includes readable column headers and the storage size in gigbytes help format the results.

   SELECT [This],DisplayName, AdvancedStorage::ElementCount(this) AS ContentElementCount, AdvancedStorage::OriginalSize(this,'gb') AS OriginalSize_GB, AdvancedStorage::StoredSize(this,'gb') AS StoredSize_GB
   FROM [CmAdvancedStorageArea]
   WHERE [DisplayName] = 'ASAOS3'