Changes in version 4.0 in table tblcomputers.
Computername: integer field, used for the linking to other tables:
Computerunique: unique field domain\computername\siteid
Computer: name of the computer (this was field computername in 3.x)
Most custom reporting problems can be fixed by adding field "computerunique" to the query.