Forum Discussion

ia01's avatar
ia01
Level 6
11 years ago

Total Size of an FSA Archive

Hi,

Is there any SQL script I can use to get Total size in GB for a Particular or all FSA Archives archived items?

Many Thanks

  • You can just use the Usage Report (http://yourEVServer/EnterpriseVault/Usage.asp)

    Or a quick query would be

    SELECT A.ArchiveName "FSA Archive", 
           AP.ArchivedItems "Archived Items",
           AP.ArchivedItemsSize/1024/1024 "Archive Size (GB)"
    FROM   EnterpriseVaultDirectory.dbo.Archive A,
           EnterpriseVaultDirectory.dbo.Root R,
           EVVSYourVaultStore_02.dbo.ArchivePoint AP
    WHERE  A.RootIdentity = R.RootIdentity 
      AND  R.RootIdentity = AP.ArchivePointId
      AND  R.Type = 129
    ORDER BY A.ArchiveName
    

2 Replies

  • You can just use the Usage Report (http://yourEVServer/EnterpriseVault/Usage.asp)

    Or a quick query would be

    SELECT A.ArchiveName "FSA Archive", 
           AP.ArchivedItems "Archived Items",
           AP.ArchivedItemsSize/1024/1024 "Archive Size (GB)"
    FROM   EnterpriseVaultDirectory.dbo.Archive A,
           EnterpriseVaultDirectory.dbo.Root R,
           EVVSYourVaultStore_02.dbo.ArchivePoint AP
    WHERE  A.RootIdentity = R.RootIdentity 
      AND  R.RootIdentity = AP.ArchivePointId
      AND  R.Type = 129
    ORDER BY A.ArchiveName
    
  • Thanks JW, don't know how I missed the easy one.... usage report :-)