There are a few preview features inside SQL Estate Manager which are not enabled by default. While these features are preview, each of that requires a corresponding environment variable to be set to "true".

Preview features

SQL Census

SQL Census is designed to help you explain to an auditor which of your colleagues are able to access business-critical SQL Server databases. As well as reporting on who can access these databases, it explains what they can do (ie, the capability their permissions give them) and how (ie, the ways in which they’ve inherited these capabilities).

In order to enable this feature, set "Redgate_SEM__FeatureFlags__SqlCensus__IsEnabled" environment variable value to "true" for System and restart SQL Estate Manager. You can use the below PowerShell code to enable this. You need to run PowerShell as an Administrator:

[Environment]::SetEnvironmentVariable('Redgate_SEM__FeatureFlags__SqlCensus__IsEnabled', 'true', 'Machine')

Click "View SQL Estate Snapshot" then "SQL Census" in order to access that feature. See screenshot below;

Live view of your SQL Server estate

Live view enables you to view the relevant, point-in-time information regarding your known SQL Server estate.

In order to enable this feature, set "Redgate_SEM__FeatureFlags__ViewSqlEstate__IsEnabled" environment variable value to "true" for System and restart SQL Estate Manager. You can use the below PowerShell code to enable this. You need to run PowerShell as an Administrator:

[Environment]::SetEnvironmentVariable('Redgate_SEM__FeatureFlags__ViewSqlEstate__IsEnabled', 'true', 'Machine')

Click "View SQL Estate" in order to access that feature. See screenshot below;