How to get back the hidden tools in AdminStudio - Application Isolation Wizard, Quality Monitor, and Security Console tools under ‘AdminStudio Tools’ Menu?

Summary

How to get back hidden tools in AdminStudio - Application Isolation Wizard, Quality Monitor and Security Console tools under ‘AdminStudio Tools’ Menu?

Symptoms

Starting from AdminStudio 2018 and later, Application Isolation Wizard, Quality Monitor and Security Console tools are not listed under the ‘AdminStudio Tools’ menu.

Cause

The usage of some of the tools in AdminStudio was very low. In order to keep AdminStudio relevant and simple, some of such tools were hidden in the product.

Steps to Reproduce

1. Install AdminStudio 2018 or later
2. Launch the AdminStudio and Connect to an application catalog.
3. On the ‘Home’ tab, click ‘AdminStudio Tools’ and observe

Resolution

1. Close all the open instances of AdminStudio
2. Execute the attached 'Unhide_AS_Tools.sql' SQL file in SQL Server Management Studio against the Application catalog connected.
3. Launch AdminStudio and connect to the Application Catalog to get back the hidden tools - Application Isolation Wizard, Quality Monitor, and Security under ‘AdminStudio Tools’ Menu