Graphic Card Report

[nfreeman]

Hi Lansweepers,

I'm trying to find a way to get Video Card info from my Linux, mac and Windows box.
But as soon as i save and run it, 'ive got the "This report has no results!".
If i do it one by one it's working (first only tblVideoController.Caption, and another one with tblLinuxGraphicsCards.Name)
But i want all in once.

Select Top 10000 tblAssets.AssetName,
tblVideoController.Caption,
tblLinuxGraphicsCards.Name
From tblAssets
Inner Join tblVideoController
On tblAssets.AssetID = tblVideoController.AssetID
Inner Join tblLinuxGraphicsCards On tblAssets.AssetID =
tblLinuxGraphicsCards.AssetID


Thx

[David_G]

We have edited the report you have provided us with so it will give back graphic cards for both Windows computers and Linux systems in one report by using a Left Join instead of an Inner Join.

Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 10000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblVideoController.Caption As [Windows Graphics Card],
  tblLinuxGraphicsCards.Name As [Linux Graphics Card]
From tblAssets
  Left Join tblVideoController On tblAssets.AssetID = tblVideoController.AssetID
  Left Join tblLinuxGraphicsCards
    On tblAssets.AssetID = tblLinuxGraphicsCards.AssetID