11-28-2019 05:47 AM
Hello all,
I need to get a list of items which are on Legal Hold. TransactionID or SaveSetId, either is fine. If possible the archivename in which the item is, but that is not required.
Can I somehow get this information from the Vault Store Database? Or perhaps from the DA Customer database?
Thanks.
GJ
Solved! Go to Solution.
12-02-2019 11:29 PM
Good morning Gertjan,
not sure what happend to my reply that I posted yesterday. I did some reserach and tests in my lab. You should be able to utilize the view view_Holds within the vaultstore database.
USE <VaultStoreDB>
SELECT vh.HoldIdentity, s.IdTransaction, ap.ArchivePointId FROM view_Holds vh
INNER JOIN Saveset s ON vh.SavesetIdentity = s.SavesetIdentity
INNER JOIN ArchivePoint ap ON vh.ArchivePointIdentity = ap.ArchivePointIdentity
Regards
Marc
11-29-2019 12:36 AM
Hi Gertjan,
without digging into this too deep, I can think of something like this:
USE <CustomerDatabase>
SELECT KVSSaveSetID from tblIntDiscoveredItems where LegalStatus = 426
Based on the information from here:
How to identify the archives that have items on Legal Hold using a SQL query
https://www.veritas.com/support/en_US/article.100034248
Regards
Marc
12-02-2019 02:14 AM
Thanks Marc,
I did see that KB thanks. I'll check if that can deliver what I need.
I was looking for a query to get it from the Vault Store database, but this might do also.
12-02-2019 11:29 PM
Good morning Gertjan,
not sure what happend to my reply that I posted yesterday. I did some reserach and tests in my lab. You should be able to utilize the view view_Holds within the vaultstore database.
USE <VaultStoreDB>
SELECT vh.HoldIdentity, s.IdTransaction, ap.ArchivePointId FROM view_Holds vh
INNER JOIN Saveset s ON vh.SavesetIdentity = s.SavesetIdentity
INNER JOIN ArchivePoint ap ON vh.ArchivePointIdentity = ap.ArchivePointIdentity
Regards
Marc