Articles in this section

See more
Self help
How To
["How To"]
["Geneos > Gateway"]

Geneos - How to combine data from multiple Netprobes to create a new dataview

Avatar
ITRS Support
  • Updated
Follow

Users can consider using the Gateway-SQL plug-in. It allows users to create new dataviews using existing dataviews as source.

The Gateway-SQL plug-in is part of the Compute Engine functionality of the gateway. It provides a way to summarise and reformat dataviews rather than to monitor the gateway. It uses an in-memory SQLite database to take data from multiple dataviews and combine them to provide a set of new dataviews.

A user can configure the plugin to take data from a pair of specified dataviews and combine them using a key column in each dataview. More complex SQL is available including OUTER JOINS, LEFT JOINS, GROUP BY.

The Gateway-SQL plugin had been available since version GA3.0.15. We suggest users to use current gateway versions to take advantage of various enhancements and fixes:

  • GA3.0.15 (GWX-1949): initial release of Gateway-SQL plug-in
  • GA3.1.0 (GWX-2535): added ability to reference headline variables from a dataview
  • GA3.4.0 (GWX-2695): added XPath selector that can dynamically allow multiple dataviews to populate a single table.
  • GA4.4.0 (AA-1051): expect rows can now be defined on individual dataviews for Gateway plug-ins
  • GA4.10.0 (AA-2244): improves the error reporting in Gateway-SQL plug-in

Further Reading

Users can check out the Gateway-SQL section in Gateway Plug-Ins documentation.

Related articles

Comments

2 comments

Sort by Date Votes
  • Avatar
    justin.rubio

    Can you also combine dataviews imported from multiple gateways?

    0
    Comment actions Permalink
  • Avatar
    Chun Lee

    Justin,

    You can combine dataviews imported from multiple gateways in the same way

    0
    Comment actions Permalink

Please sign in to leave a comment.