Query Windows version - not returning all clients

Question

Hi,
Having an issue with building a collection/query, finding all clients with build 19042 (Win10 v 20H2). It's not getting all of them.¨

Using the query builder "operating system.Build Number equal to..." yields 922 results
Using "system.Build equal to.." yields 947 results...
(Combining them using OR, select distinct, yields 925 results)

And some clients are only present in the query getting the fewer results, but missing from the query with the most results.

This query stuff seems very sensitive, almost random. How to go about troubleshooting, and knowing what source to trust?

Answer 1

If your heartbeat discovery dates are 2 months back you have unhealthy clients and you need to look at first. Start by forcing all of you client to send update heartbeat discovery data.

Answer 2

Hi @GonWild ,

We could check the tab of Heatbeat DDR in the console of SCCM server. If the client could be found by heatbeat, the date could be shown on it. Please check them on the console and the result of query.

Besides, about heatbeat discovery, we could check InventoryAgent.log and InventoryProvider.log, they record activities of hardware inventory, software inventory, and heartbeat discovery actions on the client.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

The first query uses Hardware inventory. Have you confirm that it is showing the details correctly within Resource Explorer?
The second query uses Heartbeat discovery, Have you confirmed that it is showing correctly for the device properties?

Answer 4

generated from the query builder:

1. select distinct SMS_R_System.Name, SMS_R_System.Client from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.BuildNumber = "19042"
2. select distinct SMS_R_System.Name, SMS_R_System.Client from SMS_R_System where SMS_R_System.Build = "10.0.19042"

Answer 5

Without your query everyone will be guessing as to the problem. Please post your query.