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.
	With the Buttons Save or Save All, the results of the selected class or the results of all inventory classes can be stored1 in the WMI repository.
	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