Here is an SMS Web Report that will help you locate a computer by searching on the serial number or by using wild cards.
Download the .zip, extract it to your favorite location and import it into your SMS Reports.
Stuart Norman