GertjanA
4 years agoModerator
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 o...
- 4 years ago
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.