Searching for a mainboard

[primeillusion]

Hello Lansweeper forum!

I'm trying to update the economic information I input to the custom fields through SQL. There's a batch of PC's that was built by a local manufacturer, and they seemingly don't tell Windows who they are.

All I have to go on is the mainboard: Is there any way I can list my computers by mainboard so I can update my CSV properly?

Thanks in advance!

[Hemoco]

Something like this?

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblBaseBoard.Product, tblBaseBoard.SerialNumber
From tblComputers Inner Join
tblBaseBoard On tblComputers.Computername = tblBaseBoard.Computername

[primeillusion]

Lansweeper wrote:
Something like this?

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblBaseBoard.Product, tblBaseBoard.SerialNumber
From tblComputers Inner Join
tblBaseBoard On tblComputers.Computername = tblBaseBoard.Computername

Thanks for the suggestion, but the SQL guy is in another branch office today. Any easier way I could do this, perhaps? If not, I'll talk to the guy in the morning.