SQL assistance - if possible...

Hello all,

DA11.0.1 CHF5 with EV11.0.1 CHF5

We're running a massive amount of searches (one at the time), and find that the export sometimes fails to export all items. We've been given a way to check the failed item. These steps include:

Get the DiscoveredItemID of the item.

Using that, get the SavesetID and VaultID from the review tab.

Using the SavesetID and VaultID, analyze the item in EVSVR

Use retrieveitem.vbs to try to repair the item.

If not repairable, a note is made, and the customer is informed.


Having sometimes a set of failed items, does anyone know if it is possible to have some sort of automated check (using SQL, VB or other script) to perform above steps (semi-automated?)




Regards. Gertjan