Make a report that list how many computers of the different models the firm have
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
Answers (1)
Please log in to answer
Posted by:
MesaMe
7 years ago
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
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
Comments:
-
add a where clause like this:
WHERE CS_MANUFACTURER != 'VMware, Inc.'
AND LAST_INVENTORY > SUBDATE(NOW(),INTERVAL 90 DAY) - JasonEgg 7 years ago