Thanks Karlis & Zoltan - Zoltan's idea may work if we could use the count function for the serial number and not just computer. I couldn't work out how to do this.
I was able to do a report which included the computer serial numbers, so we could do it manually, which may be adequate for now, but open to any other suggestions.