Can we query that how much content has been replicated to Remote file server within a timeframe?

[pmanwal]

Please help on have a DB query to find out that how much data has been  replicated to remote file server within a given time frame.

[Arshad]

Hi 

You may try this query :

select count(*) as Files_Replicated,rv.name as Replica_Vault_Name
from ReplicatedItem ri,
ReplicaVault rv,
ReplicaFolder rf
where ri.createStampA2 >= '2017-03-05 14:24:05.000' AND ri.createStampA2 <= '2018-05-26 22:44:12.000'
and rf.idA3A5 = rv.idA2A2
and ri.idA3A4 = rf.idA2A2
group by rv.name;

-Arshad