Query does not appear in the co-relation alert definition

If the query does not appear in the co-relation alert definition, check the count field and sort by time stamp.

Symptoms

You created an access query for creating a co-relation alert. However, in the co-relation alert definition, this query does not appear in the drop-down list.

Causes

The co-relation alert search in the report is based on the time stamp.

Environment

The collector and aggregator are affected.

Resolving the problem

Mark the Add Count check box and sort by time stamp.