Looking for a report that show devices in assets but not in inventory.
Hi,
I am looking for a report that show devices in assets but not in inventory. Can someone send me that report?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
Hobbsy
9 years ago
The key value that you are looking for in a report is in the Asset table, ASSET.MAPPED_ID if that field is = 0 then there is no inventory item attached.
something like:
SELECT ASSET.ID AS ASSET_ID, ASSET.MAPPED_ID AS MAPPED_ID, ASSET.NAME AS ASSET_NAME FROM ASSET_DATA_5 LEFT JOIN ASSET ON ASSET_DATA_5.ID = ASSET.ASSET_DATA_ID AND ASSET.ASSET_TYPE_ID=5 WHERE ((ASSET.MAPPED_ID = '0')) ORDER BY ASSET_ID
