physical age of device report
It would be nice to have a report that would show us the physical age of a device, this would allow us to be able to state to a Customers/Client. That because your machine is X years old, we recommend upgrading or even replacing the device, because we are finding a trend that the older a device is the more tickets that device generates. Also a faulty machine that is always generating tickets is not good for the customer's work flow.
Connor Giles
shared this idea
Hi,
Good news: you can build this report today.
Analytical Reports in Atera support custom table calculations, so you can calculate device age from the BIOS release date field and add it as a column to any device report.
Available on Power and Superpower plans (MSP) and Master and Enterprise plans (IT departments).
A full how-to is in the most recent comment on this thread.
++
Dima L
Technical Product Marketing Manager
Atera
-
Hi everyone, you can calculate it today ;)
Analytical reports custom expressions are built exactly for use cases like yours:
To calculate device age directly in your report, open the Devices Explore and build your report as usual - add agent name, customer name, and the BIOS release date field. Once the report runs, look for the gear icon or the table calculation option in the results toolbar and click Edit Calculation (or Add Calculation, depending on your view).
In the formula editor, paste one of the following expressions:
Age in days:
diff_days(${agents_hardware.bios_release_date}, now())Age in years (two decimals ):
round(diff_days(${agents_hardware.bios_release_date}, now()) / 365.25, 2)Give the calculation a name - "Device Age (Days)" or "Device Age (Years)" - then click Save. The column appears in your results table next to the BIOS date. Both expressions recalculate on every report run, so the age is always current.
You can sort by this column to surface your oldest devices first, or use it as a filter to flag devices above a specific age threshold. Once you save and schedule the report, the calculation carries through automatically.
Screenshots are below, enjoy!
++
Dima L
Technical Product Marketing Manager
Atera(Edited by admin)
