Automic Workload Automation

Dear Experts,

We are getting frequent requests  for the list of jobs exists in a client. Is there any way to export the UC4 objects in a folder/sub folders to a excel sheet. I have tried export it to XML file and importing the XML file into the Excel.

But it didnt work properly.

Thanks,

RK

Hi

if you use Java client, just rightclick in the free space in (Automic) explorer, View - export to file - into an CSV file.

cheers, Wolfgang

Dear Wolfgang,

Thanks for your reply.

We are using AWI 12 in web interface. I am not able get such options.

Thanks,

RK

Hi

I wasn't able too with AWI...

If you want to invest 15 Minutes you can install JAVA Client :-)

cheers, Wolfgang

I was poking around in the database to see what it would take to run a query of the contents of a folder.  You have to join OH (object table) to OFS (folder relationship table) like so;

select oh_name
from ofs, oh
where ofs_oh_idnr_f = 1006459
and oh_idnr = ofs_oh_idnr_o;

The ofs table has one row for each folder.  So if you are looking for objects in folder L1/L2/L3, these are represented by three different rows in the oh table that have relationships to one another.   In my case I wanted to know the objects that were stored in L3, so I found its oh_idnr and used that in my query.