/bundles/itninjaweb/img/Breadcrumb_cap_w.png
I would like to run an inventory report that includes "Asset Status", but I do not see it in the Asset Fields drop down list. Does anyone know how to do this?
Answer Summary:
1 Comment   [ + ] Show comment

Comments

  • Which type of asset? Are you using the report wizard?
    • computers. Yes, I am using the report wizard. I'm not good at SQL

Answer Chosen by the Author

0
Why not try setting up a view in your console, get it to show the columns that you want to see, and when you have a view that works for you, select the Choose Action> Create Report option to get the SQL Report (or if not the SQL which you can then finesse to get exactly what you need.
Answered 06/11/2018 by: Hobbsy
Red Belt

  • When I view it in my console, I only see the "asset status" when I look at an individual asset (computer). When I look at the asset listing for computers, asset status is not available.
    • Click the cog to the right and opt to display other columns you should find Asset Status in there as every asset type now has that field?
      • That worked! Thank you so much Hobbsy!

Share