KACE report including archive
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
6 years ago
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.
