Have you ever encountered a need to find and/or validate the SQL Server features and their respective patch levels for any given server running a single or multiple SQL Server instance(s)? If so, the Installed SQL Server Feature Discovery Report generation utility is just the tool you are looking for.
Today’s post show you how to use this small utility for your documentation/inventory purposes.
| Launch the SQL Server 2012 installer by clicking on the SQL Server Installation Center [You can also run the installer from the setup disc] |
 |
| Under “Tools”, you will find the “option to launch the “Installed SQL Server Features Discovery Report” |
 |
| Clicking on the tool starts the processing and you will be presented with the progress dialog, standard to all progress operations of the SQL Server 2012 installer. |
 |
| Once execution is complete, the report will be opened automatically in Internet Explorer |
 |
If you need to send this report over to your IT team or preserve it for documentation purposes, you can find a copy at:
Path for Discovery Report file: <<SQL Server installation path>>Setup BootstrapLog<<Date time>>SqlDiscoveryReport.htm
Example: C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20130407_103300SqlDiscoveryReport.htm
I trust this quick post will be helpful to you in the future.
Until we meet next time,
Be courteous. Drive responsibly.
SQLTwins by Nakul Vachhrajani 