how to list all features installed in a sql server instance? 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 Server\130\Setup Bootstrap\Log\20200109_205540



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:


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?
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