Asset Intelligence: Reports don't contain data

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

Comments

• Anonymous
  January 01, 2003
  Hi there,     I really don't know what's wrong (or if I'm doing some mistake) but I can't edit SMS 2003 Network Discovery Settings (and any of configuration options in Discovery Methods).     Every configuration is not available to me, a SMS administrator. I arrive here after some time of wrongdoing administration (for about two years) and the person in charge for SMS leave.     So I create my account based on the highest right level in SMS account manager, but not. Tried with other options and not again. No access to edit the above configurations.     My boss asked me to plan an migration to SMS 2003 SP3 (we have SP1) or 2007 version so I'm thinking to justify as necessary this and other misconfigurations (a lonnnng-book story). In this case of impossibility to edit those configurations, is there any remedy for?

• Anonymous
  January 01, 2003
  Hi there,     I really don't know what's wrong (or if I'm doing some mistake) but I ca

• Anonymous
  January 01, 2003
  We have seen some cases where folks attempt to run a report and instead of data they get a message that

• Anonymous
  January 01, 2003
  thank you

• Anonymous
  May 22, 2014
  Hi,
  
  Tnhx a lot! This post was helpfull