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

2 comments:

  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
  2. I had say that the majority of us guests are truly supplied to exist in a fantastic place with a lot of great people with extremely accommodating things
    Bangalore escort girls

    ReplyDelete