Custom Report - Approximate computer ages in an organization

(imported topic written by rdamours91)

I was asked last week to generate a count of the computers in the district and the approximate age of each type of machine organized in the following fashion…or something close.

Range Count

0-1 years old 9,999

1-3 years old 9,999

3-5 years old 9,999

5 years old 9,999

I manually came up with a number sorted by each processor type 2100 Mhz Core 2, 3000 Mhz Pentium 4, etc and then took the oldest bios date in that range as an approximation of when that processor was released in the wild. I then totalled each year range 1.2, 1.5, 2.1, 2.4, etc into how many pc’s in the 1-3 year range, etc.

The report gave us an approximate number of the approximate ages of the pc’s in the district…and worked rather well as we confirmed somewhat with invoices of purchases, etc.

Just wondering if anyone else would find such a report useful and/or be willing to take a crack at it as a custom report. I’m buried alive and will be able get to it in a month or so…time permitting.

(imported comment written by BenKus)

Hey rdamours,

Do you mind posting some examples of the dates you are looking at? Also the name of the property that returns the dates.