Asset Intelligence: Reports don't contain data

  • Article

We have seen some cases where folks attempt to run a report and instead of data they get a message that says :"No matching records could be found".  A different variation of this issue is a complaint that over time fewer and fewer machines appear in a given report.  Both issues have the same root cause, apply to both SMS 2003 SP3 and SCCM 2007, and the good news is that there is nothing wrong :-)

The solution here is a simple one: One or more of the reporting classes are disabled. In the first case, they were never turned on and in the second case, they were disabled after being enabled for some time.

Asset Intelligence functionality is provided by several WMI classes. Each class enables a given set of reports. If any class is disabled, that data won't flow back to the site server and therefore will not be available for that report. We documented the correlation between classes and reports in the CHM file that shipped with the products, but to save time and have the information in one spot, I'll post the information here.

SMS_InstalledSoftware

  • This class tracks information about installed software. The following reports are dependent on this class:
    License 1C - Computers with a specific Microsoft License Ledger Item and Sales Channel

    Software 1A - Summary of Installed Software in a Specific Collection

    Software 2A - Software Families

    Software 2B - Software Categories with a Family

    Software 2C - Software by Category and Family

    Software 2D - Computers with a Specific Software Product

    Software 2E - Installed Software on a Specific Computer

    Software 3A - Uncategorized Software

    Software 6A - Search for Installed Software

SMS_InstalledSoftwareMS

  • This class tracks information specifically about installed Microsoft software. The following reports are dependent on this class:
    License 1A - Microsoft License Ledger for Microsoft License Statements

    License 1B - Microsoft License Ledger Item by Sales Channel

    License 1C - Computers with a specific Microsoft License Ledger Item and Sales Channel

    License 1D - Microsoft License Ledger products on a specific computer

SMS_SystemConsoleUsage

  • This class polls the System Security Event Log for information about all console usage. The following reports are dependent on this class:
    Hardware 1A - Summary of Computers in a Specific Collection

    Hardware 2B - Computers within an age range with a collection

    Hardware 3A - Primary computer users

    Hardware 3B - Computers for a Specific Primary Console User

    Hardware 4A - Shared (multi-user) Computers

    Hardware 5A - Console Users on a Specific Computer

    Hardware 6A - Computers for Which Console Users Could not be Determined

    Hardware 7C - Computers with a Specific USB Device

    Hardware 8A - Hardware that is Not Ready for a Software Upgrade

    Hardware 9A - Search for computers

    License 1C - Computers with a specific Microsoft License Ledger Item and Sales Channel

    License 2B - Computers with Licenses Nearing Expiration

    License 3B - Computers with a Specific License Status

    License 4B - Computers with a Specific Product Managed by Software Licensing Service

    Software 2D - Computers with a Specific Software Product

    Software 4B - Computers with a Specific Auto-Start Software

    Software 5B - Computers with a Specific Browser Helper Object

SMS_SystemConsoleUser

  • This class polls the System Security Event Log for information about specific console users. The following reports are dependent on this class:
    Hardware 3A - Primary computer users

    Hardware 3B - Computers for a Specific Primary Console User

    Hardware 4A - Shared (multi-user) Computers

    Hardware 5A - Console Users on a Specific Computer

Note: This class only reads the last 90 days of the event log, regardless of the length of the log. If the log has less than 90 days of data, the entire log is read.

SMS_AutoStartSoftware

  • This class tracks information about software that starts automatically with the operating system. The following reports are dependent on this class:
    Software 4A - Auto-Start Software

    Software 4B - Computers with a Specific Auto-Start Software

    Software 4C - Auto-Start Software on a Specific Computer

SMS_BrowserHelperObject

  • This class tracks browser helper objects. While some browser helper objects are beneficial, most software considered "malware" is in the form of browser helper objects. The following reports are dependent upon this class:
    Software 5A - Browser Helper Objects

    Software 5B - Computers with a Specific Browser Helper Object

    Software 5C - Browser Helper Objects on a Specific Computer

Win32_USBDevice

  • This class tracks devices connected to USB ports. The following reports are dependent upon this class:
    Hardware 7A - USB Devices by Manufacturer

    Hardware 7B - USB Devices by Manufacturer and Description

    Hardware 7C - Computers with a Specific USB Device

    Hardware 7D - USB Devices on a Specific Computer

SMS_Processor

  • This is an existing SMS class to which new properties have been added to provide more complete data about processors. The following reports are dependent upon this class:
    Hardware 1A - Summary of Computers in a Specific Collection

    Hardware 2A - Estimated Computer Age by Ranges within a Collection

    Hardware 2B - Computers within an age range with a collection

    Hardware 8A - Hardware that is Not Ready for a Software Upgrade

    Hardware 9A - Search for computers

SMS_InstalledExecutable
  • This class is not currently used to support existing Asset Intelligence reports. However, it can be enabled to support custom reports.
SMS_SoftwareShortcut
  • This class is not currently used to support existing Asset Intelligence reports. However, it can be enabled to support custom reports.
SoftwareLicensingService

  • This class is specific to Windows Vista. For more information, see the Microsoft TechNet article Windows Vista Volume Activation 2.0 Technical Attributes. The following reports are dependent upon this class:
     
    License 2C - License Information on a Specific Computer

    License 5A - Computers Acting as a Key Management Service

SoftwareLicensingProduct

  • This class is specific to Windows Vista. For more information, see the Microsoft TechNet article Windows Vista Volume Activation 2.0 Technical Attributes. The following reports are dependent upon this class:
     
    License 2A - Count of Licenses Nearing Expiration by Time Ranges

    License 2B - Computers with Licenses Nearing Expiration

    License 2C - License Information on a Specific Computer

    License 3A - Count of Licenses by License Status

    License 3B - Computers with a Specific License Status

    License 4A - Count of Products Managed by Software Licensing

    License 4B - Computers with a Specific Product Managed by Software Licensing Service