Maximo

Maximo

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

 View Only

  • 1.  Tracking Asset Replacement

    Posted 03/17/22 09:57 AM
    For a given equipment item, we would like to identify the item that it replaced, which is presumably now either decommissioned or operating in a different location. This seems like a question others might have asked before, but I'm apparently not using the right search terms. Can someone point me in the right direction? Thank you.

    ------------------------------
    Robert Goff
    ------------------------------

    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: Tracking Asset Replacement

    Posted 03/18/22 11:06 AM
    Hi Robert,

    Not yet sure if there is an answer, but can you explain how the replacement transpired?  For example, was it via an Asset Swap?

    ------------------------------
    Steve Hauptman
    ------------------------------



  • 3.  RE: Tracking Asset Replacement

    Posted 03/18/22 04:26 PM

    Sounds to me like a Rotating Item –

     

     

     




    Original Message


  • 4.  RE: Tracking Asset Replacement

    Posted 03/22/22 03:08 AM
    Hi Robert,

    We had a similar use case that was achieved using the Asset Swap functionality (also mentioned by Steve below). We had a Staging / Holding location created, which was used for both commissioning and decommissioning of assets. After the equipment were procured, it was stored in a staging bay and created as a Holding Location in Maximo. So for asset replacement, you can swap the assets between the holding and the operating location, then decommission the asset from the holding location using your decommissioning process.

    You can use the same use case for Rotables too, but this will not work if you are replacing it with something in the storeroom. You will have to introduce a staging location.

    Thanks,
    Ankit

    ------------------------------
    Ankit Biswas
    Senior Functional Consultant
    Certus Solutions Ltd.
    Auckland, NZ
    ------------------------------



  • 5.  RE: Tracking Asset Replacement

    Posted 03/23/22 09:33 AM
    Ah, I think I get it. If I had a holding location that was used only for replacements, I could identify an asset swap transaction by the in/out pair in that location. This is a good start, thank you all.

    ------------------------------
    Robert Goff
    ------------------------------

    Original Message


  • 6.  RE: Tracking Asset Replacement

    Posted 03/23/22 05:24 PM
    It the "item" is an Asset, then you will find data in the ASSETTRANS object in the DB. Since you know the current asset and the location, you can find the immediate predecessor in the ASSETTRANS object (sorting on datemoved.)  Using DB2 SQL against MAXDEMO DB here is what I believe will get you close to what you want:
    with cat (assetnum, datemoved, fromparent, fromloc, toloc) as
(Select fat.assetnum, fat.datemoved, fat.fromparent, fat.fromloc, fat.toloc 
from assettrans fat
where fat.toloc = 'BR450'
union all
select tat.assetnum, tat.datemoved, tat.fromparent, tat.fromloc, tat.toloc
from assettrans tat
where tat.fromloc = 'BR450'
) 
select * from cat
order by cat.datemoved

    You output might look like this then:


    I threw this together pretty quick.  You may want to play with the fromloc and toloc attributes to see what yields the best info (this is not a formal self-join so, the "from" and "to" get kind confusing.)   I tested this without actually making any changes (as the dates can attest! Ha!) but I think this is close.  If not, I hope it will help you get started down the right road.  You could easily use the BIRT reporting capabilities to build a report to allow you to input the location as a parameter.

    Hope this helps

    ------------------------------
    Bradley K. Downing , MBA
    Solutions Engineer
    IBM
    Bakersfield CA
    ------------------------------



Related Content