cancel
Showing results for 
Search instead for 
Did you mean: 

Enterprise Vault Root Table 'Type' Column

FBD
Level 3

Hi

A number of Enterprise Users appear to have multiple vaults, the current default vault which is the destination of new archived emails and legacy 'dead' vaults.  

We are preparing to merge the emails within 'dead' vaults to the users' current default vaults however within the admin interface some of the dead vaults are not listed within the EV web interface but are listed when I run the below SQL query

SELECT *
FROM   EnterpriseVaultDirectory.dbo.Archive A,
       EnterpriseVaultDirectory.dbo.Root R,
       EVDefaultVaultStore.dbo.ArchivePoint AP
       
WHERE  AP.ArchivePointId = R.VaultEntryId
  AND  R.RootIdentity = A.RootIdentity
  AND AP.ArchivedItems <> 0 and A.ArchiveName like '%xyz%'
  order by ArchiveName ASC
 
I investigated further and can see those vaults not listed from the Table 'Root' are type '5' whereas those that are listed in admin interface are type '9'.  In terms of EV archives, what is 'type' and what does integers 5 and 9 mean? 
 
We are using Enterprise Vaut 9.0.2 with SQL 2008 Enterprise.
 
Many thanks
1 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified
This is the list of the types that i know of, i think its missing Domino, i dont have a domino environment, so i'm not sure what that would be

Shared Archive = 5
Mailbox Archive = 9
Mailbox Folder  = 10
Journal Archive = 17
Public Folder Archive = 33
Public Folder Folder  = 34
SharePoint Archive = 65
Sharepoint Archive Folder = 66
FSA Archive = 129
FSA Folder = 130
https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

6 REPLIES 6

MichelZ
Level 6
Partner Accredited Certified

Type is the Archive Type.

9 = Mailbox Archive

5 = ? (Could be shared)

there is FSA Archive, Notes Archive, and probably couple of others as well.

Can you check if the Archive shows up when you go to the "Shared Archives" node in the VAC?


cloudficient - EV Migration, creators of EVComplete.

JesusWept3
Level 6
Partner Accredited Certified
This is the list of the types that i know of, i think its missing Domino, i dont have a domino environment, so i'm not sure what that would be

Shared Archive = 5
Mailbox Archive = 9
Mailbox Folder  = 10
Journal Archive = 17
Public Folder Archive = 33
Public Folder Folder  = 34
SharePoint Archive = 65
Sharepoint Archive Folder = 66
FSA Archive = 129
FSA Folder = 130
https://www.linkedin.com/in/alex-allen-turl-07370146

GabeV
Level 6
Employee Accredited

For Domino Journal Archive, value is 513 and Domino Archive is 1025 ... just in case you have Domino on your environment

JesusWept3
Level 6
Partner Accredited Certified

is a domino mailbox archive folder 1026 in that case?

https://www.linkedin.com/in/alex-allen-turl-07370146

EV_Ajay
Level 6
Employee Accredited

Type = 9 , User Mailbox Archive
Type = 5, Shared Archive

FBD
Level 3

Thank you all for your replies.