09/28/2018 300 views
Does anyone know how to run a Computer Assets Report Based on Asset Status?  When you pick (Report wizard) the type as device asset status filed is missing.  Any help is appreciated

0 Comments   [ + ] Show comments


All Answers

This is probably just a Topic (table) selection problem.  When building your report, be sure to select Asset-HW_Computer.  Next screen, choose the fields to display, obviously choosing Asset Status in your list.  On your last section, Filters, you should see Asset Status as one of the usable criteria for matching.
Answered 09/28/2018 by: worzie
Third Degree Brown Belt

Thank you for your response.  Problem is that when choosing type /table as asset computer there are several fields missing as a choice (anything with the device field).  That's why I am trying to use type/table as the device instead asset computer but if you choose that you get everything except asset status.

Answered 09/28/2018 by: binuani
Third Degree Green Belt

  • There is the Add Subtopic also. I believe you need to have the main topic be the top one if you are filtering by it. They are different tables so one could also use some SQL foo to join them. I never had much luck incorporating subtopics. The report wizard has limitations and quirks.
    • Unfortunately that wouldn't work either because when I add a subtopic.. the results are in 2 separate lines.