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

Document ID : KB000044005
Last Modified Date : 07/12/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

 
Environment:
UIM 8.5x
Sqlserver 5.3x
Instructions:
Question: 
What updated Queries are used by the sqlserver Probe?



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