Prajwal Desai

SCCM | ConfigMgr | Intune | Windows 11 | Azure

  • Home
  • Cloud
    • Autopilot
    • Azure
    • Endpoint Analytics
    • Intune
    • PowerShell
    • Teams
    • Windows 365
  • Microsoft
    • Active Directory
    • Group Policy
    • SCCM
    • SCOM
    • Windows 10
    • Windows 11
    • Windows Server
    • WSUS
  • Software
  • Forums
  • Newsletter
  • Contact
Notification Show More
Latest News
Fix Windows Autopilot Reset Error 0x80070032
Fix Windows Autopilot Reset Error 0x80070032
Autopilot Intune
Windows activation error 0xc004c020
Fix: Windows Activation Error 0xC004C020 with 2 Easy Methods
Windows 11 Windows 10
Find the Package ID of SCCM Application
3 Best Ways to Find the Package ID of SCCM Application
SCCM
SCCM Updates Install Error 0x800b0109 0x8024b303
Fix: SCCM Updates Install Error 0x800b0109 | 0x8024b303
SCCM
Disable Windows Hello for Business using Intune ftimg
Disable Windows Hello for Business using Intune – Comprehensive Guide
Intune Autopilot
Aa

Prajwal Desai

SCCM | ConfigMgr | Intune | Windows 11 | Azure

Aa
Search
  • Home
  • Cloud
    • Autopilot
    • Azure
    • Endpoint Analytics
    • Intune
    • PowerShell
    • Teams
    • Windows 365
  • Microsoft
    • Active Directory
    • Group Policy
    • SCCM
    • SCOM
    • Windows 10
    • Windows 11
    • Windows Server
    • WSUS
  • Software
  • Forums
  • Newsletter
  • Contact
Follow US

Home » SCCM » Configuration Manager USB Device Inventory

SCCM

Configuration Manager USB Device Inventory

By Prajwal Desai 1 View 1 comment February 29, 2020 3 Min Read

In this guide, I will show you how to perform USB Device Inventory using Configuration Manager. When you configure hardware inventory, it collects information about the hardware configuration of client devices in your organization.

Many Configuration Manager admins look to get more information about the users who frequently use the USB device to import or export data. The best way to find out USB device info would be using the Hardware Inventory feature of Configuration Manager.

Step 1 – Enable USB Device Hardware Inventory class

To enable the USB Device hardware inventory class (Win32_USBDevice) in SCCM

  • Open the ConfigMgr console.
  • Go Administration > Overview > Client Settings.
  • Right click Default Client Settings and click Properties.
  • Click Hardware Inventory tab and next to Hardware inventory classes, click Set Classes.
Hardware Inventory Set Classes
Hardware Inventory Set Classes

In the search box, type Win32_USBDevice. Select USB Device – Asset Intelligence (Win32_USBDevice) class. Click OK to apply the new settings and close the Default Client Settings Properties window.

- Advertisement -
Ad image
Select USB Device – Asset Intelligence (Win32_USBDevice)
Select USB Device – Asset Intelligence (Win32_USBDevice)

Hardware inventory runs on clients according to the schedule that you specify in client settings. However you can speed up this process. To force full hardware inventory on SCCM clients, you can follow this procedure.

Step 2 – Create USB Device SCCM query

Under Monitoring click Queries. Right click and click Create Query.

Create USB Device SCCM query
Create Query

Under General Query Settings, specify the name of the query and click Edit Query Statement. Click OK.

Edit Query Statement
Edit Query Statement

On the query statement properties window, click General tab. At the bottom, click Show Query Language.

Show Query Language
Show Query Language

Under Query Statement, copy and paste the below query.

select SMS_R_System.Name, SMS_R_System.Client, SMS_G_System_COMPUTER_SYSTEM.Model, SMS_G_System_USB_DEVICE.* from  SMS_R_System inner join SMS_G_System_USB_DEVICE on SMS_G_System_USB_DEVICE.ResourceId = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId

Configuration Manager USB Device Inventory

Click Next on the Summary page.

Configuration Manager USB Device Inventory Snap7

Finally on the Completion page, click Close.

Configuration Manager USB Device Inventory Snap8

Under Queries, you can execute the query to get the result. If you browse the Resource Explorer, you see the following information.

Configuration Manager USB Device Inventory

In addition to the above method, you can also execute the following built-in report – Hardware 07C – Computers with a specific USB Device. This is an useful SCCM report to find attached USB devices of computers.

Configuration Manager USB Device Inventory

Sign Up For Weekly Newsletter

Get the most recent information on Configuration Manager, Intune, Windows 11, Windows 365, Autopilot, Azure, Software Reviews, and much more by subscribing to the newsletter.
By signing up, you agree and acknowledge the data practices in our Privacy Policy. You may unsubscribe at any time.
Share this Article
Facebook Twitter Copy Link Print
Avatar photo
By Prajwal Desai
Follow:
Prajwal Desai is a Microsoft MVP in Enterprise Mobility. He writes articles on SCCM, Intune, Configuration Manager, Microsoft Intune, Azure, Windows Server, Windows 11, WordPress and other topics, with the goal of providing people with useful information.
Previous Article How to Deploy Microsoft Edge Updates using SCCM ADR How to Deploy Microsoft Edge Updates using SCCM ADR
Next Article sccm tech preview 2002.2 ftimg SCCM ConfigMgr Technical Preview 2002.2
1 Comment 1 Comment
  • Avatar photo Saul says:
    May 2, 2020 at 2:56 am

    Hi There,

    Thank you for this post. Please forgive my ignorance, but is there any way that we can maybe shorten the number of results by specifying the number of days we want on the results?

    Reply

Leave a Reply Cancel reply

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

Recast Sponsored AD
Ad image
Patch My PC Sponsored AD
Ad image

Latest Articles

Fix Windows Autopilot Reset Error 0x80070032
Fix Windows Autopilot Reset Error 0x80070032
Autopilot Intune
Windows activation error 0xc004c020
Fix: Windows Activation Error 0xC004C020 with 2 Easy Methods
Windows 11 Windows 10
Find the Package ID of SCCM Application
3 Best Ways to Find the Package ID of SCCM Application
SCCM
SCCM Updates Install Error 0x800b0109 0x8024b303
Fix: SCCM Updates Install Error 0x800b0109 | 0x8024b303
SCCM
Subscribe to Our Newsletter

Subscribe to our newsletter to get our newest articles instantly!

You Might Also Like

Find the Package ID of SCCM Application
SCCM

3 Best Ways to Find the Package ID of SCCM Application

By Prajwal Desai
SCCM Updates Install Error 0x800b0109 0x8024b303
SCCM

Fix: SCCM Updates Install Error 0x800b0109 | 0x8024b303

By Prajwal Desai
ConfigMgr Technical Preview 2302 New Features
SCCM

ConfigMgr Technical Preview 2302 New Features | Baseline Version

By Prajwal Desai

Removed from reading list

Undo
Welcome Back!

Sign in to your account

Lost your password?