Reporting video cards (model, memory)

[KRH]

I have tried to report video cards with this query:

Select Top 1000000 tblComputers.Computer, tblDisplayControllerConfiguration.Caption From tblComputers Inner Join tblDisplayControllerConfiguration On tblComputers.Computername = tblDisplayControllerConfiguration.ComputernameSelect Top 1000000 tblComputers.Computer, tblDisplayControllerConfiguration.Caption From tblComputers Inner Join tblDisplayControllerConfiguration On tblComputers.Computername = tblDisplayControllerConfiguration.Computername

Some video card model names are listed but they are "corrupted" ATI FireGL V5100ŦČ铘¸ How to fix this?

Some workstations shows only this: Current Display Controller Configuration

Not very usefull.

Better ideas how to make this report better and more reliable?

[Sjors]

These reports didn't work for me. I created this report:

Select Top 1000000
  tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Lastseen,
  tblVideoController.AdapterCompatibility,
  tblVideoController.Caption,
  tblVideoController.DriverVersion,
  tblVideoController.AdapterRAM,
  tblVideoController.VideoModeDescription,
  tblVideoController.MinRefreshRate,
  tblVideoController.MaxRefreshRate,
  tblVideoController.CurrentHorizontalResolution,
  tblVideoController.CurrentVerticalResolution,
  tblVideoController.CurrentRefreshRate,
  tblVideoController.CurrentNumberOfColors,
  tblVideoController.CurrentBitsPerPixel,
  tblVideoController.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblVideoController On
    tblAssets.AssetID = tblVideoController.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName

[Hemoco · Accepted solution]

We would recommend using the tblVideoController.Caption field for the information you are after, not tblDisplayControllerConfiguration.Caption. An example report can be seen below.

Select Top 1000000 tblComputers.Computer, tblVideoController.Caption
From tblComputers Inner Join
tblVideoController On tblComputers.Computername =
tblVideoController.Computername
Order By tblComputers.Computer

[KRH]

Lansweeper wrote:
We would recommend using the tblVideoController.Caption field for the information you are after, not tblDisplayControllerConfiguration.Caption. An example report can be seen below.

Select Top 1000000 tblComputers.Computer, tblVideoController.Caption
From tblComputers Inner Join
tblVideoController On tblComputers.Computername =
tblVideoController.Computername
Order By tblComputers.Computer

Thanks! Now I got the report I needed.