IBM Support

Checking Maximo properties via SQL statement

Technical Blog Post


Abstract

Checking Maximo properties via SQL statement

Body

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.

 

See ya.

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11112529