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

Document ID : KB000044005
Last Modified Date : 01/02/2019
Show Technical Document Details
Question:

What updated Queries are used by the sqlserver Probe?

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

 
Environment:
UIM 8.5x
Sqlserver 5.3x
Answer:
See attached file containing queries (SqlserverProbeCheckpointQueries.txt)

 
Additional Information:

Supported Versions for sqlserver probe 

https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-sql-server-monitoring-release-notes#sqlserver(SQLServerMonitoring)ReleaseNotes-SupportedVersions

https://buildnumbers.wordpress.com/sqlserver/

https://stackoverflow.com/questions/18753886/sql-server-file-names-vs-versions 

From the KB (it also has sql queries for older versions) 
If SQL Sever is greater then or equal to 2005 i.e 9.00.xxxx then, MSSql90[] or MSSql90NoLock[] will be used. 
If SQL Sever is equal to 2000 i.e 8.00.xxxx, then MSSql80[] or MSSql80NoLock[] will be used. 
File Attachments:
TEC1539335.zip