What Queries (updated ) are used by the sqlserver Probe in UIM?

Document ID : KB000044005
Last Modified Date : 24/08/2018
Show Technical Document Details
Introduction:
Queries used by sqlserver probe are provided in this kb article. Running these queries requires sufficient permissions being granted to the user used in sqlserver probe. This is described in UIM probe document: Access Prerequisites

 
Instructions:
Question: 
What updated Queries are used by the sqlserver Probe?

Environment:  
UIM 8.4
Sqlserver 5.10

Answer: 
See attached file containing queries (SqlserverProbeCheckpointQueries.txt)

Additional Information:
The sqlserver probe will run selected SQL's to extract vital information about your SQL Servers.
File Attachments:
TEC1539335.zip