Darren,
Thanks so much for coming back to this, posting your SQL made it easy for me to compare to what I had. I made a change not to long ago to check only for online machines, but I didn't do it correctly, I removed that line item and it is working as expected again. Thanks so much!!