Example Filtering for Average JVM Memory for Current Week

You want to show a table of all the TIBCO ActiveMatrix nodes in an enterprise, where their average JVM memory values are aggregated at the week level for this week.

The days values are queried with the TIBCO StreamBase function isnull() so that only the week level rows appear in the result. To filter the data only for the current week, the TIBCO StreamBase functions now() and days(7) are used. This way, the filtered rows with the week value between now and 7 days ago appears in the result.

Procedure

  1. Click the Edit Query button in the top corner.

    The Edit Query dialog opens.

  2. Specify the Select clause as: 
    node, host, environment, AvgJVMUsedMemory, AvgJVMTotalMemory
  3. Specify the Query (where) clause as: 
    isnull(days) AND weeks < now() AND weeks > (now() - days(7))
Contents
Search Results