UIM SQL query to get a list of Monitoring SQL servers targets

book

Article ID: 210504

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

Is there a table in UIM database for all UIM monitored sql server targets?

Environment

Release : 9.2.0, 20.x

Component : UIM - SQLSERVER

Resolution

The below query will return all the data that is related to the sqlserver probe, then you can filter for source, target, or any of the available columns:

select distinct target from s_qos_data where probe = 'sqlserver'