Systems Management Question
SQL Help - Aging of Machines
We're going to be moving to purchasing machines on a quarterly basis. What I'd like to do is have a scheduled report come out that breaks down the average age of each machine into categories say.. 1, 2, 3 and 4 years old (if there are any) and also broken out by desktop/laptop. I tried using some of the canned reports but it looks like I'm going to have to go the custom route. Unfortunately, I'm not very well versed with SQL so I'm going to need some help.
I.e. if the overall age of the
inventory is 3.4 years for laptops we can assume that we will have to replace a
larger number then if the average was 2.8 years. Is there a way to
find that in the database?