Count of Computers by Processor Speed, Type, and OS report
Apologies if someone has encountered this before. I have searched the forums and the KB in vain for any references to it.
I have noticed that the report entitled Count of Computers by Processor Speed, Type and OS gives inconsistent results on the top level server in a hierarchy. Many computers reported in the same report on the child servers are omitted from the results on the top level server even though the resources have been successfully replicated to the server.
The issue is caused by the fact that inventory solution records an integer value for the processor family in the Inv_HW_Processor table and then uses the String table to translate this value into a string value. It seems that these reference values in the String table are not being replicated up the hierarchy. If the lookup fails the vHWProcessor view will have a NULL value for the 'Processor Type'.
The report has a condition p.[Family] LIKE '%Processor Type%'. If p.[Family] is NULL, this condition is false and the computer will not be reported. A simple fix is to export the report, edit it in WordPad*, and change the condition in the query to COALESCE(p.[Family],'') LIKE '%Processor Type%'. Save the file and import it to the Processor folder. The report will show blank values for the Processor Type, but that is preferable to not seeing any results at all.
A better fix would be to ensure that the String table has corresponding entries to all of the Family references in the Inv_HW_Processor table. I am working on getting this resolved.
*Note: WordPad works better than Notepad for these XML files. Editing in Notepad invariably causes the file to fail to import back into the console.