Forum Discussion

GertjanA's avatar
GertjanA
Moderator
6 years ago
Solved

EV12.3 - find items on Legal Hold

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

  • Marcde's avatar
    Marcde
    6 years ago

    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

     

  • Marcde's avatar
    Marcde
    Moderator
    6 years ago

    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

    • GertjanA's avatar
      GertjanA
      Moderator
      6 years ago

      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.

      • Marcde's avatar
        Marcde
        Moderator
        6 years ago

        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