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?