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   [ + ] Show Comments

Comments

Please log in to comment

Answers

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

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
Answer this question or Comment on this question for clarity

Share