List of Computers by SQL Server Edition

This report lists all of the computers with the specified SQL Server edition installed. The user-friendly prompts make it easy for report users to select any or all editions and versions of SQL Server. From here, you can drilldown to the SQL Server Details report.

The SSRS version of this report has a collapsible/expandable feature. By default, the report is collapsed hiding the collation and installation directory details, but you can choose to reveal this information by selecting the Expand radio button. Note: if you would like to see all editions and versions, you can simply select the prompt option, All Editions and All Versions.

In the Power BI report set when you click on any of the rows of data in the first table, the corresponding collation and installation directory information are displayed in the second table below.

SSRS

Collapsed View

Expanded View

Power BI