2 Replies Latest reply on Apr 9, 2013 8:58 AM by Mari_SGS

Search key

Mari_SGS Apr 8, 2013 12:37 PM

Hi Team,

Can you please give an clarification through which table where we can get the Search key details of McAfee Community form Analytical and Application Database.

here Search Key means the keyword used for searching the required content, that word that we put in the search tab

have checked in the Application database, i could see JiveSearchengine table but it shows empty .

Regards,

Mari V

Note : I am from McAfee BI Team

Re: Search key

josh.richau Apr 8, 2013 12:57 PM (in response to Mari_SGS)

you should be able to find this in the analytics DB. More info here: https://community.jivesoftware.com/docs/DOC-4778

The searches are stored in the jivedw_activity_fact table (activity_types 170,180,190) and the search strings are in the metadata column. However, I do not think these events are rolled up into the aggregate tables.

For reference, the 3 search events captured are:
170 - SEARCH_CONTENT
180 - SEARCH_USERS
190 - SPOTLIGHT_SEARCH
Like (1)

Actions
- Re: Search key
  
  Mari_SGS Apr 9, 2013 8:58 AM (in response to josh.richau)
  
  Thanks Josh, it was helpful.
  
  Like (0)
  
  Actions

Go to original post

Legend

Correct Answers - 4 points