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?1.8KViews0likes6CommentsSQL - 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, MikeSolved1.6KViews0likes4Comments