how to list all features installed in a sql server instance?

Question

There are other Installation related questions with similar details here and here.

I could not find anything related to listing the installed features in sql server 2016 though.

I can do it manually looking at the logs - as per the info below, but I would like to automate it.

After installing SQL Server 2016 I get a log file - located somewhere in these folders:

C:\Program Files\Microsoft SQL Server130円\Setup Bootstrap\Log20200109円_205540

enter image description here

A file which the name starts with Summary_ +my_server_name

in that file, amongst other things I can find a list of the Sql Server Features installed: enter image description here

After installation, later on when the systems are already in use, logins and permissions applied, firewall fixed, etc.

Is there a simple way to get hold of the list of features installed on a sql server instance?

Answer 1

You can run "Installed SQL Server features discovery report"

It is documented there: Validate a SQL Server Installation

Some examples: how-to-find-out-what-sql-features-are-installed

Answer 2

This is a GUI method:

1. Mount the installation media for the correct version of SQL
2. Run setup.exe
3. Select "Tools" from the navigation pane
4. Select "Installed SQL Server features discovery report"
5. It will produce an .htm file and offer to open it in a browser

This report details the installed features.