3. October 2006 at 19:51 #8835
- Total Post: 74
- Back Stage Pass
Here’s a query for the serial numbers of each device:
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.