Enterprise Vault™ Installing and Configuring

IndexRootPathEntry [IndexRootPath]

The SQL to view the current location is as follows:

SELECT *
FROM IndexRootPathEntry
WHERE (IndexRootPathEntryId = '<ID FROM
LOG FILE>')

The SQL to update the location is as follows:

UPDATE IndexRootPathEntry
SET IndexRootPath = '<THE NEW LOCATION>'
WHERE (IndexRootPathEntryId = '<ID FROM
LOG FILE>')

PartitionEntry [AccountName]

SnapshotLocations [Path]

The SQL to view the current location is as follows:

SELECT *
FROM SnapshotLocations

The SQL to update the location is as follows:

UPDATE SnapshotLocations
SET Path = '<THE NEW LOCATION>'
WHERE (Path = '<THE OLD LOCATION>')

PartitionEntry [PartitionRootPath]

The SQL to view the current location is as follows:

SELECT *
FROM PartitionEntry
WHERE (PartitionEntryId = '<ID FROM LOG
FILE>')

The SQL to update the location is as follows:

UPDATE PartitionEntry
SET PartitionRootPath = '<THE NEW
LOCATION>'
WHERE (PartitionEntryId = '<ID FROM LOG
FILE>')

PartitionEntry/Locations [SecondaryLocation]

The SQL to view the current location is as follows:

SELECT *
FROM PartitionEntry
INNER JOIN Locations ON
PartitionEntry.SecondaryLocation =
Locations.LocationIdentity
WHERE (PartitionEntry.PartitionEntryId =
'<ID FROM LOG FILE>')

The SQL to update the location is as follows:

UPDATE Locations
SET Location = '<NEW LOCATION>'
WHERE LocationIdentity =
(SELECT SecondaryLocation FROM PartitionEntry
WHERE PartitionEntryId = '<ID FROM LOG
FILE>')

PartitionEntry [StagingRootPath]

The SQL to view the current location is as follows:

SELECT *
FROM PartitionEntry
WHERE (PartitionEntryId = '<ID FROM LOG
FILE>')

The SQL to update the location is as follows:

UPDATE PartitionEntry
SET StagingRootPath = '<THE NEW LOCATION>'
WHERE (PartitionEntryId = '<ID FROM LOG
FILE>')

PSTMigratorTask [MigrationDirectory]

ShoppingServiceEntry [ShoppingRootPath]

SiteEntry [PSTHoldingDirectory]

SmtpArchivingTask [HoldingFolder]