IBM Support

Changes to Description fields on ticket or workorder related objects

Technical Blog Post


Abstract

Changes to Description fields on ticket or workorder related objects

Body

Maximo allows us to configure database and manage the object/tables the way our business processes requires.

 

Most users need to apply changes to workorder related objects, however the workorder and ticket records are not used in a single application in Maximo and we have other tables that may be affected with some change. 

 

You may need to increase the length of a Description field of a workorder, but you want that change to be reflected in all workorder/tickets tables/objects.

 

So, how do we know what list of tables/objects are related to the ones that my workorders and tickets belong to?

 

There is not a specific list of tables, however you can get a list of the tables related to both WORKORDER and TICKET services by running the following SQL in your database.

 

SELECT MAXOBJECT.OBJECTNAME FROM MAXOBJECT WHERE MAXOBJECT.SERVICENAME IN ('WORKORDER','TICKET') 
AND MAXOBJECT.OBJECTNAME IN (SELECT MAXATTRIBUTE.OBJECTNAME FROM MAXATTRIBUTE WHERE ATTRIBUTENAME = 'DESCRIPTION')
ORDER BY OBJECTNAME;

 

That will result in all Maximo objects that belong to the WORKORDER or TICKET services and have a field called DESCRIPTION on their structure. 

 

If you would like to prevent issues,  I would make sure that the length info for all of them match before running any configuration or data generation process.

 

 

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

ibm11112661