Find user specific User Interface options

Document ID : KB000088529
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.


Investigation

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');

 

 

 
 
Resolution:
This is output in "un-beautified" xml:
<SETTINGS client="0100" idnr="0000000005" name="NB61898A - 0100 - DEM/SUPPORT" src="ini" system="NB61898A"><GENERAL state="2"><MAGNETIC_OFF>0</MAGNETIC_OFF><MAGNETIC_E1>0</MAGNETIC_E1><MAGNETIC_E2>1</MAGNETIC_E2><MAGNETIC_REG>15</MAGNETIC_REG><SEPARATE_DESKTOPS>1</SEPARATE_DESKTOPS><SHARED_DESKTOP>0</SHARED_DESKTOP><TLB_LABELS_OFF>0</TLB_LABELS_OFF><TLB_LABELS_RIGHT>1</TLB_LABELS_RIGHT><TLB_LABELS_BOTTOM>0</TLB_LABELS_BOTTOM><MAX_IMPORT_SIZE>1024</MAX_IMPORT_SIZE></GENERAL><REFRESH state="2"><REFR_MAN>0</REFR_MAN><REF_AUTO>1</REF_AUTO><WAIT>9</WAIT><INT>9</INT><CHK_M IsSelected="1"><CALL_M>1</CALL_M><JOBP_M>1</JOBP_M><JSCH_M>0</JSCH_M><CPIT_M>0</CPIT_M></CHK_M></REFRESH><MESSAGES state="2"><OWN>1</OWN><GROUP/><ALL>0</ALL><ADMIN>0</ADMIN><SECUR>0</SECUR><AUTO>1</AUTO><ERROR>1</ERROR><INFO>0</INFO><MAN>0</MAN><EWONLY>0</EWONLY><DATE>0</DATE><NUM>50</NUM><DAYS>2</DAYS><UNREAD>0</UNREAD></MESSAGES><ISENSE state="2"><IsenseOptions IsSelected="1"><ParaInfo>1</ParaInfo><ParaHelp>1</ParaHelp><AutoPrefix>1</AutoPrefix><AutoIndent>1</AutoIndent><AutoClose>1</AutoClose></IsenseOptions></ISENSE><STATISTICS state="2"><STATS>50</STATS></STATISTICS><LOCTIME state="2"><TZ/><TF/><CALE_V>1</CALE_V><CALE_H>0</CALE_H><CALE_P>0</CALE_P><FIRSTWEEK default="4">0</FIRSTWEEK></LOCTIME><CHECKBACK state="2"><ask IsSelected="1"><deleteobject>1</deleteobject><deleteforecast>1</deleteforecast><removeobject>1</removeobject><executeobject>1</executeobject><getversion_control>1</getversion_control><canceltask>1</canceltask><quittask>1</quittask><printobject>1</printobject><terminate_host>1</terminate_host><terminate_server>1</terminate_server><shutdown_uc4>1</shutdown_uc4><disconnect_host>1</disconnect_host><disconnect_user>1</disconnect_user><deleteentry>1</deleteentry><deacttask>1</deacttask><modifytask>1</modifytask><stoptask>1</stoptask><gotask>1</gotask><stoptask_all>1</stoptask_all><gotask_all>1</gotask_all><sysstatestop>1</sysstatestop><sysstatego>1</sysstatego><ignoresync>1</ignoresync><changelogging>1</changelogging><ilm_switchout>1</ilm_switchout><ilm_drop>1</ilm_drop></ask></CHECKBACK><JOBPDEF state="2"><When>ANY_ABEND</When><ExtJPWhen>ENDED_INACTIV</ExtJPWhen><WElseS>0</WElseS><WElseH>0</WElseH><WElseX>1</WElseX><WElseA>0</WElseA><ChkWhenExec/><WhenExecute/><OPEN>0</OPEN><RequireLines>0</RequireLines><CheckLines>1</CheckLines><JPEnhanced>1</JPEnhanced><JPClassic>0</JPClassic><tooltip_details IsSelected="1"><thumbnail>1</thumbnail><general>1</general><external>1</external><checkpoint>1</checkpoint><after>1</after><when>1</when><runtime>1</runtime><result>1</result><calendars>1</calendars></tooltip_details></JOBPDEF><ERPFORMS state="2"><ErpDefLogin/><Ps_1/></ERPFORMS><FONTDEF state="2"><FontSize>11</FontSize><MonoFont><Type>Courier New</Type><Style>Plain</Style><Size>13</Size></MonoFont></FONTDEF></SETTINGS>
 
 
Below is the "beautified" xml:
<SETTINGS client=""0100"" idnr=""0000000005"" name=""NB61898A - 0100 - DEM/SUPPORT"" src=""ini"" system=""NB61898A"">
 <GENERAL>
  <MAGNETIC_OFF>0</MAGNETIC_OFF>
  <MAGNETIC_E1>0</MAGNETIC_E1>
  <MAGNETIC_E2>1</MAGNETIC_E2>
  <MAGNETIC_REG>15</MAGNETIC_REG>
  <SEPARATE_DESKTOPS>1</SEPARATE_DESKTOPS>
  <SHARED_DESKTOP>0</SHARED_DESKTOP>
  <TLB_LABELS_OFF>0</TLB_LABELS_OFF>
  <TLB_LABELS_RIGHT>1</TLB_LABELS_RIGHT>
  <TLB_LABELS_BOTTOM>0</TLB_LABELS_BOTTOM>
  <MAX_IMPORT_SIZE>1024</MAX_IMPORT_SIZE>
 </GENERAL>
 <REFRESH>
  <REFR_MAN>0</REFR_MAN>
  <REF_AUTO>1</REF_AUTO>
  <WAIT>9</WAIT>
  <INT>9</INT>
  <CHK_M>
   <CALL_M>1</CALL_M>
   <JOBP_M>1</JOBP_M>
   <JSCH_M>0</JSCH_M>
   <CPIT_M>0</CPIT_M>
  </CHK_M>
 </REFRESH>
 <MESSAGES>
  <OWN>1</OWN>
  <GROUP/>
  <ALL>0</ALL>
  <ADMIN>0</ADMIN>
  <SECUR>0</SECUR>
  <AUTO>1</AUTO>
  <ERROR>1</ERROR>
  <INFO>0</INFO>
  <MAN>0</MAN>
  <EWONLY>0</EWONLY>
  <DATE>0</DATE>
  <NUM>50</NUM>
  <DAYS>2</DAYS>
  <UNREAD>0</UNREAD>
 </MESSAGES>
 <ISENSE>
  <IsenseOptions>
   <ParaInfo>1</ParaInfo>
   <ParaHelp>1</ParaHelp>
   <AutoPrefix>1</AutoPrefix>
   <AutoIndent>1</AutoIndent>
   <AutoClose>1</AutoClose>
  </IsenseOptions>
 </ISENSE>
 <STATISTICS>
  <STATS>50</STATS>
 </STATISTICS>
 <LOCTIME>
  <TZ/>
  <TF/>
  <CALE_V>1</CALE_V>
  <CALE_H>0</CALE_H>
  <CALE_P>0</CALE_P>
  <FIRSTWEEK default=""4"">0</FIRSTWEEK>
 </LOCTIME>
 <CHECKBACK>
  <ask>
   <deleteobject>1</deleteobject>
   <deleteforecast>1</deleteforecast>
   <removeobject>1</removeobject>
   <executeobject>1</executeobject>
   <getversion_control>1</getversion_control>
   <canceltask>1</canceltask>
   <quittask>1</quittask>
   <printobject>1</printobject>
   <terminate_host>1</terminate_host>
   <terminate_server>1</terminate_server>
   <shutdown_uc4>1</shutdown_uc4>
   <disconnect_host>1</disconnect_host>
   <disconnect_user>1</disconnect_user>
   <deleteentry>1</deleteentry>
   <deacttask>1</deacttask>
   <modifytask>1</modifytask>
   <stoptask>1</stoptask>
   <gotask>1</gotask>
   <stoptask_all>1</stoptask_all>
   <gotask_all>1</gotask_all>
   <sysstatestop>1</sysstatestop>
   <sysstatego>1</sysstatego>
   <ignoresync>1</ignoresync>
   <changelogging>1</changelogging>
   <ilm_switchout>1</ilm_switchout>
   <ilm_drop>1</ilm_drop>
  </ask>
 </CHECKBACK>
 <JOBPDEF>
  <When/>
  <ExtJPWhen/>
  <WElseS/>
  <WElseH>1</WElseH>
  <WElseX/><WElseA/>
  <ChkWhenExec/>
  <WhenExecute/>
  <OPEN>0</OPEN>
  <RequireLines>0</RequireLines>
  <CheckLines>1</CheckLines>
  <JPEnhanced>1</JPEnhanced>
  <JPClassic>0</JPClassic>
  <tooltip_details>
   <thumbnail>1</thumbnail>
   <general>1</general>
   <external>1</external>
   <checkpoint>1</checkpoint>
   <after>1</after>
   <when>1</when>
   <runtime>1</runtime>
   <result>1</result>
   <calendars>1</calendars>
  </tooltip_details>
 </JOBPDEF>
 <ERPFORMS>
  <ErpDefLogin/>
  <Ps_1/>
 </ERPFORMS>
 <FONTDEF>
  <FontSize/>
  <MonoFont>
   <Type>Courier New</Type>
   <Style>Plain</Style>
   <Size>13</Size>
  </MonoFont>
 </FONTDEF>
</SETTINGS>