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

Comments

Please log in to comment

Answers

0
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
Answered 02/04/2015 by: Hobbsy
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity