/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Archive report

08/24/2018 692 views
I am trying to create a custom report that will show me all items that are archived. I don't see any option that allows me to do this. I don't know sql, so I am using the wizard. In addition, is it possible to set assets that have been archived to fall off after a certain amount of time? Thanks!
3 Comments   [ + ] Show comments

Comments

  • All archived assets, regardless of asset type? What details should be included?
  • All archived assets, but it would be nice to be able to select the type of asset and a date range.
    • Date range for what? When the asset was archived?
      • Yes, for when the asset is archived.
  • Thank you! I will give it a try.

All Answers

0
This should work for you:
SELECT ASSET.ID, 
ASSET_TYPE.NAME as "Asset Type", 
ASSET.NAME, 
ASSET.MODIFIED, 
ASSET.CREATED, 
ASSET.ARCHIVE_DATE, 
ASSET.ARCHIVE_REASON
 FROM ORG1.ASSET
LEFT JOIN ASSET_TYPE on ASSET_TYPE.ID = ASSET.ASSET_TYPE_ID
WHERE ARCHIVE = "COMPLETED"
 AND ASSET_TYPE.NAME = "Computer"
 AND DATE(ARCHIVE_DATE) BETWEEN "2017-07-19" AND "2018-04-30"
If you don't want to use the options for asset type or archived date, then just remove those lines.

Answered 09/11/2018 by: chucksteel
Red Belt

 
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