Articles in this section

See more
Self help
FAQ
["FAQ"]
["Geneos > Gateway"]

How do I combine data from multiple Netprobes together to create a new combined dataview on a Gateway?

Avatar
Howard Lee
  • Updated
Follow

The Gateway-SQL plug-in has been designed for this purpose. It allows users to create new dataviews using existing dataviews as source.

The Gateway-SQL plug-in has been designed for this purpose. It allows users to create new dataviews using existing dataviews as source.

  • Ability to consolidate dataviews from multiple Netprobes at the Gateway layer.
  • This reduces maintenance time and effort and removes load at the console layer.
  • Easily manipulate data using SQL syntax

There have been various enhancements on the Gateway-SQL plug-in, users are suggested to upgrade the gateway version as appropriate:

  • 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.

Further Reading

Users can check out the Gateway-SQL section in Gateway Reference Guide. The SQL statements are based on SQLite, which is described at https://www.sqlite.org/lang.html.

    Tags:
  • gatewaysql
  • howto

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.