Strange Report Problem

New Contributor

I am pulling a report of unassigned student computers. My criteria is the Real Name is blank and the Room is also blank for a MacBook Air Mid 2011 and the computer is not marked as destroyed. Problem is i get 50 computers back but i went and check my shelfs and i have 63. So i did a search on one of the asset tags that is not listed and according to the record it should meet the criteria. Meaning the real name field the Room field and the destroyed fields are all blank. . Not sure why 12 of these computers are not showing up. I have also gone in to the real name fields and room fields and deleted it out to make sure there's nothing in there.