As Jim mentioned, "stale" objects will continue to be listed in the All Windows Workstations collection (including any machines which have been rebuilt with a new name). The following will get you a list of all "Active" Windows Workstations:
SELECT acid._ResourceGuid
FROM Inv_AeX_AC_Identification acid
JOIN vResource vr
ON acid._ResourceGuid = vr.Guid
WHERE acid.[System Type] LIKE 'Win%'
AND DATEDIFF(dd, [Client Date], GETDATE()) < 30
AND vr.IsManaged = 1
In the Explicit Exclusions section of the collection, exclude the "All Windows Servers" collection. This will give you all non-Server Windows computers which have sent basic inventory within 30 days. This works well for us as we send basic inventory every day; if you send it less frequently then you may want to increase the 30 above to a higher number.