/build/static/layout/Breadcrumb_cap_w.png
08/24/2018 161 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

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