Back to Geneos FAQ

Internal documentation only

This page has been marked as draft.

GatewaySQL - Filtering out a result with a time greater than X min

Problem: How to filter out and combine Dataviews with a time greater than X mins.

Solution: This can be achieved through our GatewaySQL plugin. Here is a case wherein the time results are greater than 5 mins and less than 5 mins.

As an example, we wanted to filter out the Dataview that exceeds 5 mins.

To filter this out, we have used the Gateway-SQL sampler to remove the Dataview wih a time of less than 5 mins. Our SQL query should be something like (refer to the sample below):

SELECT * FROM time WHERE time >‘00:05:00’; Copied

Geneos - GatewaySQL - Filtering out a result with a time greater than X min. Adding this should give you a results like this: Copied

XML used:

time\_sql /geneos/gateway[(@name="Primary Gateway")]/directory/probe[(@name="1\_probe")]/managedEntity[(@name="TESTS")]/sampler[(@name="toolkit-time")][(@type="")]/dataview[(@name="toolkit-time")] time REAL name TEXT value REAL time SELECT \* FROM time WHERE time > '00:05:00';