Is there a way to find in use and not in use Mail contacts in MS Exchange O365?

Question

We have requirement to fetch report of active or in use/not in use Mail contacts & Mail users from Exchange admin center and if can get report for last 6 or 3 months active contacts as we need to perform some contact cleanup activity. Is there a way to get it from PowerShell commands/ Exchange reporting....?

Already checked for Get-MessageTrace. So, if there can be an alternative to get active mail contacts details and any PowerShell script available???

Answer 1

I have prepared two PS scripts for you to get last logged in details, one for to get mailusers details and other for mailcontacts details. The csv results can help to decide on your cleanup
First of all connect to the Office 365 tenant

$LiveCred = Get-Credential
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $LiveCred -Authentication Basic -AllowRedirection
Import-PSSession $Session

Run the script one by one (eg: .\mailuser.ps1). Make sure that you have a folder created as temp under C:\

1. Mail Contacts $Result=@() $mailboxes = Get-MailContact -ResultSize Unlimited $totalmbx = $mailboxes.Count $i = 1 $mailboxes | ForEach-Object { $i++ $mbx = $_ $mbs = Get-MailContact -Identity $mbx.UserPrincipalName | Select LastLogonTime if ($mbs.LastLogonTime -eq $null){ $lt = "Never Logged In" }else{ $lt = $mbs.LastLogonTime } $Result += New-Object PSObject -property @{ Name = $mbx.DisplayName UserPrincipalName = $mbx.UserPrincipalName LastLogonTime = $lt } } $Result | Export-CSV "C:\temp\LastLogon-details-contacts.csv" -NoTypeInformation -Encoding UTF8
2. Mail Users $Result=@()
   $mailboxes = Get-MailUser -ResultSize Unlimited
   $totalmbx = $mailboxes.Count
   $i = 1
   $mailboxes | ForEach-Object {
   $i++
   $mbx = $_
   $mbs = Get-MailUser -Identity $mbx.UserPrincipalName | Select LastLogonTime
   if ($mbs.LastLogonTime -eq $null){
   $lt = "Never Logged In"
   }else{
   $lt = $mbs.LastLogonTime }
   $Result += New-Object PSObject -property @{
   Name = $mbx.DisplayName
   UserPrincipalName = $mbx.UserPrincipalName
   LastLogonTime = $lt }
   }
   $Result | Export-CSV "C:\temp\LastLogon-details.csv" -NoTypeInformation -Encoding UTF8

Results are expected to be saved under C:\temp

Answer 2

If your definition of "in-use" is the sending or receiving of e-mail, I think the only way to do this is to use log files (either SMTP or message tracking).

Answer 3

Hi @Learner_27

I agree with the suggestion above, we may consider checking the time of the mails send to the contacts. Like this similar thread discussed: Inactive Contacts

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.

In addition, please note that our forum is for questions and feedback related to Exchange server. Usually, we also help users modify their scripts when they have an issue with it, but we don't support for writing scripts directly. If you have a need for scripts, you could modify/add a tag "office-exchange-server-dev"

And for more information about mail user and mail contacts in Exchange online: Manage mail users in Exchange Online

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.