SQL Server
This inventory class displays information about the different SQL server instances. It detects SQL Server (Express) Editions from 2008 - 2017.
First, select the inventory class SQL Server in the area of System Information on the left side. All reported values will be displayed.
The following table describes the individual controls of the main menu and their functions.
Within the Skin Gallery, different skins and color palettes can be selected to adjust the look and feel to your preferences. The corresponding controls are located in the header section of the application at the top left.
The Button Settings opens the configuration settings.
Create Package Source copies the files that are needed when using PC-SysInfo in connection with a systems management environment. For example, those provided files can be used to create a package. This option is only available while holding a valid license.
With the drop-down list different SQL Server instances can be selected.
The Reload button refreshes the SQL Server list.
Magnifier displays a magnifying glass that can be used to zoom in on any portion of the screen.
About displays further information about PC-SysInfo.
Switching inventory classes on and off, as well as customizing the name space and the WMI class, is described in the chapter configuration.
The following table describes the properties of the inventory class SQL Server.
| Name | Type | Key | Array | Description |
|---|---|---|---|---|
| Architecture | String | The architecture | ||
| BinRoot | String | The binary root directory | ||
| Collation | String | The collation | ||
| DataRoot | String | The data directory | ||
| Edition | String | The edition | ||
| IsExpressEdition | Boolean | Indicates if it is a SQL Server Express Edition. | ||
| Language | String | The language | ||
| LanguageCode | SInt32 | The language code | ||
| PatchLevel | String | The patch level | ||
| ProductCode | String | The product code | ||
| ProductID | String | The product ID | ||
| ProductKeyNumber | String | The product key number | ||
| ProgramDir | String | The program directory | ||
| ServicePack | SInt32 | The service pack | ||
| SqlInstance | String | The instance name | ||
| Type | String | The SQL server type | ||
| Version | String | The version |