How do I get message sizes in Discovery Accelerator

[Leonardo_Fern1]

I've run a number of simple searches using Discovery Accelerator 8.0.3 but I cannot figure out how to get a total size of all the messages I found. In the Review section I see the Size Filter but it only lists the number of messages between certain sizes. How do I get the total size of all the emails the searches returned? Thank you.

[TonySterling · Accepted solution]

That data is not available via the client.  You could use a sql query like this to get CaseId or SearchID


Select CaseId, Name from tblCase
or

Select CaseId, SearchID, Name from tblIntSearches

and then run

SELECT Count(*) as NumOfItems, SUM(Size)TotalSize
FROM tblIntDiscoveredItems
WHERE CASEID = 5

SELECT Count(*) as NumOfItems, SUM(Size)TotalSize
FROM tblIntDiscoveredItems
WHERE SearchID = 13

[Leonardo_Fern1]

Thank you very much. Is the size returned in bytes or kb?

[TonySterling]

I am pretty sure it is bytes, when I get a chance I will have a look at my lab image and verify.