none
how to get a USB Device Information RRS feed

  • Question

  • Hi All, 

    I need one USB Device installed in the computers. The US Device is Cogent CSD200 Device for biometric device. How to get the device information which is attached to computers which is in remote approximately 65,000 Clients. Either SQL Query or  from SCCM Report.



    Saturday, August 3, 2019 2:08 PM

All replies

  • Have you looked at the built-in reports for this. 

    Garth Jones

    Blog: https://www.enhansoft.com/blog Old Blog: https://sccmug.ca/

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleashed

    Saturday, August 3, 2019 3:10 PM
    Moderator
  • Hello,
     
    First, we need to enable the USB device inventory as shown below.
     

      
    Once the information is collection through hardware inventory, we could check them through AI reports as shown below.
      

     
    The SQL view storing USB device information is v_GS_USB_DEVICE,  we could use it for SQL query.
     
    Hope my answer could help you and look forward to your feedback.
     
    Best Regards,
    Ray

    Please remembers to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, August 5, 2019 1:16 AM
  • Hello,
     
    I notice that you have not updated for several days, has your issue been solved? Or is there any update?
     
    Feel free to feedback.
     
    Best Regards,
    Ray

    Please remembers to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Tuesday, August 13, 2019 7:55 AM