We have more multiple keys licensed with different features. We want to ensure we stay in compliance with the licensing we purchase. How can a program or script determine what edition is installed on a client?
RESOLUTION 1: Accessing the QSAuth11.key file.
All installs of Toad should be the same. The question about editions and enabled features is determined by the key. The key file in all versions of Toad for Oracle is the QSAuth11.key file and is a text file that can be opened and parsed. The first line will be the key. The second line is the site message. In Toad version 9.7 this key file also includes text that notes the features enabled. In older versions of Toad and this key file, it will only have the key and site message.
EX:
0-12345-67890-23456-78901
QUEST SOFTWARE, INC.
Toad for Oracle Xpert Add-Ons: DB Admin module, SQL Optimizer
In this example, it's an Xpert key that includes the DB Admin module and Optimizer which is the most a key could enabled. Some other keys may only note "SQL Optimizer" , or just "DB Admin module". If a key has no features, just a standard license it will say "<none>".
The QSAuth file location is different between older versions of Toad and the newer 9.7. In 9.7 this file is located in C:\Documents and Settings\<personal folder>\Application Data\Quest Software\Toad for Oracle9.7. For Toad 9.6 and older, the file is in the C:\Program Files\Quest Software\Toad for Oracle directory. Keep in mind the directory may change with the uninstall/install of Toad and different versions.
RESOLUTION 2: Check the registry.
For Toad 9.7 you can check HKEY_CURRENT_USERSoftwareQuest SoftwareToad<version>. In that registry you will find the variable "Package" that will note the kind of key installed, i.e. "Toad for Oracle Xpert Add-Ons: DB Admin module, SQL Optimizer". For 9.6 and older the registry is HKEY_LOCAL_MACHINE|Software|Quest Software|Toad<version> and should have the same information.
