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?