0 Replies Latest reply on Nov 12, 2015 12:03 AM by Bo Vial

    How to determine the MS SQL Server Features installed

    Bo Vial

      I have a need to determine what SQL Server features are installed on a server.


      For example, I currently use an NSH script to check if SQL Server is installed:


      blquery -h mtossp-console04 -e 'package_installed("Microsoft SQL Server 2008 (64-bit)")'


      I then pull the exact edition out of the registry:


      SQL_Edition2008=`blquery -hserver01-e 'reg_value("HKEY_LOCAL_MACHINE\\\\SOFTWARE\\\\Microsoft\\\\Microsoft SQL Server\\\\100\\\\Tools\\\\Setup\\\\Edition")'`

      However, I also need to know what 'Features are installed' ie. database engine, admin services, management tools etc.


      For example, if I login to the server and run setup.exe /Action=RunDiscovery it will output a text file with the discovered features. I suppose I can use NSH to execute this command remotely and the parse the output file, but was just wondering if there might be a simpler way to do this?