Maximo Open Forum

 View Only
  • 1.  WHERE USED - INVENTORY REPORT

    Posted 11-10-2023 11:54

    Hello all, thank you for all of the previous help.

    Is it possible to pull the "Where Used" information from Inventory?  

    I can't find any out-of-the-box options, would I have to update the object structures and database config? or perhaps use a SQL tool?

    Thank you for any ideas


    #Administration
    #Assets
    #Inventory
    #Reporting

    ------------------------------
    Danny Richardson
    Technimark LLC
    ------------------------------


  • 2.  RE: WHERE USED - INVENTORY REPORT

    Posted 11-13-2023 08:49

    A SQL Tool is likely easier, as it is a single object involved: SPAREPART. This provides the data you see in the where used section of the inventory application as well as the spare part section of the asset application. 

    select * from sparepart 



    ------------------------------
    Christopher Winston
    Projetech Inc.
    ------------------------------



  • 3.  RE: WHERE USED - INVENTORY REPORT

    Posted 11-17-2023 17:38

    Thank you @Christopher Winston,  I got connected to the database with an SQL tool today and was able to run this.



    ------------------------------
    Danny Richardson
    ------------------------------



  • 4.  RE: WHERE USED - INVENTORY REPORT

    Posted 14 days ago

    HI @Christopher Winston. Do you happen to have an MxLoader template for this? I'm looking to upload multiple assets under the "Where Used" tab in the Inventory module.



    ------------------------------
    ERICK ROSIL
    GNPK
    ------------------------------



  • 5.  RE: WHERE USED - INVENTORY REPORT
    Best Answer

    Posted 14 days ago
    Edited by Christopher Winston 10 days ago

    MXLoader has had a wizard for a few years now, and that has the Asset spare parts template there. Here is the previous MXLoader Wizardor you can just go to the MXLoader forum here or out to the website and download a fresh copy. 



    ------------------------------
    Christopher Winston
    Naviam
    IBM Champion 2024 and 2025
    ------------------------------



  • 6.  RE: WHERE USED - INVENTORY REPORT

    Posted 10 days ago

    Thank you Chris..  its working. 



    ------------------------------
    ERICK ROSIL
    GNPK
    ------------------------------