Skip to main content
1-Visitor
June 6, 2018
Question

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

  • June 6, 2018
  • 1 reply
  • 1210 views

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.

1 reply

17-Peridot
June 9, 2018

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