→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
googoo
Engaged Sweeper III
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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%'

View solution in original post

2 REPLIES 2
googoo
Engaged Sweeper III
that did it, thanks for the help.

Hemoco
Lansweeper Alumni
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%'