For Activities, check the ActivityParty - that will show who was attached to an email - (the contact may be attached multiple times/ways - as a sender/recepient/cc/bcc etc.) (you can extend this to pick up the other entity types you need to report on.
select distinct
top 10
c.contactid,
c.fullname,
Party.ParticipationtypemaskName,
Pointer.ActivityTypeCodeName,
Email.Subject
from FilteredContact c
Left Join FilteredActivityParty Party
on Party.PartyId = c.ContactId
Join FilteredActivityPointer Pointer
On Party.ActivityId = Pointer.ActivityId
Left Join FilteredEmail Email
on Email.ActivityId = Party.ActivityId
and for the Marketing lists - its the lists and listmembers you're looking for
select distinct
top 10
c.contactid,
c.fullname,
List.ListName
from FilteredContact c
Left Outer Join FilteredListMember Member
on Member.entityid = c.contactid
Join FilteredList List
On Member.ListId = List.ListId
order by fullname
Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
