strings in Data source/data point?

Question

Hello

We have some data that is held in a SQL server database table that we would like to use in a dashboard.&nbsp; Ideally the same&nbsp;

data set would populate a pie chart and a small table.&nbsp; e.g.&nbsp;

We have a data source using a JDBC connection over to the SQL server and that all works, problem is that the data point does not work with&nbsp;

strings (in this case status).&nbsp; &nbsp;&nbsp;

So my question is, how can I pull all seven columns in this data set to show in my dashboard?&nbsp; &nbsp;Is there a way of doing this or&nbsp;

is NAN (not a number) an insurmountable block?&nbsp;

The data source is as follows:&nbsp;

&nbsp;&nbsp;

&nbsp;

The error message is NAN (not a number)&nbsp;

anonymous · Answer

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:&nbsp;https://github.com/sweenig/monitoring-recipes/tree/master/DataSources/Groovy/JDBC

mnagel · Answer

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:&nbsp;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.

anonymous · Answer

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.

anonymous · Answer

At the top of the linked page is this link to an example groovy script for MS SQL:&nbsp;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.

david_gray · Answer

17 hours ago, Stuart Weenig said:

At the top of the linked page is this link to an example groovy script for MS SQL:&nbsp;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.

&nbsp;

OMG, I really did not see that&nbsp;?

Thanks Stuart.&nbsp;

Forum Discussion

strings in Data source/data point?

Related Content

Update Multiple Global Data Source's Data Points

Does cloud watch API calls bound to Data Sources or Data points?

string filters in the API (groovy)

"Operation not supported" when adding a data source.

Data Source Consolidation and Transition Strategy

Recent Discussions

Devops metrics monitoring in Lm

LM APM - Traces - HTTP Post from Powershell Scripts

SNMP Traps - Baseline for alerting

Module Toolbox AppliesTo IDE

Can someone explain the CPU 5 minute load average thing to me?