Please find here the new SQL query to get every archive from each VS DB:
(You can tweak it a little to add the type to differeciate between PF/FSA/mailbox ....)
######## START ########
Declare @variable table
(
ID int IDENTI...
Hi GTK,
To have a complete report on all archive created in all VaultStore:
Use the query by swapping the VS DB name by yours.
Use "--VS DB name here--"
SELECT A.ArchiveName "Archive Name",
Cast(AP.CreatedDate as date) "Archive Created",
...