Some times we restore our production database to other development environment, but its a best practice to disable few things first before we run the application. one of the examples is to stop the email/communication templates.
2 tables are handling System Properties in Maximo:
1. SELECT * FROM MAXPROP;
2. SELECT * FROM MAXPROPVALUE;
Below example to find the SMTP host which is used to send emails from Maximo. We can update this property to disable the emails.
SELECT MAXPROP.PROPNAME, MAXPROP.DESCRIPTION, MAXPROPVALUE.PROPVALUE
FROM MAXPROP join MAXPROPVALUE ON MAXPROP.PROPNAME = MAXPROPVALUE.PROPNAME
WHERE MAXPROP.PROPNAME = 'mail.smtp.host'
