
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-10-2012 11:33 AM
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?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-10-2012 01:15 PM
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
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-26-2021 10:28 AM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-10-2012 01:15 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-10-2012 02:29 PM
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.
