List of job models
Published: June 18, 2024 - 10:12
Good morning,
2 queries that allow retrieving the list of job models, grouped by model.
Global:
By OR:
2 queries that allow retrieving the list of job models, grouped by model.
Global:
Code: Select all
SELECT
manufacturer,
productname,
COUNT(*) AS NbMachines
FROM
hosts
GROUP BY
manufacturer, productname;
Code: Select all
SELECT
manufacturer,
productname,
COUNT(*) AS NbMachines
FROM
hosts
WHERE
computer_ad_ou LIKE '%%OU%%'
GROUP BY
manufacturer, productname;