Maximo Open Forum

Hi Geoff, 

Are you looking to implement the relationship in the Preventative Maintenance application? Or are you looking to implement the relationship in the Location or Assets application. 

OOB relationships between the LOCATION, ASSETS, and PM objects exist. Your requirements will help me point you in the right direction if one exists, or build you guidelines to implement it if one does not exist.

Hi thanks for reply

we have a set of PM records assigned to Locations at different levels in a Hierarchy. OOB maximo returns a result using the standard Search Location Hierarchy field found in advanced search

We also have some PM's linked to Assets which are connected to Locations in the same hierarchy

OOB maximo does not return those records when queried using a location Hierarchy.

We don't want to change the asset to location on the PM record but want to view a result set that contains both sets of records with the Search Location Hierarchy function

Thanks

Hi Geoff, 

Are you looking to implement the relationship in the Preventative Maintenance application? Or are you looking to implement the relationship in the Location or Assets application. 

OOB relationships between the LOCATION, ASSETS, and PM objects exist. Your requirements will help me point you in the right direction if one exists, or build you guidelines to implement it if one does not exist.

Hi @Geoff Stokes,

Are you familiar with the Maximo Hierarchy Drilldown activated by System Property mxe.webclient.extendedDrilldown?  The System Property enables an optional, extended drill-down user interface for assets and locations, displaying a single hierarchical view. (Option 1)

Maximo Hierarchy Drilldown (Maven Asset Management) video walks you through the functionality. 

OOB, the PM application's More Search Fields has both Asset and Location Fields. (Option 2)

Lastly, I created the attached query. I included both Location and Asset Hierarchies, including PMNUM, to fetch the data if the UI is insufficient. (Option 3)

SQL Server Validation: To compare 'ASSET' vs. 'LOCATIONS' outputs, change the object in line 299. 

Oracle Validation: 


I acknowledge that these hierarchical queries are difficult to map. These queries are my service back to this community. I acknowledge their need for many ongoing Maximo upgrades. 

Who should I send the invoice to? My humor:😉

Hope the community at large finds them useful. I did not have a DB2 database to test the DB2 Query.

Best, 

Hi thanks for reply

we have a set of PM records assigned to Locations at different levels in a Hierarchy. OOB maximo returns a result using the standard Search Location Hierarchy field found in advanced search

We also have some PM's linked to Assets which are connected to Locations in the same hierarchy

OOB maximo does not return those records when queried using a location Hierarchy.

We don't want to change the asset to location on the PM record but want to view a result set that contains both sets of records with the Search Location Hierarchy function

Thanks

Hi Geoff, 

Are you looking to implement the relationship in the Preventative Maintenance application? Or are you looking to implement the relationship in the Location or Assets application. 

OOB relationships between the LOCATION, ASSETS, and PM objects exist. Your requirements will help me point you in the right direction if one exists, or build you guidelines to implement it if one does not exist.

Hi Geoff, 

Are you looking to implement the relationship in the Preventative Maintenance application? Or are you looking to implement the relationship in the Location or Assets application. 

OOB relationships between the LOCATION, ASSETS, and PM objects exist. Your requirements will help me point you in the right direction if one exists, or build you guidelines to implement it if one does not exist.

@Geoff Stokes - The SQL files did not upload. Please see the TXT versions attached.