Skip to main content

Monitor Genie space usage with audit logs and alerts

This page provides sample queries that workspace admins can use to monitor user feedback from Genie spaces. All queries access the audit logs table, which is a system table that stores records for all audit events from workspaces in your region.

See Audit log system table reference. For a comprehensive reference of available audit log services and events, see Audit log reference.

Monitor Genie spaces​

The examples in this section demonstrate how to retrieve audit logs for common questions about Genie space activity.

Monitor feedback​

The following query returns feedback ratings submitted for the Genie spaces in your workspace from the past 30 days. The columns in the query include the space_id and the email address of the user who submitted the feedback, along with all other columns from the system table.

SQL

SELECT
  user_identity.email as user_email,
  action_name,
  request_params.space_id,
  request_params.feedback_rating,
  *
FROM
  system.access.audit
WHERE
  service_name = 'aibiGenie'
  AND action_name = 'updateConversationMessageFeedback'
  AND event_date >= current_date() - interval 30 days

Monitor requests for review​

The following query returns request for review activity from Genie spaces over the past 30 days. It includes the space_id, the email address of the user who added the comment, the type of action, and all other columns from the source table.

SQL
SELECT
  user_identity.email as user_email,
  action_name,
  request_params.space_id,
  *
FROM
  system.access.audit
WHERE
    service_name = 'aibiGenie'
    AND action_name = 'createConversationMessageComment'
    AND event_date >= current_date() - interval 30 days

Set up alerts​

You can set alerts to help automate this type of monitoring. To set up an alert, save the query you want to monitor. Then, follow the steps in Create an alert to set an alert on a specific threshold.

Last updated on