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?


1 Comment   [ + ] Show comment
  • First, you will need to find out what is the value you're planning to use to measure the age...

    If it's a DELL maybe ship date?

    This is an old SQL it will not work in any newer version but it's start point.

    DELLs have the ship date written in BIOS and it can be retrieved via Windows.

    This is your first goal, determine and measure the age via Windows, then you can worry about the KACE Agent in regards how to grab this and send it to the K1000, to finally build a report - Channeler 3 years ago

Answers (1)

Posted by: dstarrisom 3 years ago
Senior White Belt
I'm guessing you're not running Dell systems?  If you are, we've created similar reports based on Warranty status and expiration, which are queryable fields in the K1000.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ