Sunday, September 29, 2013

SCCM report for Computer make, model and count



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

1 comment:

  1. Always so interesting to visit your site.What a great info, thank you for sharing. this will help me so much in my learning
    Bios Chip Toshiba

    ReplyDelete