Horizontal Discovery of MSSql DB On Windows, Skipped file cleaning on target - Known Error

Horizontal Discovery of MSSql DB On Windows, Skipped file cleaning on target Description Horizontal Discovery of MSSql DB On Windows, Skipped file cleaning on target. We are needing to confirm the clean up/removal of the files being left behind on the sql servers. We have completed all the steps needed to keep non SQL servers from having these files left behind during the discovery. We know there's an ongoing problem ( PRB1710898) with the discovery of SQL servers however we want to know best practice to remove the years of stored files on these sql servers.

Steps to Reproduce

Run the discovery on SQL server and you can see the files in %ProgramFiles%\Microsoft SQL Server\ nnn \Setup Bootstrap\Log\

Workaround OPTION1:

To delete any subfolder of a Log folder (regardless of contents), use the following PowerShell command:

✅ PowerShell Command (Delete all subfolders inside Log)

Get-ChildItem -Path "C:\Path\To\Log" -Directory | Remove-Item -Recurse -Force

💡 Breakdown

Get-ChildItem -Directory: Gets all subfolders (not files). Remove-Item -Recurse -Force: Deletes each folder and its contents forcefully.

🧩 If you're building the command in JavaScript:

var cmd = 'powershell -Command "& { ' + 'if (Test-Path \'' + escapedLogFolder + '\') { ' + 'Get-ChildItem -Path \'' + escapedLogFolder + '\' -Directory | Remove-Item -Recurse -Force; ' + 'Write-Output \\\"Deleted all subfolders in: ' + escapedLogFolder + '\\\" ' + '} else { Write-Output \\\"Log folder not found: ' + escapedLogFolder + '\\\" } ' + '}"';

**Replace escapedLogFolder with your full Log folder path (with \\-escaped backslashes).

Let me know if you want to delete just files, just empty folders, or include filtering by name.

4o

OPTION 2:

Command Prompt (cmd.exe) command to delete all subfolders inside a Log directory:

✅ Command Prompt Command

for /d %F in ("C:\Path\To\Log\*") do rd /s /q "%F"

💡 Explanation:

for /d %F in (...): Loops through each subfolder. rd /s /q "%F": /s: Removes all contents in the directory. /q: Quiet mode, no confirmation.

🧩 In JavaScript (for MID Server usage):

var cmd = 'cmd.exe /c "for /d %F in (\'' + log_folder + '\\*\') do rd /s /q \"%F\""';

Make sure log_folder is a properly constructed and escaped path like C:\\Some\\Log\\Path.