Running an ad-hoc query

To examine a non-recurring specific issue, such as all sessions from yesterday that had errors, or the last 1000 pages with server errors, you must run a custom query in the Session Browser.

To run an ad-hoc query

1. In a Real User Analyzer, open the Session Browser tab.

2. Switch to specifying a custom query by clicking custom queries.
3. (Optional) Provide filtering criteria to extract only the specific sessions:
   • In the Show selector, select to show sessions or pages.
     For sessions you can also specify the status of the displayed sessions (Completed, In progress, or both).
   • In the Watchpoint selector, provide a specific Watchpoint or leave any, to show sessions or pages related to all the Watchpoints.
   • In Time Range, provide a time frame.
   • In Records, set the number of records for the system to display.
     The maximum number of records to display is 5000.
   • Using the User ID selector, limit the results to the traffic associated with a specific user, or choose any.
   • Using the Group ID selector, limit the results to the traffic associated with a specific user group, or choose any.

   • In Collector feed name, limit the results to show traffic from one of the Real User Collector components associated with the Real User Analyzer, or choose any.

   • In Page Name, limit the results to a specific page name, or choose any.
   • In Client IP/Block, limit the results to the traffic based on a specific client IP address or IP block. The system supports entering the IPv6 addresses.
   • In Server IP/Block, limit the results to the traffic based on a specific server IP address or IP block. The system supports entering the IPv6 addresses.
   • In URI stem, limit the results based on a a specific URI stem. If you selected
     sessions in the Show selector, this returns sessions where at least on page matches the URI stem that you specify.
   • In Host, limit the results based on a specific host name.
   • In Availability, filter the results by specific error categories and/or the error codes.
     You can select multiple categories and codes.
   • In Info conditions, filter the results by specific informational condition categories and/or the informational codes.
     You can select multiple categories and codes.
   • In Performance, filter the results based on whether a page service-level threshold (SLT) was broken or not.
   • In the Geolocation information section, provide the filtering criteria based on geolocation parameters.
   • In the Session System Custom Fields section, provide the filtering criteria based on the custom fields.
   • In the Session User-defined Custom Fields section, provide the filtering criteria based on the user-defined custom fields.
   • In Metric Filter, apply criteria based on specific traffic metrics, such as host latency > 2000.
   • Select sorting order by a given metric, such as throughput or end-to-end latency in ascending or descending order, The default order is by time, descending.
4. Click Get snapshot.
   
   The Session Browser returns the list of sessions or pages that match your criteria.

Where to go from here

To analyze the query result, proceed with detailed query analysis.

Related topic

Using saved queries