Microsoft SQL Server - Change History

2008

TKU September 2008

Enhanced the pattern to recognize additional build numbers of the product.

TKU November 2008

Updated the pattern to perform versioning by WMI Query in preference to Registry Query. If the WMI Query succeeds, the full_version is reflected for all hotfixes applied.

TKU December 2008

The following improvements were made:

• Updated the pattern to obtain listening port information and the list of databases managed by the SQL Server instance.
• Updated the pattern to create instance-based SIs in preference to group-based SIs.

2009

TKU December 2009

Updated the pattern to ensure that additional attributes are displayed in the UI only when their values are populated.

2010

TKU January 2010

The following improvements were made:

• Improved the WMI Query versioning method.
• Improved versioning to remove trailing zeros from the bottom of the extracted version.
• Simplified the mapping table to accomodate the trailing zeros removal.

TKU June 2010

The following improvements were made:

• Updated the pattern to always set the port attribute to string.
• Added extra SQL Server versions to the product version mapping table.

TKU July 2010

Added extra registry keys for version checking.

TKU September 2010

Updated the pattern to check for existing registry keys only.

TKU October 2010

Added extra registry keys to support the edition and backup directory information for Microsoft SQL Server 2008 R2.

2011

TKU January 2011

The following improvements were made:

• Improved obtaining information from the MS SQL Server 2008 R2.
• Updated mapping of the full version to the product version. This update eliminates the need to frequently update version mapping tables.
• Updated the pattern to determine if the DB server is listening on a specific IP address and stores this information as a bind_address SI attribute. The IP address information can be used by the Deep DB discovery patterns to query the database server by using an IP scan.

TKU March 2011

Enhanced the pattern to determine whether the discovered SQL Server is located within an SQL Server cluster. If so, the pattern attempts to determine the cluster IP address that the SQL server is listening on. The IP address information can be used by the Deep DB discovery patterns to query the database server by using an IP scan.

TKU May 2011

Added an extra method to determine whether the discovered SQL Server is located within an SQL Server cluster.

TKU October 2011

The following improvements were made:

• Moved all the creation code for DatabaseDetail nodes to the extended pattern. If the extended pattern is unable to obtain a list of databases from a JDBC database query, the extended pattern attempts to obtain this list from a directory listing or command.
• Added an ability to obtain the path to the data directory from the registry.

TKU November 2011

The following improvements were made:

• Added an explicit database query to obtain the list of databases to support Microsoft SQL Server 2000.
• Added an ability to obtain the list of databases through a WMI Query.
• Changed the priority of the file-based method for obtaining the list of databases to the fourth last.
• Added a port_list attribute to store multiple listening ports.

2012

TKU February 2012

Added support for obtaining the listening IP address when SQL Server 2000 is part of a cluster.

TKU March 2012

The following improvements were made:

• Updated the deep discovery pattern module to prevent adding a null DatabaseDetail node to the db_details list.
• WMI queries partially handle named instances and searches for PerfFormattedData and PerfRawData.
• Updated the pattern to correctly handle database filenames that contain a '$'.

TKU May 2012

Updated the pattern to ensure that SI attribute values are consistent with those of other discovered Microsoft products. The content of the SI name attribute includes SP information if present.

TKU June 2012

Improved CMDB mapping by adding the product SI attribute that includes type and edition.

TKU July 2012

The following improvements were made:

• Updated the file-based database discovery method in the extended pattern to create Detail nodes instead of DatabaseDetail nodes.
• Added a configuration option to enable file-based database discovery (disabled by default).
• Added support for the IPAddress node.

TKU October 2012

The following improvements were made:

• Added a method to obtain the binding address for clustered instances.
• Optimized the trigger process containing a '~'  by using a common function.
• In the extended pattern module, updated the  SELECT name AS database_name FROM sys.sysdatabases SQL query to support both case-insensitive and case-sensitive setups when obtaining a database list.

TKU November 2012

Resolved an issue to prevent an ECA error (QM001773290).

TKU December 2012

The following improvements were made:

• Added a cluster_name attribute for SQL servers that are in a cluster (QM001774745).
• Updated the pattern to ensure correct mapping of certain attributes to BMC CMDB.

2013

TKU May 2013

The following improvements were made:

• Improved identification of SQL Server 2012.
• Added registry queries to obtain edition information when discovering SQL Server 2012.
• Updated the product version mapping tables.

2014

TKU May 2014

Fixed an ECA error caused by the missing cmdline attribute in the DiscoveredService node.

TKU June 2014

Improved handling of special characters (_, $) within the server name in the WMI query call.

TKU April 2014

Improved registry key parsing for port extraction.

TKU August 2014

The following improvements were made:

• Added an alternative method of handling database sizes to correctly identify all possible values.
• Added extra version pairs to the Microsoft SQL Server version mapping table.

TKU September 2014

The following improvements were made:

• Improved the discovery of Microsoft SQL Server 2000 Edition. 
• Added an alternative database query versioning method.
• Added the short_name and listening_port attributes.
• Improved the versions table (QM001857216). 

2015

TKU April 2015

The following improvements were made:

• Updated the pattern to extract the database detail information for Microsoft SQL Server 2012 correctly (QM001878047).
• Updated the pattern to prevent an ECA error (QM001877183).

TKU May 2015

Updated the pattern to retrieve database size when it exceeds 2,147,483,647 KB (QM001879574).

TKU August 2015

Resolved an issue with MS SQL Database Discovery Failing (QM001884046).

TKU September 2015

Fixed an issue related to the database query calls sent to remote hosts.

TKU October 2015

Added an alternative approach to obtain the db_list (QM001887767 and QM001887528).

TKU November 2015

Improvement to the TKU September 2015 issue fix related to the database query calls sent to remote hosts.

2016

TKU Feburary 2016

Updated the pattern to explicitly show databases contanining an edition of Windows Internal Database.

TKU March 2016

The following improvements were made:

• Updated the pattern to check port as a string value before converting to an integer.
• Updated the release mapping tables.

TKU April 2016

The following improvements were made:

• Updated the regular expression used to obtain the instance name.
• Updated the release mapping tables.

TKU May 2016

The following improvements were made:

• Imoroved the code used to obtain the cluster name.
• Improved the method of discovering the Host node if a cluster name is unknown.

TKU October 2016

Improved the code to obtain cluster and port information.

TKU November 2016

Updated the pattern to collect data for databases with the autoclose option enabled (DRDC1-7263).

TKU December 2016

Added extra version pairs to the Microsoft SQL Server version mapping table.

2017

TKU January 2017

The following improvements were made:

• Updated the mechanism of port obtaining: if the registry query has more than one port, each port will be checked for active listening.
• Updated the cluster model: the pattern models an SQL Server SI as running under a cluster only when the cluster node has the correct ClusterService.
• Enabled mapping of the internal version to the product version.

TKU March and April 2017

Improved WMI versioning: the pattern adds mapping from the build number that WMI gives to the internal version number.

TKU May and June 2017

The following improvements were made:

• Improved mapping of the internal version to the product version.
• Improved the cluster model.

TKU September 2017

The following improvements were made:

• Improved the key of the Software Instance.  
• Minor fix to the way of obtaining version information from database queries. 
• Replaced the hosting_node identification code with the cluster_support_functions.getHostingNode() function that contains the MSCluster-specific rules (DRDC1-9440 and DRDC1-9432).

TKU October 2017

The following improvements were made:

• Added an improved method to find the data_directory.
• Added an improved method to find the path to the ERRORLOG file.

2018

TKU January 2018

The following improvements were made:

• Resolved an issue related to the way in which the pattern finds the path to the ERRORLOG file.
• Removed the incorrect registry key for the MSSQL cluster name extraction.

TKU July 2018

Added details of package versioning.

TKU August 2019

Updated versioning: the pattern runs a database query first; other methods are attempted only if the database query fails.

TKU October 2018

Improved mapping of the internal version to the product version.

TKU November 2018

Improved the way in which the pattern obtains attributes from registry keys.  

2019

TKU April 2019

Updated the pattern to use runCommand functions.

TKU August 2019

Updated versioning: the pattern runs a database query first; other methods are attempted only if the database query fails.

TKU September 2019

Resolved an issue with the trigger on Linux.

TKU November 2019

Resolved an issue with WMI versioning.

TKU December 2019

The following improvements were made:

• Updated the pattern to cease the creation of the service_pack attribute on Software Instances where no service_pack exists.
• Updated the pattern to create a SoftwareService link from the SI to the relevant ClusterService, if applicable.

2020

TKU January 2020

Updated the pattern to report the license key.

TKU March 2020

Improved reporting of the Software Instance name.

TKU April 2020

The following improvements were made:

• Changed parsing of the version obtained through WMI versioning.
• Added the creation_date attribute to the Software Instance on Windows to improve licensing queries.

TKU June 2020

Improved the query used to find the creation_date attribute.

TKU August 2020

Removed support for multi-instance installations on Linux.

TKU October 2020

The following improvements were made:

• Updated the pattern to report "" as bind_address whenever there is 0.0.0.0 as the bind address in the Linux configuration file. 
• Improved mapping of the internal version to the product version.

2021

TKU May 2021

The clustered MS SQL SoftwareInstance is hosted on the Microsoft Failover Group Cluster (if available). SI key and name remain unchanged and are taken from the main Microsoft Cluster node.

TKU October 2021

Updated linking to Citrix XenApp.

TKU December 2021

The following improvements were made:

• Improved instance finding on Windows.
• Implemented the functionality for pattern configuration support (DRDC1-17603).

2022

TKU June 2022

Resolved an issue regarding version mappings for SQL Server 2000.

TKU September 2022

Improved the model where the trigger process has an -S argument (the template name) and an -s argument (the public servername) simultaneously.

TKU December 2022

Updated how the pattern identifies Microsoft SQL Server as standalone or clustered.

2023

TKU February 2023

The following improvements were made:

• Improved versioning.
• Added support for modeling ClusterServices and ClusterResources when WMI queries miss the __RELPATH attribute.
• Added code that improves WMI queries (missing attributes, unexpected values, etc).

TKU June 2023

Updated package versioning.

TKU April 2023

Updated WMI versioning.

TKU August 2023

Added an extra method to find the creation date. The pattern searches a file if the database query fails.

2024

TKU March 2024

Improved pattern versioning by updating registry key checks.

TKU August 2024

Updated the pattern to model Windows Internal Database as a separate SoftwareInstance type.