How to combine data from multiple Netprobes to create a new dataview
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. It is recommended to use current gateway versions to take advantage of various enhancements and fixes.
Further Reading Users can check out the Gateway-SQL section in Gateway Plug-Ins documentation.