Back to Geneos FAQ

Gateway SQL – Example Use case to extract last line of a dataview

GatewaySQL, How to extract value from new updated rows on a dataview

Problem Copied

How can I extract the last row from a DataView that keeps appending new rows?

Solution Copied

You can extract the last row of your Dataview by using the Gateway-SQL plug-in to create a new, separate view.

Using this toolkit as an example:

Geneos – Gateway SQL – Example Use case to extract last line of a dataview.

We’ll utilize the id(rowID) to extract the maximum value found and display it as a different dataview.

To do this, go to your Gateway-SQL and add the XPATH of the dataview you want to extract

Geneos – Gateway SQL – Example Use case to extract last line of a dataview.

Name your new data view and add the needed SQL parameters:

Geneos – Gateway SQL – Example Use case to extract last line of a dataview.

Once applied, you should then see this on your dataview:

Geneos – Gateway SQL – Example Use case to extract last line of a dataview.

To test this, we’ve added a new row:

Geneos – Gateway SQL – Example Use case to extract last line of a dataview.

You should then see your GatewaySQL picking up the last row from the target dataview:

Geneos – Gateway SQL – Example Use case to extract last line of a dataview.

["Geneos"] ["Geneos > Netprobe"] ["FAQ"]

Was this topic helpful?