This report provides computer manufacture name, model and number
of machines in the environment.
**************************************************************
SELECT Manufacturer0, Model0, Count(Model0) AS
'Count'
FROM dbo.v_GS_COMPUTER_SYSTEM
GROUP BY
Manufacturer0,Model0
ORDER BY Model0
***************************************************************
More SCCM custom reports can be found here
No comments:
Post a Comment