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).

[Saaniya Chugh]

"Eligible for Refresh" is a field was introduced to support a new functionality in asset management, where we can know the expected life of a hardware model. Once that life has reached it's limit on a specific asset, this flag will identify the asset as eligible for refresh. 

There is a schedule job "SAM - Calculate Asset Refresh Eligibility" that runs weekly:

https://<instancename>.service-now.com/nav_to.do?uri=sysauto_script.do?sys_id=625c3df3739800109a1136366bf6a7d7 

This scheduled job calls the "process" method in "SAMRefreshEligibityCalculator" script include: 

https://<instancename>.service-now.com/nav_to.do?uri=sys_script_include.do?sys_id=ec1751fcd1510010fa...

Here what the script does, it fetches the hardware product model record for that asset, and looks at its "useful_life" field. Then it compares the "created on" date of the asset, and determines if the asset is still in the useful life period. In case it is not, it will mark the "Eligible for refresh" field to true. 

Source - Asset Management: "Eligible for refresh" field on alm_hardware records 

[alhicks]

Thank you.  Is there a way to actually report on when that flag may be checked?

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.