To resolve this, you would need to adjust the sql select you are using to pull back the values. In the example, the customer used a wildcard select to get all fields, such as this:
select * from CERTIFICATE_DATA
To force the probe to recognize the correct data type, you need to adjust the select as per the example below:
select
CertificateName,
ExpiryDate,
CurrentDate,
ISNULL(DAYS_45, 0 ) as DAYS45 ,
ISNULL(DAYS_30, 0 ) DAYS30,
ISNULL(DAYS_15, 0 ) DAYS15,
FILE_NAME
from CERTIFICATE_DATA
This then allowed the probe to pull back the correct data type (numeric) for the INT columns of the table.
