Report on assets becoming Eligible for Refresh

[alhicks]

Our assets team needs the ability to report on items that will become eligible for refresh in advance in the following ways.

• Items that will become eligible for refresh in a specific month
  • Example: Feb. 2025, March 2025 etc.
• Items that will become eligible for refresh in a specific year
  • Example: 2025, 2026 etc.
• Eligibility for refresh is calculated in the system by comparing the date in the Installed field, on the asset record, to the value in the Useful Life field on the hardware model.

This is to support both resource and budget forecasting processes.

 I found this when googling the question but I'm not seeing a way in reporting to actually get this information.

To report on when an asset will become eligible for refresh:

• Query based on calculation:

  Create a ServiceNow report that calculates the "End of Useful Life Date" by adding the "Useful Life" (from the model record) to the "Install Date" (from the asset record).
• Filter for nearing end of life:

  Use filters in your report to identify assets where the calculated "End of Useful Life Date" is within a specific timeframe (e.g., next 6 months).

[Abhishek Varma]

The HAM dashboard auto populates this data in a report format. no need to create any additonal reports. 

the asset.

In service catalog, add asset lifecyle module and in that you can view 

Hardware Asset Refresh Order  this will give you the option to order assets which are nearing end of life