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
    ------------------------------