strings in Data source/data point?

You'll have to switch to scripted collection, still using JDBC. Then you can enumerate the possible values of Status and convert to a number that can be stored in the datapoint. Example script here: https://github.com/sweenig/monitoring-recipes/tree/master/DataSources/Groovy/JDBC

1 hour ago, Stuart Weenig said:

You'll have to switch to scripted collection, still using JDBC. Then you can enumerate the possible values of Status and convert to a number that can be stored in the datapoint. Example script here: https://github.com/sweenig/monitoring-recipes/tree/master/DataSources/Groovy/JDBC

And just imagine if LM added per-DP enum support so this wasn't all such a hack.

5 hours ago, mnagel said:

And just imagine if LM added per-DP enum support so this wasn't all such a hack.

Going on my list of FRs now.

At the top of the linked page is this link to an example groovy script for MS SQL: https://github.com/sweenig/monitoring-recipes/blob/master/DataSources/Groovy/JDBC/Groovy_JDBC_MSSQL.groovy.

Line 38 has your SQL query, and lines 39-43 are where you'd have to write code to output the numbers based on the text values.

17 hours ago, Stuart Weenig said:

At the top of the linked page is this link to an example groovy script for MS SQL: https://github.com/sweenig/monitoring-recipes/blob/master/DataSources/Groovy/JDBC/Groovy_JDBC_MSSQL.groovy.

Line 38 has your SQL query, and lines 39-43 are where you'd have to write code to output the numbers based on the text values.

OMG, I really did not see that ?

Thanks Stuart. 

19 hours ago, Stuart Weenig said:

You'll have to switch to scripted collection, still using JDBC. Then you can enumerate the possible values of Status and convert to a number that can be stored in the datapoint. Example script here: https://github.com/sweenig/monitoring-recipes/tree/master/DataSources/Groovy/JDBC

Hi, 

Thanks for the link.  

Unless I am missing something I'm not seeing any example scripts on that link though.  This one shows how to setup the JDBC connector, which we 

already have, though not being an admin I cannot modify. 

Is the scripted collection you mention Groovy or Powershell?  We have some of these already working - setup by LM professional services, they seem to generate 

boilerplate Groovy code. 

Thanks