Detailed Description and Symptoms
***NOTE: The following contains SQL statements that can be run against the Automic database. Automic does not support custom UPDATE, INSERT, or DELETE statements for any reason unless provided by Support, and does not recommend running SELECT statements in a Production environment as they may negatively impact performance.
Further info: User specific options that have been set via the Options menu -> Settings in the User Interface are stored in the database in the ini table. These can be found by using the select statement (<user name> and <client> will need to be replaced with the correct values):
Select * from ini where ini_section = 'SETTINGS' and ini_idnr in (select oh_idnr from oh where oh_name = '<user name>' and oh_client = '<client>');
For example, looking for the user "DEM/SUPPORT" in Client 100 would be:
Select * from ini where ini_section = 'SETTINGS' and ini_idnr in (select oh_idnr from oh where oh_name = 'DEM/SUPPORT' and oh_client = '100');