Thank you @Christopher Winston, I got connected to the database with an SQL tool today and was able to run this.
------------------------------
Danny Richardson
------------------------------
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
------------------------------