Internal documentation only
This page has been marked as draft.
Gateway SQL and Rule Query
Context:
Client wants to advise on how to traverse through geneos variables and compare data.
Setup of the client for better analyzation:
Bondscope first isin and benchmarkisin pair is US053373Bj51 and US91282CMN82, then you want that pair be also paired in bbg_benchmark. Then be alerted if those didn’t match.
Workaround:
Comparing two columns using the gateway-sql sampler and created a rule whenever there’s a discrepancy between the two columns on the same row.
For your GatewaySQL the tables should be set as the full path of your table to compare the value of columns against each other.
Next should be your SQL Query which should SELECT the columns FROM the table “comparecolumn”, compare it to each other that outputs 1 when there’s a discrepancy and 0 when there’s none.
Last is the rules. The rules we’ve set are simplified: when the discrepancy flag is set to 0, it sets as ok and if the output is 1, it will send a critical severity.
Output:
