size

2 Topics

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
8 years ago Place Enterprise Vault
1.6KViews
0likes
4Comments
EV 11.0.1 EV Search - Strange behavior with large files
Hi, we have a strange behavior with the EV 11.0.1 Search. There're archived files with a size 4GB and more. If the file is 4,05 GB big in the EV Search the size displays about 50 MB. Is there a limitation of the used filetyp? Is there a workaround from veritas to fix it or an offical statement why files over 4 GB not displayed correctly? Thanks for your reply and kind regards. :smileyhappy:
haeussler
9 years ago Place Enterprise Vault
1KViews
0likes
1Comment