→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎08-10-2012 11:33 AM
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
Solved! Go to Solution.
‎08-10-2012 01:15 PM
Select Top 1000000 tblComputers.Computer, tblVideoController.Caption
From tblComputers Inner Join
tblVideoController On tblComputers.Computername =
tblVideoController.Computername
Order By tblComputers.Computer
‎01-26-2021 10:28 AM
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
‎08-10-2012 01:15 PM
Select Top 1000000 tblComputers.Computer, tblVideoController.Caption
From tblComputers Inner Join
tblVideoController On tblComputers.Computername =
tblVideoController.Computername
Order By tblComputers.Computer
‎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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now