EV11 - SQL for archived item info.

[GertjanA]

Hello all,

I am looking for a query which shows the following for a specific day:

From a Journal Archive:

Sender, Subject, Send/Receive date, archived date.

send/receive date being the date when the item was send (modified date?), archived date when the item was archived.

I did find a query which shows this when you have a DA-search for a specific date, but I would like to be able to run a query on the Journal Archive if possible.

Thanks.

GJ

[AndrewB]

are sender and subject stored in sql?