/build/static/layout/Breadcrumb_cap_w.png
11/24/2016 837 views
I would like to make a report that lists all the PC models my company owns and how many we have of the different models. I have made a list that displays each computer / model on a seperate line but is is possible to make another one that sums it up and does tha math? If the report can display when the computer Connected to K1000 as well it would be great.
0 Comments   [ + ] Show comments

Comments


All Answers

1
I have found this code that partly does it. Is it possible to skip the VMs and only display the Laptops and display the machines whose agent have "checked in" With K1000 the past 90 days (or whatever)?

SELECT CS_MANUFACTURER AS MANUFACTURER,CS_MODEL AS MODEL,
 CHASSIS_TYPE AS FORM_FACTOR, COUNT(CS_MODEL) AS COUNT
 FROM MACHINE
 GROUP BY CS_MODEL
 ORDER BY COUNT DESC
Answered 11/24/2016 by: MesaMe
Purple Belt

  • add a where clause like this:
    WHERE CS_MANUFACTURER != 'VMware, Inc.'
    AND LAST_INVENTORY > SUBDATE(NOW(),INTERVAL 90 DAY)