OpsCenter Vault Query
Hello
I need a report query to show the number of copies from a backup Image. I need to know if there is a image without vaulting.
I'm lookuing for that in "domain_image" table but i'm not sure
Thanks in advance
Hi,
I looked at this a bit and its a bit complicated without knowing your duplication policy. We can look at domain_image.unexpiredCopyCount which will show you how many copies you have. So one could assume if its less than two you've not done the vault (the number depends on your number of copies). But then, depending on retention, it could also mean that the vault was done a long time ago, and now the primary (shorter retention) has lapsed so only one copy remains.
So to eliminate that you could add writeEndTime to only look at the last day (or 7)
select * from domain_image where domain_image.unexpiredCopyCount = 1
and DATEDIFF(day,UTCBigIntToNomTime(domain_image.writeEndTime), GETDATE()) <= 7Thoughts?