/build/static/layout/Breadcrumb_cap_w.png
02/22/2018 412 views

I want to make a report for the numbers of the different Systemmodells, like the numbers of the different Microsoft Versions in the Windows Installation Report.

How can I get this? With Assistant, what is to enter, or has someone an SQL-Expression for me.

1 Comment   [ + ] Show comment

Comments


All Answers

2
You should be able to start from this:
SELECT DISTINCT CS_MODEL, CS_MANUFACTURER, COUNT(NAME)  FROM ORG1.MACHINE  GROUP BY CS_MODEL ORDER BY COUNT(NAME) DESC;
Answered 02/22/2018 by: torstenspitz
Senior White Belt

2
SELECT CS_MODEL, COUNT(ID) FROM ORG1.MACHINE
GROUP BY CS_MODEL
Answered 02/22/2018 by: chucksteel
Red Belt