/build/static/layout/Breadcrumb_cap_w.png

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.


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: jparkins 5 years ago
Second Degree Blue Belt
1

Top Answer

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


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





Comments:
  • That's what I was looking for! Thank you! - zgillette 5 years ago

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