/bundles/itninjaweb/img/Breadcrumb_cap_w.png

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   [ - ] Hide Comment

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

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

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

Please log in to comment
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share