/build/static/layout/Breadcrumb_cap_w.png

Best Practices Question


Running reports on devices... Where can you link the new Asset status to the assets?

01/18/2019 532 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!

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ