Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Where's the Rotating Asset's Work History?

    Posted Mon February 03, 2020 06:15 PM
    So I got my process flow down.  But I thought all the Work Order history would go with the Asset so if Site C gets sent an Asset that was previously installed at Site A, they would be able to pull up all the maintenance/repair history and reports performed at Site A.  But when I view an Asset's Work Details, I can only see Site C's Work Orders.  Because my Asset numbers can change between sites, I can't do a simple search under the Work Order Tracking application by Asset number.  

    Is this working as intended?  Is there a work around?  Or do I have to extract the data to develop a report outside of Maximo that searches Work Orders by an Asset's Serial Number?

    ------------------------------
    Gail Smith
    CMMS Business Process Owner
    Marine Fleet Technical - Chevron
    ------------------------------

    #Maximo
    #AssetandFacilitiesManagement


  • 2.  RE: Where's the Rotating Asset's Work History?

    Posted Tue February 04, 2020 12:21 PM
    Edited by System Admin Wed March 22, 2023 11:51 AM
    Hi Gail,
    Yes, thinking the work history should follow the asset across sites.  workview is being filtered by design in the 'View Work Details'  to the current site.

    ------------------------------
    Richard Hoath
    www.informsolutions.ca

    Original Message


  • 3.  RE: Where's the Rotating Asset's Work History?

    Posted Tue February 04, 2020 02:35 PM

    I just popped on and did the IoT Academy for Asset Management, and it looks like this is how the system was built.  It creates a new history at each Site, making it difficult to pull up a collective Work History for a specific Asset.  But looking at the database, it appears that ASSET.ASSETID remains constant when I move an Asset between Sites, or change the Asset's number.  I'll see if my IT department can display this field under the Asset application and make it a query-able field under Work Order Tracking.  I wish there was built in functionality to view all the WOs under the current active Asset.




    Original Message


  • 4.  RE: Where's the Rotating Asset's Work History?

    Posted Wed February 05, 2020 10:33 AM
    Edited by System Admin Wed March 22, 2023 11:53 AM
    Maximo's flexibility is beautiful: you can often build in what you wish was built in but which didn't come out of the box.

    In this case, I would change the ALLWO relationship on ASSET. Out of the box, its where clause, assetnum = :assetnum and siteid=:siteid, is falling short of what you want to see. So, change it to something like this:

    (assetnum, siteid) in (select assetnum, siteid from asset where assetid = :assetid)

    You can now use App Designer to put a tab+table in the Assets application that will show you all the historical work on that asset, regardless of the site it was at when the work was done.

    ------------------------------
    Blessings,
    Jason Uppenborn
    Sr. Technical Maximo Consultant
    Ontracks Consulting
    ------------------------------

    Original Message


  • 5.  RE: Where's the Rotating Asset's Work History?

    Posted Thu February 06, 2020 10:13 AM
    Nice, thanks!  I passed this on to my IT department as I don't have the access to make these changes.  Will post results soon.

    ------------------------------
    Gail Smith
    CMMS Business Process Owner
    Marine Fleet Technical - Chevron
    ------------------------------

    Original Message


Related Content