Why ! unable to convert query result for SQL: select SERVERPROPERTY ('productversion')

Question

, unable to convert query result
My environment:  Orion Core 2011.2.0, APM 4.2.0, IPSLAMGR 3.5.1, NCM 6.0, NPM 10.2, NTA 3.7, SEUM 1.0.0, IVIM 1.2.0

My want
eed:   To display the version of SQL using APM

I tried using the "SQL Server User Experience Monitor"

I used the following:

Instance: Inst1  (Custom named instance)

Catalog:  master

SQL Query:

use master

select SERVERPROPERTY ('productversion')

Result in SolarWinds when I choose the Test button:  unable to convert query result

Result in SQL Query window: 10.50.1720.0

I've tried different configuration such as converting the query results in the "SQL Server User Experience Monitor", with no success.

Petr.Vilem · Answer

First value needs to be convertible to decimal number because all following operations like "count as difference", "convert using custom formula", "compare to thresholds", "display in graph" are expecting number as input value and cannot work with text.

Both outputs are then visible in component detail resource:

If you convert version string to decimal number as netlogix suggests, it can get rounded in UI as you can see on this screenshot.

netlogix · Answer

How about this?

select left(convert(varchar(20),SERVERPROPERTY('productversion')),PATINDEX('%.%',convert(varchar(20),SERVERPROPERTY('productversion'))))+REPLACE(right(convert(varchar(20),SERVERPROPERTY('productversion')),len(convert(varchar(20),SERVERPROPERTY('productversion')))-PATINDEX('%.%',convert(varchar(20),SERVERPROPERTY('productversion')))),'.',''),SERVERPROPERTY('productversion')

NspSysOps · Answer

Thanks for trying to assist Petr.

Your script on SQL gives:

no column name           no column name

0                           10.50.1720.0

Which in SolarWinds will then show "0", which is not the desired end result, or answer to my question.

*  From what I can tell by the custom 'convert query' commands..I'm wondering if SolarWinds doesnt support multiple decimal places in an returned value?

Still looking for a way to show a returned attribute (having multiple decimal places) can be shown in SolarWinds.  I believe SolarWinds can't return 'text' from a query, is that correct? If so then since a true numerical value can have multiple decimal places, then perhaps SolarWinds cannot display it?