Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Exchange Online Distribution List Onwership

Trevor L
Tera Expert

Hello all-

 

I currently have a requirement to pull all cloud distribution list owners in from Exchange Online and make those available in the platform to use in catalog items and/or approvals for distribution list management.  In my research into the Exchange Online spoke and Entra ID spoke, neither provide the capability to look up group owners.

 

Has anyone done this before and if so could you point me in the right direction to satisfy this requirement?

 

Thanks community!

1 ACCEPTED SOLUTION

I was unable to find anything to allow a ServiceNow spoke to do this natively.  Our solution was to:

  1. Have our Exchange Admin set up a Azure Runbook to collect the dist list owners and provide the output in JSON.
  2. Configure a flow to run a Azure Automation Run Job action to run the runbook on a recurring basis.
  3. The flow then processes the JSON and updates or adds owner records as needed.

Not the ideal solution, but it did work for our use case to help automate request item flows.

View solution in original post

6 REPLIES 6

Hi @Trevor L ,

 

Could you please provide a detailed solution - such as the steps which were used to create the Azure Runbook, what information will it send and how frequently will it come in ServiceNow. How was the connection and authentication setup?  Also share the details about the custom action which you created to run the runbook on a recurring basis in ServiceNow. And how did the flow look this for this automation to add or update any owner record.

Thank you.

 

Hi @Aartii01,

 

Did you find a solution for this one? How did you achieve this?