2017

TKU February 2017

In TKU February 2017 we added details of Availability Groups

TKU April 2017

In TKU April 2017 we made two updates:

• We improved the database query used to obtain information about Availability Groups.  This new query should work in more situations
• We did a slight update to the (optional) method to obtain database information via file based discovery.  All DatabaseDetail nodes now have the same key regardless of provenance

TKU May 2017

In TKU May 2017 we improved the additional methods to find databases.  We will now try them even if the main method (using database queries) has succeeded.

TKU October 2017

From TKU October 2017 we discover databases by parsing the ERRORLOG file, but only if the relevant configuration option is enabled.
Compatibility level is now reported for databases.

TKU November 2017

In TKU November 2017 we improved discovery of databases via directory listing.  We still run the procedure if the relevant configuration option is enabled, but now if we subsequently find a database with the same physical name (most probably via a SQL query) we will update the discovered instance name.

(We needed to slightly update the database queries to ensure we get physical name information.  We can usually get database_size from these queries and don't need to run separate queries.  This means we have removed the get_database_size configuration option.  If you are still experiencing difficulties getting database_size please enable the get_db_individ configuration option, but this will increase discovery time)

2018

TKU January 2018

In TKU January 2018 we added validity checking for databases.

AvailabilityGroup pattern update includes:

- databases in availability group are linked to related ClusterService only. (DRDC1-10025)
- updated code for sql queries to avoid integration errors
- enhanced approach for search of replica databases
- added always_on_availability_group, always_on_availability_group_role attributes for database
- group_id attribute is removed because it is used for internal purposes only

TKU February 2018

In TKU February 2018 we made the following changes:

• A small update to how we parse the ERRORLOG files for database details.  This procedure should now work better if there are non utf-8 character in the ERRORLOG file
• A small update to how we search the data directory for database details.  We now search all subdirectories of the database directory

Note that both of these features will only work if the relevant configuration option is enabled

TKU March 2018

In TKU March 2018 we improved the substitutions we use to ensure WMI queries work successfully

TKU April 2018

In TKU April 2018 we updated the validity check to allow database names with hyphens

TKU July 2018

In TKU July 2018 we removed validity checking.  We now have better ways of parsing osql.exe

TKU August 2018

In TKU August 2018 we updated the osql command.  It now handles long database names much better

TKU September 2018

In TKU September 2018 we did a major update to the SQL queries we use to obtain information on Database nodes such as name, compatibility, size, and physical name

2019

TKU May 2019

In TKU May 2019 there was a minor bug fix

TKU September 2019

In TKU September 2019 there was a minor fix to how we parse the output of osql.exe

2020

TKU March 2020

In TKU March 2020 there was a bug fix in the query we use for SQL Server 2000 to get a list of managed databases

TKU October 2020

In TKU October 2020 the following changes were made:

•  Added Availability Group listener_ips attribute to related ClusterService node. (DRDC1-15418)