Inactive Contacts

%3CLINGO-SUB%20id%3D%22lingo-sub-795693%22%20slang%3D%22en-US%22%3EInactive%20Contacts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795693%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20client%20with%20many%20contacts.%20In%20order%20to%20comply%20with%20GDPR%20and%20not%20retain%20any%20unnecessary%20contacts%20he%20would%20like%20to%20get%20a%20report%20from%20Outlook%20showing%20when%20was%20the%20last%20time%20that%20each%20contact%20was%20sent%20an%20email%20or%20we%20received%20an%20email%20from%20them.%20It%20would%20be%20great%20if%20he%20could%20get%20a%20report%20showing%20all%20of%20the%20contacts%20for%20an%20account%20that%20have%20been%20inactive%20for%20(say)%202%20years%20and%20then%20he%20could%20delete%20them%20if%20he%20wished.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20get%20such%20a%20report%3F%20I%20have%20looked%20at%20a%20commercial%20product%20call%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-795693%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECompliance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796048%22%20slang%3D%22en-US%22%3ERe%3A%20Inactive%20Contacts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796048%22%20slang%3D%22en-US%22%3ENothing%20out%20of%20the%20box%20springs%20to%20mind.%20Perhaps%20a%20powershell%20script%20to%20get%20the%20email%20address%20of%20each%20contact%2C%20then%20search%20the%20mailbox%20for%20any%20items%20where%20that%20email%20address%20is%20the%20To%2C%20Cc%2C%20Bcc%20or%20From%20address%2C%20then%20dump%20the%20creation%20date%20of%20that%20item%20to%20a%20csv.%3CBR%20%2F%3E%3CBR%20%2F%3ENot%20simple%20though%2C%20really.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-796928%22%20slang%3D%22en-US%22%3ERe%3A%20Inactive%20Contacts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-796928%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F506%22%20target%3D%22_blank%22%3E%40Rob%20Ellis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20would%20certainly%20do%20it%2C%20a%20big%20job%20in%20powershell%20though%20I%20would%20have%20thought.%20I%20may%20well%20have%20a%20go%20at%20it%20(one%20for%20the%20long%20winter's%20nights%20I%20think).%20If%20anybody%20has%20any%20bits%20of%20powershell%20that%20might%20help%20please%20let%20me%20know%2C%20it%20might%20help%20me%20piece%20them%20together.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797482%22%20slang%3D%22en-US%22%3ERe%3A%20Inactive%20Contacts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797482%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389364%22%20target%3D%22_blank%22%3E%40NeilB19630519%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20the%20cmdlet%26nbsp%3B%3CFONT%3EGet-MessageTrackingLog%3C%2FFONT%3Eis%20not%20available%20on%20O365%2C%20anybody%20know%20of%20a%20way%20of%20doing%20the%20same%20thing%20in%20O365%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-797952%22%20slang%3D%22en-US%22%3ERe%3A%20Inactive%20Contacts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-797952%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389364%22%20target%3D%22_blank%22%3E%40NeilB19630519%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGet-MessageTrace%20might%20get%20the%20info%20you%20need%20for%20EOL%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fexchange%2Fmail-flow%2Fget-messagetrace%3Fview%3Dexchange-ps%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowershell%2Fmodule%2Fexchange%2Fmail-flow%2Fget-messagetrace%3Fview%3Dexchange-ps%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EMark%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a client with many contacts. In order to comply with GDPR and not retain any unnecessary contacts he would like to get a report from Outlook showing when was the last time that each contact was sent an email or we received an email from them. It would be great if he could get a report showing all of the contacts for an account that have been inactive for (say) 2 years and then he could delete them if he wished. 

Is it possible to get such a report? I have looked at a commercial product call 

4 Replies
Nothing out of the box springs to mind. Perhaps a powershell script to get the email address of each contact, then search the mailbox for any items where that email address is the To, Cc, Bcc or From address, then dump the creation date of that item to a csv.

Not simple though, really.

Thanks @Rob Ellis 

That would certainly do it, a big job in powershell though I would have thought. I may well have a go at it (one for the long winter's nights I think). If anybody has any bits of powershell that might help please let me know, it might help me piece them together.

@NeilB19630519 

Since the cmdlet Get-MessageTrackingLog is not available on O365, anybody know of a way of doing the same thing in O365?