Forum Discussion

Elio_C's avatar
Elio_C
Level 6
11 years ago

Archive Folder and Item Counts

Hi, I'm looking for a way to display some archive information. I'd like to report on folders and the count of items in each. I have the below to list the folders, which table/tables can I link ...
Enterprise Vault
Information Governance
Reporting
Windows Server (2003-2008)
  • Pradeep-Papnai's avatar
    Pradeep-Papnai
    11 years ago

    Ran following SQL query against VS database.

    Select afv.FolderName, vt.VaultID Folder_id, ap.ArchivedItems, ap.ArchivedItemsSize 'Size(kb)' from ArchivePoint ap
    inner join Vault vt on vt.ArchivePointIdentity = ap.ArchivePointIdentity
    inner join EnterpriseVaultDirectory.dbo.ArchiveFolderView afv on afv.VaultEntryId = vt.VaultID
    where ap.ArchivePointId = 'UserARchiveId'

     

Pradeep-Papnai's avatar
Pradeep-Papnai
Level 6
11 years ago

Ran following SQL query against VS database.

Select afv.FolderName, vt.VaultID Folder_id, ap.ArchivedItems, ap.ArchivedItemsSize 'Size(kb)' from ArchivePoint ap
inner join Vault vt on vt.ArchivePointIdentity = ap.ArchivePointIdentity
inner join EnterpriseVaultDirectory.dbo.ArchiveFolderView afv on afv.VaultEntryId = vt.VaultID
where ap.ArchivePointId = 'UserARchiveId'