Formulate Queries Using the Oracle Log Analytics UI

You can use the Oracle Log Analytics user interface to formulate your Search query.

By default, the query * | stats count by ‘log source’ is specified in the Search field.

To view data for specific Entities, complete the following steps:

1. Under the heading Entities in the Fields panel, select Entity or Entity Type, depending on how you wish to view the entities. This groups the registered databases on the basis of the selection you have made. For example, if you select Entity Type, then the selected entities are grouped according to their types.

2. Select the Entity or Entity Type for which you wish to view the data.

3. Click Submit.

   The button clear appears next to the entity you have selected, and the data displays in the visualization pane.

To view data for a specific Field, complete the following steps:

1. Select the type of field from the Fields panel, and under Pinned attributes, Interesting bucket, or Other bucket.

2. Select the Label, Log Entity, Log Source, Owner, or Upload Name for which you wish to view the data. You can select more than one Label, Log Entity, Log Source, Owner, or Upload Name.

3. Click Submit.

   Data for the field is loaded in the visualization pane.