Media Object Orphans - Identify and Cleanup Tools?

[Larry_Jones]

I'm looking for a tool that can at least identify these types of Media Object Orphans:

1. F00165 Entries with no corresponding owner (example: missing P.O. or SO)
2. F00165 Entries with pointers to external OLEQUE files which are missing.
3. Files in the OLEQUE directory with no matching entry in the F00165 table(s).

Anyone ever taken these problems on or know of a commercial tool which handles at least one of the above?

Thanks in Advance,

 

[Ted Cooley]

Larry,

Unfortunately, there are no known canned applications that do this (probably because it is a pain). You have to write a UBE that parses out the media object keys in the F00165 and checks the corresponding data table to validate that the record still exists.

I've attached an example of how to do this. Implementation is a couple days of development effort to get all of your object types.

Thanks,
Ted Cooley
Terillium, Inc.