I’ve received a lot of questions lately about integrating Maximo with Office 365 for email notification purposes. Let’s take a moment to review the steps necessary to configure this for your organization.
Considerations:
You will need to provide Maximo with a set of credentials that it will use as the “from” email address. All email coming from Maximo will need to utilize this address (more on that below). For the purposes of this tutorial, we are going to assume this configuration.
Alternatively, you can configure a proxy in Office 365 to effectively create a mail relay situation. For example, you might configure a “donotreply@organization.com” address that can be used as the “from” email address that does not need to supply authenticated credentials.
IBM WebSphere Configuration
Office 365 works over SSL. In order for WebSphere to make a proper SSL connection to Office 365, we need to import the Office 365 SSL certificate into WebSphere’s trust store. This will make the connection trusted from WebSphere’s perspective and allow the connection to happen. WebSphere will throw an error if it attempts to make a connection to an untrusted source.
Log into the WebSphere Console as an administrative user.
Navigate to the Security > SSL certificate and key management screen.
Click on the Key stores and certificates link.
Click on the CellDefaultTrustStore link.
Click on the Signer certificates link.
Click on the Retrieve from port button.
Fill out the following required fields:
Host: outlook.office365.com
Port: 993
Alias: outlook.office365.com
Click the Retrieve signer information button.
Click the OK button.
Click the Save to master configuration link.
Once the node synchronization happens, log out of the WebSphere Console.
For this change to take effect, the IBM-related Windows Services will need to be restarted (all Node Agents, the Cell Manager, and the HTTP Server).
Maximo System Properties
The next step is to configure System Properties within Maximo.
Log into Maximo as an administrative user.
Navigate to the System Configuration > Platform Configuration > System Properties application.
Set the mail.smtp.host property to smtp.office365.com
Set the mail.smtp.starttls.enable property to true
Set the mail.smtp.ssl.enable property to false if it is not already false (default is false)
Set the mxe.smtp.user property to the email address you wish all Maximo email notifications to come from (e.g. alex@a3jgroup.com).
Set the mxe.smtp.password property to the Office 365 password for the above user. Please note that it’s also a good idea to check the Masked? checkbox for this property in order to keep the password value hidden in the Maximo user interface.
Click the New Row button to create a new System Property. Fill out the following fields:
Property Name: mail.smtp.port
Description: Port number that the SMTP mail server listens on
Global Value: 587
Click the Save button.
Check the box next to each of the properties above that you had to edit. Then in the Common Actions menu, click the Live Refresh button.
Click the OK button.
Maximo Communication Templates
Each of the Communication Templates in the system must now have the Send From email address set to the same email address that was used to populate the mxe.smtp.user System Property.
Maximo Scheduled Reports
You may want to schedule reports to run from Maximo to be emailed to users or groups. Like all other email, the Send From address has to be the value that you configured in the mxe.smtp.user System Property. Unfortunately when Maximo schedules a report to be emailed, it uses the email address from the user that created the report schedule as the Send From address. This will cause most scheduled reports to fail.
The least intrusive solution that I’ve come up with is to create a user that has the same email address that was used to populate the mxe.smtp.user System Property, and then create an automation script to change the user at runtime of the scheduled report. This will allow the system to send scheduled reports via email.
Ensure that you have a user account that has the same email address that was used to populate the mxe.smtp.user System Property.
Navigate to the System Configuration > Platform Configuration > Automation Scripts application.
From the More Actions menu, choose the Create > Script with Object Launch Point option.
In the ensuing dialog, Create Script with Object Launch Point: Step 1 of 3, fill out the following fields:
Launch Point: REPORTRUNQUEUE_LP
Description: Report Run Queue Launch Point
Object: REPORTRUNQUEUE
Active: Yes
Events: Save
Save: Add and Before Save (see screenshot)
Script: New
Click the Next button.
In the next step, Create Script with Object Launch Point: Step 2 of 3, fill out the following fields:
Script: REPORTRUNQUEUE_SCRIPT
Description: Report Run Queue Script
Script Language: python
Click the Next button.
In the next step, Create Script with Object Launch Point: Step 3 of 3, fill out the following fields:
Source Code:
from psdi.mbo import MboConstants mbo.setValue("USERID", "AWALTER", MboConstants.NOACCESSCHECK)
Be sure to substitute the User ID of your user for the AWALTER text in the example above. Click the Create button and you’re set!
That should enable you to utilize Office 365 as your email solution from Maximo. Please feel free to leave comments below.
Alex Walter is the Chief Innovation Officer at the A3J Group, a company he formed to address the need for innovative software solutions and integrated consulting services within the EAM industry. Alex brings 17 plus years of experience in business consulting in various industries including Life Sciences, Oil and Gas, Water and Waste Management, Education, Government Facilities, among others.
Alex lives in Tampa, FL with his wife, two sons, and dogs. In his free time, he enjoys running half marathons, making space in his garage for new camping and outdoor equipment, traveling to far off places with the Walter Circus, and remaining hopeful that his NY Jets' best days are ahead of them and not behind.
8 Thoughts on “Maximo email with Office 365”
You are the man!!!! Thanks a million.. I was trying to do an SMTP Mail server on my host and relay through office365 with little to no success. This is perfect and much easier.
Curious — are you able to take advantage of the email groups and group lists setup in Office 365 from within Maximo to prevent duplicative list updating and administration?
Keep in mind that the office 365 server could use at least 2 different certificates (one using GlobalSign and the other one using Digicert) and WAS needs both of them, otherwise some emails won’t be sent.
This could be done by repeating the same actions in the Admin console until the server responds with the 2 certificates.
I have imported the Office 365 SSL certificate into WebSphere’s trust store. When I click Retrieve signer information, it show GlobalSign certificate. So, how I can retrieve also the Digicert certificate? Is that the reason why I’m not getting any email notification for work orders?
I have imported the Office 365 SSL certificate into WebSphere’s trust store. When I click Retrieve signer information, it show GlobalSign certificate. So, how I can retrieve also the Digicert certificate? Is that the reason why I’m not getting any email notification for work orders?
I have imported the Office 365 SSL certificate into WebSphere’s trust store. When I click Retrieve signer information, it show GlobalSign certificate. So, how I can retrieve also the Digicert certificate? Is that the reason why I’m not getting any email notification for work orders?
MxApprove End User License Agreement
If you agree to the terms of this MxApprove End User License Agreement (the “License Agreement”), click the Accept License Agreement button after reviewing the contents of this License Agreement to proceed with accessing the MxApprove (the “Application”). IF YOU DO NOT AGREE TO THE TERMS OF THE THIS LICENSE AGREEMENT, YOU WILL NOT HAVE ACCESS TO THE APPLICATION.
This is a license agreement between you, as the licensee and A3J Group LLC, a Delaware limited liability company, (“A3J”), its successors and assigns, its affiliated companies, and its authorized distributors and resellers as the licensor. This is not a contract for sale of the Application, but a license to use the Application subject to the terms and conditions of this License Agreement. Please read the terms carefully. You and A3J agree as follows:
Application.
The Application is the property of A3J. The term Application includes any related documentation, updates and permitted copies of the Application licensed to you by A3J. A3J expressly reserves all rights not expressly granted you.
Scope of License.
Upon your acceptance of the terms contained in this License Agreement, A3J grants you a nonexclusive, nontransferable, limited right to use the Application for personal or business use on the Licensed Devices, as defined below. The term "Use" means to install and access the Application in conjunction with the Application’s related and compatible software.
“Primary Device” shall mean the mobile device, tablet or other device compatible with applications owned or controlled by you, on which you download and install the Application and agree to be bound by the terms of this License Agreement and any other agreement associated with the Application. “Licensed Devices” shall mean the Primary Device and any other device that synchs or otherwise shares the same cloud or backup identification as the Primary Device.
This License Agreement does not allow you to use the Application on any device that you do not own or control. You may not distribute or make the Application available over a network where it could be used by multiple devices at the same time. You may not rent, lease, lend, sell, redistribute or sublicense the Application. You may not assign any right granted under this License Agreement without A3J’s prior written consent. You may not copy the Application. YOU AGREE THAT YOU WILL NOT MODIFY, ADAPT, TRANSLATE, ALTER NOR CREATE DERIVATIVE WORKS OF THE APPLICATION. YOU FURTHER AGREE THAT YOU WILL NOT REVERSE ENGINEER, DECOMPILE, DECRYPT, DISASSEMBLE, NOR SEEK TO DISCOVER THE SOURCE CODE OF THE APPLICATION OR ANY UPDATES ASSOCIATED THEREWITH. IF THE APPLICATION CONTAINS EMBEDDING BITS THAT LIMIT THE CAPABILITIES OF THE APPLICATION, YOU MAY NOT CHANGE OR ALTER THE EMBEDDING BITS.
Embedding of the Application is prohibited. You may NOT otherwise embed the Application. For example and without limitation: (i) You may NOT embed the Application into your hardware, software or other products, such as, application programs, electronic games, e-books, kiosks, printers, etc.; (ii) You may NOT embed the Application into your web pages; and (iii) You may NOT embed the Application into electronic commercial documents. This means that the Application may not be embedded or otherwise used in non-static files that may be accessed by computers or other devices that are NOT Licensed Devices.
A breach of these restrictions may subject you to prosecution and damages, including but not limited equitable relief in the form of an injunction.
Any updates or supplements to the Application will be governed by this License Agreement, unless a separate license agreement accompanies the update or supplement.
Intellectual Property Rights.
The Application, and any trademark, copyrights, patents, or any rights associated with the same, are the intellectual property of A3J. A3J reserves all of its rights under applicable laws. You acknowledge that the structure, organization and code of the Application are valuable trade secrets and confidential information of A3J and you shall not use this proprietary content, information or materials in any way except as expressly permitted under this License Agreement.
No Other Use.
You are granted only the rights expressly stated in this Agreement, and you may not use the Application for any other use or purpose. In addition to other prohibited uses described in this Agreement and without limitation, the following uses are specifically prohibited: (i) You may not share the Application with other individuals or business entities; (ii) You may not use the Application on more than the permitted Licensed Devices; (iii) You may not change the name of the Application; (iv) You may not translate the Application into other platforms.
Consent to Use Data.
A3J may collect and use technical data and related information, including but not limited to technical information about your device, system and application software gathered periodically to facilitate the provision of software updates, product support and other services related to the Application. A3J may use this information, provided this use does not personally identify you, to modify or further develop the Application and/or provide additional technologies to you.
Termination.
The license rights granted under this License Agreement are effective until terminated by you or A3J. Your rights under this License Agreement will terminate automatically without notice from A3J if you fail to comply with any of the term(s) of this License Agreement. Upon termination of the license, you shall cease all use of the Application, and destroy all copies, if any, full or partial, of the Application.
No Warranty.
YOU EXPRESSLY ACKNOWLEDGE AND AGREE THAT USE OF THE LICENSED APPLICATION IS AT YOUR SOLE RISK. TO THE EXTENT PERMITTED BY LAW, THE APPLICATION IS PROVIDED “AS-IS” AND “AS AVAILABLE,” WITH ALL FAULTS AND WITHOUT WARRANTY OF ANY KIND. A3J DOES NOT AND CANNOT WARRANT THE PERFORMANCE OR RESULTS YOU MAY OBTAIN BY USING THE APPLICATION. A3J MAKES NO WARRANTIES, CONDITIONS, REPRESENTATIONS OR TERMS, EXPRESS OR IMPLIED, WHETHER BY STATUTE, COMMON LAW, CUSTOM, USAGE OR OTHERWISE AS TO OTHER MATTERS, INCLUDING WITHOUT LIMITATION, NON INFRINGEMENT OF THIRD PARTY RIGHTS, TITLE, INTEGRATION, SATISFACTORY QUALITY, MERCHANTABILITY OR FITNESS FOR ANY PARTICULAR PURPOSE. FURTHER, A3J MAKES NO WARRANTIES AGAINST INTERFERENCE WITH YOUR ENJOYMENT OF THE APPLICATION OR THAT THE APPLICATION WILL MEET YOUR REQUIREMENTS, THAT THE OPERATION AND USE OF THE APPLICATION WILL BE UNINTERRUPTED OR ERROR-FREE OR THAT DEFECTS IN THE APPLICATION WILL BE CORRECTED. IN THE EVENT THE APPLICATION PROVES DEFECTIVE, YOU ASSUME THE ENTIRE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. SOME JURISDICTIONS DO NOT ALLOW THE EXCLUSION OF IMPLIED WARRANTIES OR LIMITATIONS PLACED ON STATUTORY RIGHTS, SO THE ABOVE LIMITATIONS MAY NOT APPLY TO YOU.
Damage Limitations.
TO THE EXTENT NOT PROHIBITED BY LAW, IN NO EVENT SHALL A3J BE LIABLE FOR PERSONAL INJURY, OR ANY INCIDENTAL, SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES WHATSOEVER, INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, LOSS OF DATA, BUSINESS INTERRUPTION OR ANY OTHER COMMERCIAL DAMAGES OR LOSSES, ARISING OUT OF OR RELATED TO YOUR USE OR INABILITY TO USE THE APPLICATION, HOWEVER CAUSED, REGARDLESS OF THE THEORY OF LIABILITY (CONTRACT, TORT OR OTHERWISE) AND EVEN IF A3J HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. In no event shall A3J’s cumulative liability for any loss or damage to you (other than as may be required by applicable law in cases involving personal injury) exceed the amount of fifty dollars (US$50.00). The foregoing limitations will apply even if the above-stated remedy fails of its essential purpose.
No Export or Re-Export.
You may not use or otherwise export or “re-export” the Application. Specifically, and without limitation, you may not export or re-export the Application into (a) U.S. embargoed countries or (b) to anyone on the U.S. Treasury Department’s list of Specially Designated Nationals or the U.S. Department of Commerce Denied Person’s List or Entity List. By downloading and installing the Application and agreeing to the terms of this License Agreement you represent and warrant that you are not located in such a country or a person or entity on any such list. You further warrant and represent that you will not use the Application for any purpose prohibited by the laws of the United States.
Governing Law.
This Agreement is governed by the laws of the State of Florida, United States of America, excluding conflict of laws provisions and excluding the United Nations Convention on Contracts for the International Sale of Goods. You expressly agree that any disputes related to this Agreement will be resolved in the Circuit Court of Hillsborough County, Florida, U.S.A., or the United States District Court for the Middle District of Florida, U.S.A. Both you and A3J consent to the personal jurisdiction and venue of those courts. If any part of this Agreement is found void and unenforceable the balance of the Agreement will remain valid and enforceable according to its terms.
This License Agreement represents the entire agreement between you and A3J in connection with its subject matter. This License Agreement may only be modified by A3J in a writing that expressly states that the writing is intended to modify this License Agreement.
Contacting A3J.
A3J has a mailing address of 3225 S. MacDill Avenue, Tampa, Florida 33629, U.S.A. All support requests, completed registrations and other inquiries should be sent via e-mail to info@a3jgroup.com.
You are the man!!!! Thanks a million.. I was trying to do an SMTP Mail server on my host and relay through office365 with little to no success. This is perfect and much easier.
Glad to hear it. Thanks!
Curious — are you able to take advantage of the email groups and group lists setup in Office 365 from within Maximo to prevent duplicative list updating and administration?
Keep in mind that the office 365 server could use at least 2 different certificates (one using GlobalSign and the other one using Digicert) and WAS needs both of them, otherwise some emails won’t be sent.
This could be done by repeating the same actions in the Admin console until the server responds with the 2 certificates.
Good tip!
I have imported the Office 365 SSL certificate into WebSphere’s trust store. When I click Retrieve signer information, it show GlobalSign certificate. So, how I can retrieve also the Digicert certificate? Is that the reason why I’m not getting any email notification for work orders?
I have imported the Office 365 SSL certificate into WebSphere’s trust store. When I click Retrieve signer information, it show GlobalSign certificate. So, how I can retrieve also the Digicert certificate? Is that the reason why I’m not getting any email notification for work orders?
I have imported the Office 365 SSL certificate into WebSphere’s trust store. When I click Retrieve signer information, it show GlobalSign certificate. So, how I can retrieve also the Digicert certificate? Is that the reason why I’m not getting any email notification for work orders?