Automic Workload Automation

 View Only
  • 1.  Tabelle: Job/Ordner Verknüpfung

    Posted Aug 22, 2019 11:11 AM
    Hi,

    kann mir jemand sagen in welcher Tabelle Job und Ordner in dem er sich befindet verknüpft sind?

    Ich habe keine sinnvolle Spalte oder Tabelle gefunden. Beides einzeln ja nur die Verknüpfung fehlt mir.

    Vielen Dank
    Lisa


  • 2.  RE: Tabelle: Job/Ordner Verknüpfung

    Posted Aug 22, 2019 12:39 PM
    Folders and their relationships are in OH.


    --- ********************************************
    --- Simple report of folder contents
    --- ********************************************
    select folders.OH_Client as Client
         , folders.oh_name as Folder 
       , members.oh_otype as Type
    , members.oh_name as Member
    from oh folders, oh members, ofs
    where folders.oh_idnr = ofs_oh_idnr_f
    and   members.oh_idnr = ofs_oh_idnr_o
    and folders.oh_client = 0200

    ------------------------------
    Pete
    ------------------------------



  • 3.  RE: Tabelle: Job/Ordner Verknüpfung

    Posted Aug 22, 2019 12:42 PM
    --- ********************************************
    --- returns the folder location for one object
    --- ********************************************
    with objectpath (OH_IDNR, OH_NAME, LVL) as (
    select OH_IDNR, CAST('\' + OH_Name AS VARCHAR(MAX)), 0
    from OH
    where OH_Client = 0
    and OH_Name = 'UC_SYSTEM_SETTINGS'
    UNION ALL
    select OFS_OH_IDNR_F,
    SUBSTRING(OH.OH_Name, CHARINDEX('\', OH.OH_Name), 200) +
    objectpath.OH_Name,
    LVL + 1
    from objectpath
    inner join OFS on objectpath.OH_Idnr = OFS_OH_Idnr_O
    inner join OH on OFS_OH_IDNR_F = OH.OH_Idnr
    )
    select TOP 1 OH_Name
    from objectpath
    order by LVL desc;

    ------------------------------
    Pete
    ------------------------------



  • 4.  RE: Tabelle: Job/Ordner Verknüpfung

    Posted Aug 23, 2019 03:54 AM
    Thank you very much Pete.

    What I'm looking for was ofs.
    Complete query is also good. Thank you