Archives

5 Topics

Archive status reported as STS_AVAILABLE when all EV services are stopped
When querying the archive status through the API, the status is being reported as STS_AVAILABLE even though all EV services on the underlying server are stopped. Attempting to insert an item into the archive when the services are stopped results in "Enterprise Vault is not running". Is there an amount of time that has to pass before the status will be reported as STS_UNAVAILABLE? Or is there a seperate process that has to take place for this status to change? Is the IArchive::Status field the correct field to retrieve in order to check if an archive is available for manually inserting items?
Frank_Perrone
5 years ago Place Enterprise Vault
1.8KViews
0likes
6Comments
SMTP archives permission
Hi! Is there a way to give specific permissions on all SMTP archives at once to a particular user? I know there's EVPM for Exchange and Domino archives, and I need the same for SMTP. Doing archives one by one takes ages. Thanks a lot!
Choucroute
6 years ago Place Enterprise Vault
1.4KViews
0likes
5Comments
SQL - query multiple archive-databases
Hi all I'm a bloody beginner with sql-code. What I want to know is to the amount of archived data for last night (22:00-06:00) and the night before. Both for two different archives. My code is the following: (SELECT "date" = '2018-02-17', "MB mailarch1" = sum (originalsize)/1024/1024,"MB mailarch2"='' from EVVSVSArchiveMail1.dbo.Saveset with (nolock) inner join EVVSVSArchiveMail1.dbo.savesetproperty with (nolock) ON saveset.savesetidentity = savesetproperty.savesetidentity WHERE archiveddate > '2018-02-17 20:00' and archiveddate < '2018-02-18 06:00' union SELECT "date" = '2018-02-18',"MB (orig) mailarch1" = sum (originalsize)/1024/1024,"MB (orig) mailarch2"='' from EVVSVSArchiveMail1.dbo.Saveset with (nolock) inner join EVVSVSArchiveMail1.dbo.savesetproperty with (nolock) ON saveset.savesetidentity = savesetproperty.savesetidentity WHERE archiveddate > '2018-02-18 20:00' and archiveddate < '2018-02-19 06:00') UNION ALL (SELECT "date" = '2018-02-17',"MB (orig) mailarch1"='',"MB mailarch2" = sum (originalsize)/1024/1024 from EVVSVSArchiveMail2.dbo.saveset with (nolock) inner join EVVSVSArchiveMail2.dbo.savesetproperty with (nolock) ON saveset.savesetidentity = savesetproperty.savesetidentity WHERE archiveddate > '2018-02-17 20:00' and archiveddate < '2018-02-18 06:00' union SELECT "date" = '2018-02-18',"MB (orig) mailarch1"='',"MB mailarch2" = sum (originalsize)/1024/1024 from EVVSVSArchiveMail2.dbo.saveset with (nolock) inner join EVVSVSArchiveMail2.dbo.savesetproperty with (nolock) ON saveset.savesetidentity = savesetproperty.savesetidentity WHERE archiveddate > '2018-02-18 20:00' and archiveddate < '2018-02-19 06:00') The output I want is a table like: date MB mailarchive1 MB mailarchive2 2018-02-17 8556 9234 2018-02-18 9432 9834 I am sure there is a much more elegant and straightforward query, but I am not able to improve it. Has anyone of you scripted a similar thing and could let me know? Thanks a lot, Mike
Solved
dummyscripter
7 years ago Place Enterprise Vault
1.6KViews
0likes
4Comments
Calling all SharePoint Administrators!
Are You a SharePoint Administrator? If your answer is yes, let’s chat. I’m collecting research so I can better understand what you do on a daily basis for SharePoint administration.
RMossi
12 years ago Place Enterprise Data Services Community Blog
818Views
7likes
4Comments
Shared Archives
One of the things that Enterprise Vault allows you to create is Shared Archives. These don't have a mailbox associated with them, and don't have a folder structure, ie they are "flat" or "unstructured" (some people will remember this was the case in the early days of EV with mailbox archives).
Rob_Wilcox1
15 years ago Place Enterprise Data Services Community Blog
166Views
1like
0Comments