Determine SourceOne Base Path (4254909)

Solution

Overview

Setting up the Basepath in Archive Shuttle menu:
Configuration -> SourceOne/EMX Environment -> Add Environment -> SourceOne/EMX BasePaths

1. If data resides on other data storage solutions, run the SQL query below against SourceOne database:

SELECT DISTINCT SUBSTRING(CurrentUNCPath, 1, PATINDEX('%______\______________.emx', CurrentUNCPath) - 2) FROM Volume WHERE CurrentUNCPath LIKE '\\%' AND CurrentUNCPath LIKE '%.emx'

You may get similar results from the query above, and those should represent the BasePaths in the SourceOne environment:

\\SourceOneDrive\MailArchiveX\Mail Archive X
\\SourceOneDrive\MailArchiveY\Mail Archive Y
\\SourceOneDrive\MailArchiveZ\Mail Archive Z

These are the share paths for each archive folder. Multiple paths should be semicolon separated and entered as a single string with no return characters.

2. If data resides on a Centra try to leave the column empty and save the form. If you get a warning to provide a part, the SourceOne/EMX BasePaths field requires something configured.  The IP address and PEA files are pulled directly from the SourceOne database and ignores the value you enter – but you must enter a value. Try using the the SQL query below against SourceOne database:

SELECT DISTINCT SUBSTRING(CurrentUNCPath, 1, PATINDEX('%______\______________.emx', CurrentUNCPath) - 2) FROM Volume WHERE CurrentUNCPath LIKE '\%' AND CurrentUNCPath LIKE '%.emx'

One path entry should be returned in most cases from this query.