Maximo Open Forum

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

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 

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

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 

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

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

Original Message:
Sent: 11-13-2023 08:49
From: Christopher Winston
Subject: WHERE USED - INVENTORY REPORT

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.

Original Message:
Sent: 11-10-2023 11:54
From: Danny Richardson
Subject: WHERE USED - INVENTORY REPORT

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

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

Original Message:
Sent: 05-05-2025 01:41
From: ERICK ROSIL
Subject: WHERE USED - INVENTORY REPORT

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

Original Message:
Sent: 11-13-2023 08:49
From: Christopher Winston
Subject: WHERE USED - INVENTORY REPORT

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.

Original Message:
Sent: 11-10-2023 11:54
From: Danny Richardson
Subject: WHERE USED - INVENTORY REPORT

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