0 votes

Is there a way to tell the last time a distribution list was sent to? I am trying to get our ridiculous number of lists cleaned up a bit, and I figure that is the best place to start. I am assuming the "When Changed" attribute designates the last time the list was updated, not necessarily the last time it was sent to. I know that it is possible to comb through Exchange's tracking logs, but I was hoping for a more elegant solution in Adaxes. :D

Thanks!

by (360 points)
0

Hello,

It seems like it's possible to get Exchange tracking logs through PowerShell and sort the events by date. We've asked our script guys to write a script for you and will update this topic as soon as they come up with something.

0

Any luck with this request? Thank you!

1 Answer

0 votes
by (215k points)

Hello,

Yes, the script is ready. It can be used in a Business Rule, Custom Command or Scheduled Task to find out when a message was las sent to the distribution list, on which the Rule, Command or Task is executed. In the script, $exchangeServer specifies the fully qualified domain name (FQDN) of your Exchange Server. Modify it to match your environment.

$exchangeServer = "exchangeserver.domain.com" # TODO: Modify me

# Get the message tracking log for the distribution list
$session = New-PSSession -connectionURI "http://$exchangeServer/powershell" -ConfigurationName Microsoft.Exchange
Import-PSSession -session $session -AllowClobber -DisableNameChecking

$messageTrackingLog = Get-MessageTrackingLog -Recipients "%mail%" -ResultSize Unlimited | Select-Object sender, timestamp | Sort timestamp -Descending

Remove-PSSession -Session $session

if ($messageTrackingLogt -eq $NULL)
{
    $Context.LogMessage("There were no messages sent to this distribution list", "Information")
    return
}

$sender = $messageTrackingLog[0].Sender
$timeStamp = $messageTrackingLog[0].TimeStamp

$Context.LogMessage("Last message received from '$sender' on '$timeStamp'", "Information")

For your task, you can, for example, create a Custom Command that can be executed on a distribution list to find out the time when the distribution list was last sent to. To create such a Custom Command:

  1. Create a new Custom Command.
  2. On the 2nd step of the Create Custom Command wizard, select the Group object type.
  3. On the 3rd step, add the Run a program or PowerShell script action and paste the above script in the Script field.

Related questions

0 votes
1 answer

Good Day I've found what i want and is this Scripts Repository https://www.adaxes.com/script-repository/output-the-last-time-a-distribution-list-received-mail-s122.htm. Is ... in to a Report with the addition to add one more then one Distribution? Thank you

asked May 11 by Sandberg94 (320 points)
0 votes
1 answer

We are setting up a dashboard for management end users to create distribution lists without IT assistance. We keep receiving the following error.

asked Nov 29, 2018 by willy-wally (3.2k points)
0 votes
0 answers

Hello Supportteam, we have in Sharepoint own distribution list. I want to delete the user from the ditribution list in Sharepoint, after the deprovisioning. Could you please help me in this case? Did not find a script in your repository. Thank you Massimo

asked Nov 8, 2017 by massimo.ibba (450 points)
0 votes
1 answer

Hi! I'd like to enable my HelpDesk to manage DL membership from the Web GUI ... but so far I have found two issues that I hope can be addressed ... Once the group has been ... but I'd like to find a way to remove those options if possible. Thanks. - Scott W.

asked Jun 5, 2014 by hms.scott (220 points)
0 votes
1 answer

Is there a way for Adaxes to report once we are reaching our license limit within Adaxes e.g. when we reach 90% usage to send us an email? (if we have 1000 user license to get an alert when we have used 900)

asked Jul 7, 2020 by peggleg (110 points)
2,779 questions
2,511 answers
6,574 comments
25,621 users