Testing custom checkpoint query with sqlserver probe returns 0 rows

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are facing an issue with sqlserver probe, we created one template with some requirements, but it's not working and it's not getting result with correct query. Please find the below snap for reference.

The test query is:

select * from sys.sysprocesses where blocked > 0

Environment

• Release: Any
• Component: sqlserver

Resolution

The specifc SQL query was returning 0 records. In this case If there are no blocked processes, this would be expected behavior.