Client Agent Version Report Discrepancy

Problem:
Client Agent Version Report displays different client counts on the Level 0 and Level 1 sections of the report
Cause:
Level 0 SQL query uses vItem view and Level 1 SQL query uses vComputer view. vComputer filters out retired assets.
Resolution:
Change the Level 0 SQL query to query the vComputer view. Replace all instances of vItem in the level 0 query with vComputer.