Client Agent Version Report Discrepancy

Article ID: 31475

Problem/Symptoms

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.