View all search terms used in employee center

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2023 07:35 PM
Can someone please tell me where I can find the search queries our clients are using in employee center?
What I'd like to have a report that shows me what terms are used in employee center searches by our users and even better if we can see what the results are or what they clicked on (if anything).
Ideas?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2023 11:05 PM
Hi @Bidduam ,
Search Logs for Portals are stored in sp_log table where you can filter it by type = search and portal = employee Center
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Uday

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-15-2023 11:42 PM
@Uday Soni05 thank you that does give me the terms used, but that's about all it shows, I can't see the results (it does show a figure and the table, eg: catalog or knowledge, but not actual results)
You also can't see who did the search.
Any other ideas?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-16-2023 12:42 AM
Hi @Bidduam ,
Yes we don't have those attributes in this table
We have ts_query_kb table but this only gives for knowledge base
Regards,
Uday
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-14-2024 01:45 PM
This doesn't seem to work for me, I can see all the entries for 'employee service center' but there is no entries that have a 'type' with the word 'search' in it?