The following query can be modified to match the customer environment to return the Archive Name, Folder Path, Filename, Archive Date, and Modified/Created Date, for all files for a given archive:

USE VaultStoreDatabaseName
DECLARE @ArchiveName nvarchar(75);
DECLARE @ArchiveID nvarchar(75);
DECLARE @FolderID nvarchar(75);
DECLARE @Idtransaction nvarchar(40);
SET @ArchiveID = NULL;
SET @ArchiveName = 'ArchiveName';
SET @FolderID = NULL;
SET @Idtransaction = NULL;
SELECT TOP 1000
Archive.ArchiveName,
FolderPath,
CASE
WHEN sp.Properties LIKE '%/32/%'
    THEN (substring(SP.Properties, (charindex('FSA/3/', SP.Properties)+6), (charindex('/32/', SP.Properties)-(charindex('FSA/3/', SP.Properties)+6))))
WHEN sp.Properties LIKE '%/128/%'
    THEN (substring(SP.Properties, (charindex('FSA/3/', SP.Properties)+6), (charindex('/128/', SP.Properties)-(charindex('FSA/3/', SP.Properties)+6))))
WHEN sp.Properties LIKE '%v=%'
    THEN substring(SP.Properties,7,(charindex('|',SP.Properties)-7))
END AS FileName,
SS.ArchivedDate,
SS.IdDateTime,
SP.SavesetIdentity
FROM EnterpriseVaultDirectory.dbo.root AS r1
JOIN EnterpriseVaultDirectory.dbo.Root AS r2 on r1.RootIdentity = r2.ContainerRootIdentity
JOIN EnterpriseVaultDirectory.dbo.archive on r1.RootIdentity = Archive.RootIdentity
JOIN EnterpriseVaultDirectory.dbo.ArchiveFolder on r2.RootIdentity = ArchiveFolder.RootIdentity
JOIN Vault on r2.VaultEntryId = Vault.Vaultid
JOIN Saveset AS ss on Vault.VaultIdentity = ss.VaultIdentity
JOIN SavesetProperty AS sp on ss.savesetidentity = sp.SavesetIdentity
WHERE r1.VaultEntryid= ISNULL(@ArchiveID, r1.VaultEntryid)
AND ArchiveName = ISNULL(@ArchiveName, ArchiveName)   
AND r2.VaultEntryid = ISNULL(@FolderID, r2.VaultEntryId)  
AND ss.IdTransaction = ISNULL(@Idtransaction, ss.IdTransaction)
ORDER BY SavesetIdentity;

To run this query specific data will be required.

1. Record the Archive Name from the Vault Console and set it as the value of the @ArchiveName variable.
2. Record the name of the Vault Store that the archive resides in from the Vault Console and replace the VaultStoreDatabaseName in the USE command with the database name that corresponds to it.