sccmug

Canadian SCCM User Group

Count of USB Controllers

August 27, 2007
Posted by Garth Jones

SELECT USB.Name0, Count(USB.Name0) AS ‘Count’
FROM v_GS_USB_CONTROLLER USB
GROUP BY USB.Name0
Updated: February 25, 2016 at 11:42 am
Tags: Code, ConfigMGr, SMS, SQL, System Center
◀ Ottawa Windows Server User Group Newsletter
Number of Microsoft Certified Professionals Worldwide ▶

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • Hostname History
  • Find computers with no active users.
  • Count of Models
  • SQL Query for Getting Started with Power BI Desktop and SCCM
  • Limiting a report to a Collection

Recent Comments

    Archives

    • August 2020 (2)
    • June 2020 (1)
    • December 2017 (1)
    • January 2014 (1)
    • September 2013 (1)
    • August 2013 (1)
    • July 2013 (3)
    • June 2013 (1)
    • April 2013 (1)
    • March 2013 (1)
    • February 2013 (1)
    • January 2013 (2)
    • December 2012 (3)
    • November 2012 (1)
    • October 2012 (5)
    • September 2012 (1)
    • July 2012 (4)
    • June 2012 (2)
    • May 2012 (7)
    • April 2012 (2)
    • March 2012 (15)
    • February 2012 (7)
    • January 2012 (7)
    • December 2011 (2)
    • November 2011 (5)
    • October 2011 (4)
    • September 2011 (4)
    • August 2011 (5)
    • July 2011 (7)
    • June 2011 (1)
    • May 2011 (2)
    • April 2011 (3)
    • March 2011 (8)
    • February 2011 (7)
    • January 2011 (8)
    • December 2010 (3)
    • November 2010 (5)
    • October 2010 (7)
    • September 2010 (7)
    • August 2010 (2)
    • July 2010 (8)
    • June 2010 (12)
    • May 2010 (4)
    • April 2010 (1)
    • March 2010 (13)
    • February 2010 (6)
    • January 2010 (3)
    • December 2009 (11)
    • November 2009 (10)
    • October 2009 (8)
    • September 2009 (11)
    • August 2009 (8)
    • July 2009 (12)
    • June 2009 (16)
    • May 2009 (11)
    • April 2009 (6)
    • March 2009 (6)
    • February 2009 (27)
    • January 2009 (11)
    • December 2008 (13)
    • November 2008 (17)
    • October 2008 (31)
    • September 2008 (60)
    • August 2008 (72)
    • July 2008 (56)
    • June 2008 (47)
    • May 2008 (38)
    • April 2008 (20)
    • March 2008 (8)
    • February 2008 (10)
    • January 2008 (17)
    • December 2007 (42)
    • November 2007 (29)
    • October 2007 (34)
    • September 2007 (31)
    • August 2007 (32)
    • July 2007 (33)
    • June 2007 (38)
    • May 2007 (34)
    • April 2007 (35)
    • March 2007 (35)
    • February 2007 (29)
    • January 2007 (29)
    • May 201 (1)

    Categories

    • SQL Query
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    Asteroid Theme