MS SQL Server data properties

The MS SQL Server data properties check MS SQL Server prerequisites, such as the version and location. For Windows systems only, it uses the MS SQL Server collectors in the ips_root/Windows directory, with the mssql prefix in their file names.

Table 1 outlines the MS SQL Server prerequisite properties. This category of prerequisite properties requires the mssql prefix identifier.
Table 1. MS SQL Server data properties
Prerequisite property Platform Description Valid values
mssql.Client Windows Checks the version of MS SQL client that is installed on the machine Expected string value can be multiple versions, which are separated by a comma, for example:
10.50.1600.1
Note: The values can use the special characters as outlined in Table 1.
mssql.Server Windows Checks the version of MS SQL Server that is installed on the machine Expected string value can be multiple versions, which are separated by a comma, for example:
10.50.1600.1
Note: The values can use the special characters as outlined in Table 1.
mssql.Server.Location Windows Checks the home directory of the MS SQL database server String, for example:
any