/build/static/layout/Breadcrumb_cap_w.png
01/18/2019 316 views

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 Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

1

I think this is what you're looking for...


FROM ASSET LEFT JOIN ASSET_STATUS ON ASSET_STATUS.ID = ASSET.ASSET_STATUS_ID




Answered 01/18/2019 by: jparkins
Blue Belt

  • That's what I was looking for! Thank you!