No Return of Colums with System!System.OleDbProbe

Question

Hello!

I have a monitor for requesting a Database. The request is running without error. But I don’t get the colums.

The Query is:

SELECT Product, Mandator, State, Description FROM [xxx].[dbo].[xxx] WITH (NOLOCK) WHERE Product= '$Config/Product$' AND Mandator = '$Config/Mandator$'

Result of Data:

<DataItem type="DatabaseResultSet" time="2024-03-01T07:20:01.1085651Z" sourceHealthServiceId="d6192751-74d3-b8ae-610d-af830314c502">

<DataItem type="System.OleDbData" time="2024-03-01T08:20:01.1085651+01:00" sourceHealthServiceId="D6192751-74D3-B8AE-610D-AF830314C502">

<HRResult>0</HRResult>

<ResultLength>8</ResultLength>

<Result>Success</Result>

<InitializationTime>44</InitializationTime>

<OpenTime>0</OpenTime>

<ExecutionTime>1045</ExecutionTime>

<FetchTime>1</FetchTime>

<RowLength>0</RowLength>

<OriginalDataLength>0</OriginalDataLength>

<ErrorDescriptionLength>0</ErrorDescriptionLength>

<ResultCode>0</ResultCode>

</DataItem>

</DataItem>

RowLength is 0 but it should be 4 and i should see the 4 colums.

My Config is:

<ProbeAction ID="Probe" TypeID="System!System.OleDbProbe">

<ConnectionString>$Config/ConnectionString$</ConnectionString>

<Query>$Config/SQLQuery$</Query>

<GetValue>true</GetValue>

<IncludeOriginalItem>false</IncludeOriginalItem>

<OneRowPerItem>true</OneRowPerItem>

<QueryTimeout>30</QueryTimeout>

<GetFetchTime>true</GetFetchTime>

</ProbeAction>

What do I have forgotten?

rg

Hansi

Answer 1

Hi,

This link contains relevant information for your reference.

Query a database without scripting as part of SCOM monitoring – The System.OLEDBProbe module