Automic Workload Automation

hi

I want to create SQLI job that show the location of the VARA files. But I can't find the table where the location is saved. I find this OFS_OH_Idnr_F, but not the location ..

Any idea in what table this info is saved?

br

Sören

Hi,

I have found a workaround. I have used this to find all the VARA files that are older than 1 month and created in a "LOG" dir:

Select OH.OH_Name, OH.OH_Title, OH.OH_CrDate
from OH, OFS
where OH.OH_Idnr = OFS.OFS_OH_Idnr_O
and OH_Client = &$CLIENT#
and OH.OH_OType = 'VARA'
and OH.OH_CrDate < ADD_MONTHS(TRUNC(SYSDATE), -1)
and OFS.OFS_OH_Idnr_F IN
(select OH.OH_Idnr
from OH
where OH.OH_Idnr = OFS.OFS_OH_Idnr_F
and OH.OH_NAME LIKE '%\LOG')
order by OH.OH_Title, OH.OH_CrDate

Br

Sören