Discovery's MSSql DB On Windows Pattern creates SQL Discovery reports and is not deleting them afterwards - Known Error

Discovery's MSSql DB On Windows Pattern creates SQL Discovery reports and is not deleting them afterwards Description When discovery runs the following step/command in the MSSql DB On Windows pattern,...

generate MSSQL Discovery Report 2023-10-11 05:48:11: Executing WMI command on host: xx.xx.xx.xxx, command: "C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019\setup.exe" /Action=RunDiscovery /q ...it creates a report (including folders and files) to check the validity of the SQL Server installation. This is further explained on the documentation page from Microsoft: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/validate-a-sql-server-installation?view=sql-server-ver16

The discovery report that is generated from the command is saved under: %ProgramFiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\ .

Discovery is not removing these files/directories and leaving them behind on the host. We should clean up after ourselves.

Steps to Reproduce

Run Discovery that runs MSSql DB On Windows Pattern Let it run and complete Review the discovery pattern log - find entry such as below:

generate MSSQL Discovery Report 2023-10-11 05:48:11: Executing WMI command on host: xx.xx.xx.xxx, command: "C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\SQL2019\setup.exe" /Action=RunDiscovery /q Actual behaviour: Files are left behind on the host in the following directory %ProgramFiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\ .

Expected behaviour: Files are deleted that were created by Discovery from the the following directory: %ProgramFiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\ .

Workaround This problem is currently under review and targeted to be fixed in a future release. Subscribe to this Known Error article to receive notifications when more information will be available.