IBM Support

Is this a System, Set, Organization or Site level record?

Technical Blog Post


Abstract

Is this a System, Set, Organization or Site level record?

Body

Sometimes you are working with records in Maximo and you are not aware whether Maximo requires to associate a SITEID information or ORGID information, thus you get confused and would like to know what records in Maximo are considered to be level specific.

 

For example, you have in a work order an asset record associated, which is a site-level record, and at the same time there is a job plan associated, which is a system-level record. Finally the work order record is a site-level record.  

So... how do you get a list or information about the level to which the specific object applies ?    We will share two ways to get that information.

 

First, you have the option to go to the Database Configuration app in Maximo and search for the parent table of the type of record you are working with.

 

If you want to know about ITEM table, make sure the ITEM object in select in the main tab of the Database Configuration and check the value of the field called Level.  (That's a SET level record)

 

Second way is to run a SQL query through the backend using a SQL Tool against your Maximo database.  

 

Your query should look like this :
SELECT OBJECTNAME, DESCRIPTION, SITEORGTYPE FROM MAXOBJECT WHERE OBJECTNAME = 'ITEM'    (for this example, ITEM)

 

For a list of all objects, use this query :
SELECT OBJECTNAME, DESCRIPTION, SITEORGTYPE FROM MAXOBJECT ORDER BY OBJECTNAME

 

Thanks and regards...

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

UID

ibm11112901