first of all, I have created an expiry report with e-mail notification based on the searcho2k.asp. Since EV 12.2, this searcho2k.asp is EOL. So If I perform the upgrade, I have no chance to determine expiring items for each archive.
At the moment, I have three approachs, but all are unsuccesful:
Method 1: (imo the best approach) Expiry Report on SQL basis
JesusWept3 provided an SQL Statement to receive all expiring items. At further analysis, I figured out that the database only stores the saveset ids. To retrieve more informations (e.g. sent date, messagesubject) I have to extract the saveset information. https://www.veritas.com/support/en_US/article.100022284.html
As a result, I have to extract the whole saveset for each item. This sounds very roundabout and complicated. Is there a way to get this information directly from the index?
Method 2: migrate the eol search02k.asp to ev 12.2
This method doens't work. I am redirected directly to EVS
Method 3: develop the expiy report on new EVS url
This method doesn' work, because if i want to resolve my custom url with the vsa account, the vsa account has no access to the personal EVS Archive expiry report url. With searcho2k.asp, this VSA could perform this action.
So this is my experience with developing an advanced expiry report with user notification. If someome has an idea, I would really appreciate it. Thanks in advance, FLX