Reply To: Rapport DB export

  • Total Post: 74
  • Back Stage Pass
  • ★★★★

Here’s a query for the serial numbers of each device:

use RapportDB
select B.[ClientID], C.[Name], B.[Serial]
from ClientHardware B, Client C
where b.clientid = c.Clientid

This will return the Name and Serial number of every device in the DB.