Andreas_Sprosec_7439

DB Schema

Discussion created by Andreas_Sprosec_7439 on May 17, 2017

You Asked

Where I can find the data model of the Automation Engine especially information about ‘Automic scripting’?

And we said …

You can get the information of a table in our online documentation or in folder of the Automation Engine Image in ..\db\_structure.

For script-lines you need to query table ‘OT’.

nif7ncuzulng.png

d3874eh3w94y.png

SELECT OH_NAME
     , OT_OH_IDNR
     , OT_TYPE
     , OT_LNR
     , OT_CONTENT      
from ot, oh
where ot.OT_OH_IDNR = oh.OH_IDNR
order by OT_OH_IDNR
            , OT_LNR
;

Outcomes