cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
KRH
Engaged Sweeper

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?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

3 REPLIES 3
Sjors
Engaged Sweeper II
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
Lansweeper Alumni
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
Engaged Sweeper
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.