Create report for the number of the Systemmodell
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
-
perfect, thank you - Calligraphy 6 years ago
Answers (2)
Please log in to answer
Posted by:
torstenspitz
6 years ago
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;
