Missing Folder

boligoma · Post by **boligoma** » Wed Oct 29, 2008 6:00 pm

Hi,

We have a missing job folder in the project, I don't if somebody accidentally deleted it or if the information is still in the server and we it doesn't appear in the Director (I'm guessing here).

We are having several performance problems with the entire project, the security deparment told us that is a network problem.

Can I see a log of the deleted jobs/folders in my project?, if yes, how can I do it?

Thanks,

ray.wurlod · Post by **ray.wurlod** » Wed Oct 29, 2008 6:36 pm

I don't know for sure whether this will work in version 8, but it's worth trying.

Code: Select all

SELECT INSTANCE, PREVDTD, PREVDELETOR FROM DS_AUDIT WHERE PREVDTD LIKE '2...' AND CLASS = '2';

boligoma · Post by **boligoma** » Wed Oct 29, 2008 7:38 pm

Thank you Ray,

It appears that version 8 doesn't use the PREVDTD field at all, I deleted a job and then created with the same name and the result of looking up that name in the INSTANCE field returned a "created on" this day, but nothing in the "Last deleted on".

Is there another table where I can find the deleted jobs? I'm new in looking up at the metadata.

Thanks,

ray.wurlod · Post by **ray.wurlod** » Thu Oct 30, 2008 9:08 am

PREVDTD is present only for deleted and not re-created objects.

Doubtless there is somewhere in the XMETA repository where this information is also kept, but I have not yet had the opportunity to analyze where this might be.