Forum Discussion

Nam_Ngo's avatar
11 years ago

JDBC DataSource Active Discovery SQL Statement Parameters: multiple columns

I\'d like to request a way to more easily select more columns in the JDBC DataSource Active Discovery SQL Statement Parameters and be able to use them.

Somehow, values that come back in the ##WILDVALUE##, we want to be able to have that query come back with different columns that we can use in the actual JDBC query or DataPoint Body Template (however we would use it ##WILDVALUE.COL1## or ##WILDVALUE1## or whatever convention makes sense).

Currently the way we want these WILDVALUE instances is not sufficient for our needs, and we have to set a SQL variable at the top and write really contrived string parsing in the query to get the values we want (and initially writing our Active Directory SQL Statement Parameters query in a way that returns everything in one column delimited by some character).