/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


SQL Help - Aging of Machines

12/22/2017 697 views
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?


Thanks!
1 Comment   [ + ] Show comment

Comments

  • 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?
    see:
    http://www.itninja.com/question/report-of-machines-by-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

All Answers

0
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.
Answered 12/28/2017 by: dstarrisom
Senior White Belt

Don't be a Stranger!

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

Sign up! or login

Share