Maximo Open Forum

Is that what this article is answering? https://www.ibm.com/docs/en/mfsp/7.6.2?topic=product-database-tables-columns-in

Hi Danny

If you navigate to System Configuration > Platform Configuration > Database configuration within your system and then select the Run Reports option from the more actions menu. You should see  a report called Database Configuration. Type the table name you wish to export in the parameter box and click on submit. This should export all the attributes via BIRT. If you just wanted the ASSET table I would type in =ASSET into the parameter box otherwise you will get all tables with ASSET in the title (ASSETATTRIBUTE, ASSETANCESTOR etc.). If you wanted multiple tables you would need to put in =ASSET,=PERSON for example.

That link you provided was just for the service providers industry solution and not for the whole of Maximo but yes if you took the where clause out and ran the sql query you should get all attributes that way as well.

Hope this helps, Phil

Hi Danny

That internal field help box doesn't show any relationship, it just shows the table and column in the database that field is displaying. Relationships are held in a different table in Maximo , the MAXRELATIONSHIP table. You can view and download them via the Relationships tab when viewing an Object record in the Database Configuration module or view/extract them via SQL using (for example just the ASSET table):

select * from maxrelationship where parent = 'ASSET';

It's important to note the relationships are generally between objects themselves and not the fields directly though the relationship uses specific attributes (columns) to create that relationship. You also have the option of creating an Entity Relationship Diagram (ERD) - IBM link is below on how to do this. This may be what you are looking for, they are used when building customisations or integrations. 

How to Generate an Entity Relationship (ERD) Document for Maximo (ibm.com)

Kind Regards

Phil

If all you want is a list of objects and their attributes, that document you linked gets you close. I'd use an sql tool and run the following to get this information:

select objectname, attributename from maxattribute
order by objectname, attributename;

If you need other information, for example attribute type and length, add those to the query. Something like:

select objectname, attributename, length, maxtype from maxattribute
order by objectname, attributename;

Hope this helps.

You can use MxLoader to achieve that. Here is an example I have on my disk.

@Phil Naylor Thank you so much.  Do I need an SQL tool connected to Maximo to run that query or can I run it directly within Maximo?  I tried copying and pasting that into the Where Clause and it wouldn't work so I don't think I'm doing it right.

We do have an ERD created already, so thank you for that information.

@Bruno Portaluri  I would like to first say, thank you so much sir for such an amazing tool.  It has been a HUGE time saver for tedious, repetitive tasks, and has freed me up to be able to focus on how to better help the company instead of just typing in repeated information hundreds of times.

I was able to recreate the sheet in MX Loader from your image, thank you.  My question would be, is there a way to view the combined relationships like in the picture when it says "Table.Column" for an Object Name like "WORKORDER"?