Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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?