What Queries (updated ) are used by the sqlserver Probe in UIM?
Document ID :
Last Modified Date :
Show Technical Document Details
CA Unified Infrastructure Management
CA Unified Infrastructure Management:Release:8.4
UNIFIED INFRASTRUCTURE MGMT:CAUIM
UIM - SQLSERVER:UIMSQS
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:
What updated Queries are used by the sqlserver Probe?
See attached file containing queries (SqlserverProbeCheckpointQueries.txt)
Supported Versions for sqlserver probe
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.
Was this information helpful?