7.3 Offline Query

Offline Query is most often used to run queries against large amounts of data. Offline Query will continue to run even after the user logs out of the Sentinel Control Center, if necessary.

NOTE:You can view the result of your query only after it is completely processed.

After the query has completely finished processing, the results are available to the user who initiated the Offline Query and other Sentinel users with the same security filter. When you attempt to browse or save the result as HTML or CSV, the data is transferred from the server to the local machine running the Sentinel Control Center.

NOTE:For performance reasons, the result set for Offline Query is limited to 100,000 records. For better results, you must specify a better filter or a smaller time range when creating an Offline Query.

7.3.1 Creating an Offline Query

To create an Offline Query:

  1. Click Analysis on the Menu Bar. The Offline Query window displays. Alternatively, you can click Offline Query button on the Tool Bar.

  2. In the Offline Query window, Click Add button located on the top left corner of the screen. The Add Offline Query window displays.

  3. Provide a Query Name. Select an existing filter to be used for generation of offline query. For more information on the selection and creation of filters see Section 2.0, Active Views Tab.

  4. Select the Start Date and End Date for which you want to generate an offline query.

  5. Specify the description in the Description Tab.

  6. Click OK. The Offline Query gets listed in the Offline Query window.

7.3.2 Viewing, Exporting or Deleting an Offline Query

To view, export or delete an Offline Query:

  1. Click Analysis on the Menu Bar. The Offline Query window displays. Alternatively, you can click Offline Query button on the Tool Bar.

  2. In the Offline Query window, select an offline query. The following options are available:

    • Browse: Click Browse to view the output of the Offline Query in the Active Browser window.

    • CSV: Click CSV to generate a Comma Separated Value file with the queried information.

    • HTML: Click HTML to generate an HTML file with the queried information.

    • Delete: Click Delete to delete the Offline Query. Confirmation message alert displays. Click Yes to delete.

    • Details: Click Details to view the details of the Offline Query as specified when adding the Query.