cancel
Showing results for 
Search instead for 
Did you mean: 

EV12.3 - find items on Legal Hold

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

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

Regards. Gertjan
1 ACCEPTED SOLUTION

Accepted Solutions

Marcde
Moderator
Moderator
Partner    VIP    Accredited

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

 

PMCS GmbH & Co. KG - A Serviceware Company
www.serviceware.de

View solution in original post

3 REPLIES 3

Marcde
Moderator
Moderator
Partner    VIP    Accredited

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

PMCS GmbH & Co. KG - A Serviceware Company
www.serviceware.de

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

Regards. Gertjan

Marcde
Moderator
Moderator
Partner    VIP    Accredited

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

 

PMCS GmbH & Co. KG - A Serviceware Company
www.serviceware.de