Is WMI functioning on the machine that is inactive? Whenever I get an inactive machine I had to wipe and reset the WMI repositories.
I find the little script in this link fixes 99% of all my problems. Doesn't happen often but this solves it for me when it does.
http://blogs.technet.com/b/configmgrteam/archive/2009/05/08/wmi-troubleshooting-tips.aspx
https://vasanthsccm.wordpress.com/2012/02/10/sql-queries-for-sccm/
http://www.applepie.se/configmgr-match-client-address-to-ip-range-boundaries
https://social.technet.microsoft.com/Forums/systemcenter/en-US/a56f3aa6-5a5d-42cd-9a7b-3eee880f29cc/better-sql-query-for-clients-without-boundaries?forum=configmgrgeneral
http://eskonr.com/2012/07/sccm-report-computer-information-with-boundary-added/
https://www.reddit.com/r/SCCM/comments/2vaaps/report_on_clients_by_boundary_sccm_2012r2/