Technical Blog Post
Checking Maximo properties via SQL statement
Maximo has an application called System Properties where you can control and set the values that should be used by any property in the System.
However, in order to see the Current Value of a System Property in Maximo UI, you are required to open each of the property lines and check the values in the fields, which could be very time consuming if you have to do that for multiple properties.
So, I would like to share with you a Select statement that I normally use to display all the current values of System Properties in use by Maximo 7.x :
You should run it on a SQL tool against your Maximo environment :
SELECT MAXPROP.PROPNAME, MAXPROP.DESCRIPTION, MAXPROPVALUE.PROPVALUE
FROM MAXPROP, MAXPROPVALUE WHERE MAXPROP.PROPNAME = MAXPROPVALUE.PROPNAME
ORDER BY PROPNAME;
Hope you enjoy it. Good Luck.