/build/static/layout/Breadcrumb_cap_w.png

Archive report

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
  • All archived assets, regardless of asset type? What details should be included? - chucksteel 5 years ago
  • All archived assets, but it would be nice to be able to select the type of asset and a date range. - tgrinnell 5 years ago
    • Date range for what? When the asset was archived? - chucksteel 5 years ago
      • Yes, for when the asset is archived. - tgrinnell 5 years ago
  • Thank you! I will give it a try. - tgrinnell 5 years ago

Answers (1)

Posted by: chucksteel 5 years ago
Red Belt
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.

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