search cancel

Find user specific User Interface options

book

Article ID: 88529

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

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

 

 

 
 

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

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>