Close Menu
    Facebook X (Twitter) Instagram
    Friday, September 26
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»Collections»SCCM Collection report for hardware Inventory not reported for X days

    SCCM Collection report for hardware Inventory not reported for X days

    Eswar KonetiBy Eswar KonetiAugust 02, 11:09 am2 Mins Read Collections 13,350 Views
    Share
    Facebook Twitter LinkedIn Reddit

    some times its hard to know the systems which are having issues in reporting their inventory and even some systems doesnt reporte anything to the site server though the client is installled on it.

    Here is the collection which gives you all computers which doesnt report inventory for x days(taken 15days).

    select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System where ResourceId in (select SMS_R_System.ResourceID from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId where DATEDIFF(dd,SMS_G_System_WORKSTATION_STATUS.LastHardwareScan,GetDate()) > 25) or ResourceId not in (select ResourceID from SMS_G_System_WORKSTATION_STATUS)

    Good luck in troubleshooting why it doesnt report 🙂

    Hints:

    solution that i tried got worked.

    1.check if you are able to connect to admin$ and see the log file i.e ccmexec.log( service is running or not)

    2.check it the machine has problem with WMI repository, this is the most possible issue to resolve. you can the simple batch script to reolve WMI that i posted on my web(http://eskonr.com/2009/03/how-to-troubleshoot-the-systems-which-has-wmi-issues-rebuild-wmi-repository/) This can be done Via psexec on list of machines.the script will compile the MOF file with site server and it resolve most of the systems that failed in sending hinv .Use the collection commander tool (http://sourceforge.net/projects/smscollctr/) to intiate the hinv on list of machine single time.it should gives you the result that has been run or not ?

    Collection collection for hardware inventory not reported Collections Configmgr 2007 configmgr collection configmgr report hardware inventory not scanned inventory SCCM 2007 SCCM Reports software inventory
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Distinguishing Desktops and Laptops in Intune based on Chassis Type

    July 11, 9:25 pm

    Efficiently Identify Co-Managed Devices: Techniques and Tools

    January 17, 8:37 pm

    SCCM report list collections with no deployments

    December 05, 12:04 pm

    3 Comments

    1. Tejas Patel on January 24, 2017 2:52 AM

      Hello Eswar,

      I need your help in getting the hardware inventory report including my VMs UCS blade name as well... however I am not able to find it under pre-loaded classes..

      If you have any idea.. please let me know.. That is really appreciated...

      Thank you
      Tejas Patel

      Reply
      • Eswar Koneti on January 24, 2017 2:59 PM

        Hi Tejas,
        For VMs UCS blade name ,first you you need to findout if you can identify this info on the vm manually before you reach to SCCM. SCCM will gather information what you have configured in the hardware inventory (client settings).
        If you know where does this information stores in WMI ,you can edit the client settings ,go to inventory ,add the wmi instance with selection you need. Thsi will help you to add custom inventory http://powershelldistrict.com/how-to-extend-hardware-inventory-in-configuration-manager/

        Regards,
        Eswar

        Reply
    2. Leta Minich on March 12, 2012 7:47 PM

      Should you owe the bank $100 that's your problem. In case you owe the lender $100 million, this is the bank's problem.
      Failure does not imply you're a failure it just means you've not succeeded yet.

      Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2025 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.