/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: MesaMe 4 years ago
Purple Belt
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

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

Don't be a Stranger!

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

Sign up! or login

View more:

Share

 
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