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?
Thanks!
1 Comment
[ + ] Show comment
Answers (1)
Please log in to answer
Posted by:
dstarrisom
6 years ago
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.
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 - Channeler 7 years ago