I am needing to run a report of all our assets including the ones that have been archived. Is there a way to make a report that will pull archived assets?
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


The ASSET table includes three columns related to archiving:
ARCHIVE - blank for unarchived assets

I'm guessing that if you create a report using the wizard it includes a clause that causes the archived assets to not be present, based on one of these columns. I would recommend that you try creating your report and then viewing the SQL code behind it to check, and then remove the part of the where clause that is removing the archived assets.
Answered 11/28/2017 by: chucksteel
Red Belt

Please log in to comment