Monday, 5 July 2021

SQL to find the System Properties | Maximo

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'

4 comments:

  1. Excellent article and with lots of information. I really learned a lot here. Do share more like this.
    Latest Website Design Trends
    Current Trends in Website Design

    ReplyDelete
  2. Excellent article for the people who need information about this course.
    Pega Certification
    Pega

    ReplyDelete
  3. Get your IBM C1000-109 exam with the help of Exams4sure. All you need just visit Exams4sure and get your IBM C1000-109 Study Guide Material and follow their rules for better results. For more information please visit us at:

    ReplyDelete
  4. DumpsExpert.com is the right choice for student of IT to pass the exam well and quickly. Download the latest SAA-C02 exam DumpsExpert, practice exams from the member's area, and memorize the Q&A real exam dumps before appearing in the real exam. We provide download access to up-to-date questions, answers Brain dumps in PDF format. If you can’t find your required exam dumps here, then you can request our support team to arrange that SAA-C02 exam dumps for you.

    ReplyDelete