device driver version

[googoo]

I need some help with SQL....

I'm looking for a way to export a report of all computers with a particular video adapter and the driver version it is running. I can find this info by looking at CONFIG\VIDEO CARD for each pc, so I'm sure the right SQL query will give what I need.

I'm looking for all computers with: ATI RADEON HD 2400*

Any help would be appreciated.

thanks

[googoo]

that did it, thanks for the help.

[Hemoco · Accepted solution]

try this

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, tblVideoController.Caption,
  tblVideoController.DriverVersion
From tblComputers Inner Join
  tblVideoController On tblComputers.Computername =
    tblVideoController.Computername
Where tblVideoController.Caption Like 'ATI RADEON HD 2400%'