Sure, you would just remove the parts of the WHERE clause that limit it to one archive. So step 2 becomes this SQL:
USE EnterpriseVaultDirectory
SELECT DATALENGTH(FolderPath) AS "Folder Path Data Length",
LEN(CAST(FolderPath AS NVARCHAR(MAX))) AS "Folder Path Character Length",FolderPath, ArchiveVEID
FROM ArchiveFolderView
WHERE CAST(FolderPath AS NVARCHAR(MAX)) LIKE '%Inbox'
And step 3 becomes:
USE EnterpriseVaultDirectory
UPDATE dbo.ArchiveFolderView
SET FolderPath=LTRIM(CAST(FolderPath AS NVARCHAR(MAX)))
WHERE FolderName = 'Inbox'
Note that this may take a long time because you're removing leading spaces from every inbox folder instead of just the ones you know are affected. Those that don't have any leading spaces won't end up being changed by the LTRIM function, but it still takes the time to evaluate them all. Even more so if you apply it to all folders and not just the inbox, as in the note at the end of the article.
Another alternative would be to run step 2 without the ArchiveID condition, in order to identify the affected archives, and then use the list of ArchiveIDs that are returned to limit step 3 with a clause like
WHERE ArchiveVEID IN ('ArchiveVEID1', 'ArchiveVEID2', 'ArchiveVEID3')
Feel free to open a support case if you want some hands-on assistance fixing this.
--Chris
