SQL Server Discovery Report

Published: 29 May 2020
on channel: Decode ITES
634
6

#DecodeITeS

SQL Server Discovery Report

SQL Server setup comes up with the option of the SQL Server Discovery Report to validate the features of SQL Server installed with the version details. SQL Server Discovery report can find and report all SQL Server features and versions from SQL Server 2000 to SQL Server 2019.
You can execute a discovery report from the SQL Server installation center or directly calling setup.exe from the command line.
For each execution of the SQL Server Discovery report, report saved to %ProgramFiles%\Microsoft SQL Server\nnn\Setup Bootstrap\Log\last Setup Session.

Run SQL Server Discovery Report from Installation Center

Step 1: Open Installation Center
Step 2: Installation Center Window
Step 3: Go to Tools , Click on “Installed SQL Server features discovery report”

Run SQL Server Discovery Report from Command line (CMD)

Step 1: Open CMD and Browse to location of SQL Server Setup

Step 2: Run Command “Setup.exe /q /Action=RunDiscovery”. /q is for silent execution in background.


Where Discovery Report saved?

As Mentioned before, SQL Server feature discovery report can be found in setup logs. %ProgramFiles%\MicrosoftSQL Server\nnn\Setup Bootstrap\Log\last Setup Session.


Watch video SQL Server Discovery Report online without registration, duration hours minute second in high quality. This video was added by user Decode ITES 29 May 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 634 once and liked it 6 people.