Running reports on devices... Where can you link the new Asset status to the assets?
I'm trying to run a report based on the new Asset status that was added to the SMA back a year or so ago. I am finding that I can't see Asset Status under the device search. Does anyone know the link in SQL that will link the tables together so I can write the correct report and get some pertinent information? I would like to be able to delete the old Asset status that I added back when I started tracking assets, but it seems that I may not be able to for a while.
Any help is appreciated.
Answer Chosen by the Author
I think this is what you're looking for...
FROM ASSET LEFT JOIN ASSET_STATUS ON ASSET_STATUS.ID = ASSET.ASSET_STATUS_ID