EV12 - SQL query question
Hello all,
I have a query which gives me the SavesetID and the IDTransAction (see below) for items being on Legal Hold. I would like this query to return only that information for items which are on Centera storage. Does anyone have an addition to the below doing that?
Use VaultStoreDatabaseName
SELECT hs.SavesetIdentity AS 'SavesetIdentity', s.idtransaction AS 'TransActionID'
FROM HoldSaveset AS hs
JOIN Saveset AS s ON s.SavesetIdentity = hs.SavesetIdentity
Hello GertjanA
I did some digging and used a little help as well.
There is an assumption though...
In the PartitionEntry Table in the Directory Database, we have a column called DeviceType. Check the values for the rows corresponding to the PartitionRootPath column where the values point to the Centera location. If the values are the same and differ from other Storage Types, the following query will be very useful.
SELECT hs.SavesetIdentity AS 'SavesetIdentity', s.idtransaction AS 'TransActionID'
FROM HoldSaveset AS hs
JOIN Saveset AS s ON s.SavesetIdentity = hs.SavesetIdentity
WHERE IdPartition in (select IdPartition from PartitionCache where DeviceType = <Value seen in the PartitionEntry Table>)
Do let me know how it goes.