→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
nfreeman
Engaged Sweeper
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
1 REPLY 1
David_G
Lansweeper Employee
Lansweeper Employee
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now