Adding Exchange Online Attributes to Custom Attributes

Question

Hi,

I am looking to build a report whereby all users within a specific OU (Disabled and forwarding). The report will return users who have been inactive for 90 days along with the forwarding address. I'm guessing the easiest way to do this is to assign the forwarding SMTP address in Exchange Online to an adaxes custom attribute. I have seen reference to this being possible in answers to other questions but no instructions as to how to do this. Could someone give me the script to be able to do this please?

Thanks!

Comments

Hello Gareth,

Sorry for the confusion, but we are not sure what exactly you need to achieve. What columns should be present in the report? Do you have a hybrid environment?

Any additional information will be much appreciated.

---

Thanks for the really quick response. So yes, we run a hybrid environment and all forwarding is set through Exchange Online rather than on prem. Is there a way I can run a scheduled task to grab the SMTP forwarding address in Exchange Online and assign it to say, adm-customattributetext1?

---

Hello Gareth,

So yes, we run a hybrid environment and all forwarding is set through Exchange Online rather than on prem.

What exactly do you mean? Do users have the Forward To (LDAP name altRecipient) property populated in on-premises AD?

Is there a way I can run a scheduled task to grab the SMTP forwarding address in Exchange Online and assign it to say, adm-customattributetext1?

Yes, it is possible. We will provide you with a solution having the answer to the above question.

---

Sorry for the confusion. We do not have the altRecipient property populated. Nor do we have the MsExchGenericForwarding attribute populated.

Answer 1

Hello Gareth,

Thank you for the clarification. For information on how to obtain the required data, have a look at the following script sample: https://www.adaxes.com/sdk/SampleScripts.RetrievingMailboxProperties.MailFlow. You can then save the value to an Adaxes custom text attribute (e.g. CustomAttributeText1) and add the corresponding column to the report.

Comments

Thanks for the information, so to add it to the attribute am I right in assuming the script would be this?

$deliveryOptions = $mailboxParams.MailFlowSettings.DeliveryOptions

$forwardTo = $deliveryOptions.ForwardingAddress.DisplayName

if ($forwardTo -ne $null) { adm-customattributetext1 = $forwardTo }

---

Hello,

No, your script will not work. Here is the correct one:

$customAttributeName = "adm-CustomAttributeText1" # TODO: modify me
$pipelined = $True

# Bind to the target user
$user = $Context.BindToObjectByDNEx("%distinguishedName%", $pipelined)

# Get forward to
$mailboxParams = $user.GetMailParameters()
$deliveryOptions = $mailboxParams.MailFlowSettings.DeliveryOptions
$forwardTo = $deliveryOptions.ForwardingAddress.DisplayName

# Update custom attribute
$user.Put($customAttributeName, $forwardTo)
$user.SetInfo()

In the script:

• $customAttributeName – Specifies the LDAP name of the property to be updated with the data from the Forward To option.
• $pipelined – Specifies whether to pass the user update through the Adaxes pipeline to trigger business rules, create log records, etc.