Enterprise Vault™ Upgrade Instructions
- About this guide
- Before you begin
- Points to note when upgrading
- Installing Outlook on the Enterprise Vault server
- Improved consistency when applying a retention period to items
- Additional points to note when upgrading from Enterprise Vault 11.0 or 11.0.1
- Steps to upgrade your system
- Enterprise Vault server preparation
- Single server: upgrading the Enterprise Vault server software
- Multiple servers: upgrading the Enterprise Vault server software
- Veritas Cluster Server: upgrading the Enterprise Vault server software
- Windows Server Failover Clustering: upgrading the Enterprise Vault server software
- Upgrading standalone Administration Consoles
- Upgrading Enterprise Vault Reporting
- Upgrading MOM and SCOM
- Upgrading Exchange Server forms
- Upgrading Domino mailbox archiving
- Upgrading the FSA Agent
- Upgrading Enterprise Vault Office Mail App
- Upgrading OWA Extensions
- Upgrading SharePoint Server components
- Upgrading SMTP archiving
- Checking the SMTP journaling type configuration
- Upgrading your Enterprise Vault sites to use Enterprise Vault Search
- Setting up provisioning groups for Enterprise Vault Search
- Configuring user browsers for Enterprise Vault Search
- Setting up Enterprise Vault Search Mobile edition
- Upgrading Enterprise Vault API applications
Finding SMTP targets that are assigned to unsupported archive types
Enterprise Vault 12.3 supports only archive types Exchange Mailbox and Internet Mail archives for SMTP Mailbox Journaling. The archive types that you can use for SMTP Journaling and SMTP Group Journaling are SMTP, Shared, or Exchange Journal, or Domino Journal archives.
After the upgrade is complete, if any of the existing SMTP targets are assigned to unsupported archive types, such as File System or SharePoint, you need to associate them with valid archive types.
On the SQL server that hosts the Directory database, run the following SQL query to retrieve the list of targets that are assigned to unsupported archive types:
USE EnterpriseVaultDirectory SELECT ST.TargetId, ST.Address, A.ArchiveName, AT.Name AS 'ArchiveType', CASE WHEN ST.TargetType = 1 THEN 'SMTP Journaling' WHEN ST.TargetType = 2 THEN 'SMTP Mailbox Journaling' WHEN ST.TargetType = 3 THEN 'SMTP Group Journaling' ELSE 'Legacy' END AS WronglyDetectedTargetType FROM SmtpTarget ST INNER JOIN SmtpTargetArchives STA ON STA.TargetId = ST.TargetId INNER JOIN Root R ON R.RootIdentity = STA.RootIdentity INNER JOIN Archive A ON A.RootIdentity = STA.RootIdentity INNER JOIN ArchiveType AT ON AT.Type = R.Type WHERE R.Type NOT IN (5, 17, 513, 2049) AND ST.TargetType IN (1, 3) UNION SELECT ST.TargetId, ST.Address, A.ArchiveName, AT.Name AS 'ArchiveType', CASE WHEN ST.TargetType = 1 THEN 'SMTP Journaling' WHEN ST.TargetType = 2 THEN 'SMTP Mailbox Journaling' WHEN ST.TargetType = 3 THEN 'SMTP Group Journaling' ELSE 'Legacy' END AS WronglyDetectedTargetType INNER JOIN SmtpTargetArchives STA ON STA.TargetId = ST.TargetId INNER JOIN Root R ON R.RootIdentity = STA.RootIdentity INNER JOIN Archive A ON A.RootIdentity = STA.RootIdentity INNER JOIN ArchiveType AT ON AT.Type = R.Type WHERE R.Type NOT IN(9, 4097) AND ST.TargetType = 2
This query returns information about each target such as the ID of the target, the SMTP target address, name of the archive, and the archive type. You can export the retrieved results to a CSV or TXT file.
If you want to assign multiple archives to this target, you need to delete the address and add it again with the supported archive types.