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.
| 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:
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:
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:
|