/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


KACE report including archive

11/27/2017 1119 views
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


All 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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ