Is there a possibility to search an Exchange mailbox Enterprise Vault user archive / journal Archive for selected items, using powershell scripts / cmdlets / Tools ? (filter based on Sender, subject, dates, etc ... )
I need to export some archived items information from several individual archives on a regular shedule, and I'd like to try to automate it
thanks a lot
You can export the items themselves using PowerShell with the Export-EVArchive cmdlet. This has a parameter called -SearchString, which allows you to export the results of a search. You just need to provide your filters (sender, subject, dates, etc.) as a search query using EV Search syntax.
So something like this will get you a PST full of all the items in archive XYZ where the sender is User 1, the subject contains the word "test," and the archived date is after January 1 2019:
Export-EVArchive -ArchiveId xyz -SearchString 'auth:"User 1" AND subj:test AND adat:>01-01-2019' -Format PST -OutputDirectory c:\temp
The only thing I'm not sure about is that you said you want to "export some archived items information." So if you're not looking for the full items but instead just a report with the metadata of the search results, then you're not going to find a built-in PowerShell cmdlet that can do this. (You can actually access this information and build such a report using the EV Search API, which is a SOAP 1.1 compliant web service API that you could call from PowerShell using Invoke-WebRequest if you really wanted to. However, this is not trivial to do, and the documentation is reserved for our VTE partners.)
Hope this helps!
Edit: The smiley face in the code section is a : followed by a >.
It's true that we do record the time in both the database and the index. The trick is in searching on that value using our search syntax. I have tried numerous ways and cannot seem to find a way to issue a query that includes datetime criteria narrower than one day. I'll keep poking at it and see if I can find one, but so far, no luck.