How to create a report with Report Builder using the Simple type, and have it display both computers and virtual machines
Last Updated June 21, 2007
A common problem people notice when building reports with the simple report builder using the asset type of "Computer" is that virtual machines do not show up in the results of the report.
Cause Some Background Info
Inventory Solution 6.1 SP1 introduced the Virtual Machine classification of machines. This means that any virtual machine that was previously displayed as a "Computer" will instead show as the new "Virtual Machine" classification of device.
When a user creates a new report using the simple report builder and clicks the finish button, the following piece of SQL code is appended to the query generated: