cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Level 6

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

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 1

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

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