New to Lansweeper

[jmccourt]

Hello,
We just purchased the premium version of lansweeper and so far things are working pretty good. The first question I have it when using the report generator tool I can pull information out of one table and add it to my dashboard without any issues. The issue I'm having is when I try to pull fields out of several different tables the data is incorrect. Is this something I should be able to do? Thanks in advice for any help.

[Hemoco]

Just dragging a line between the "computername" should do the trick.
Are you sure that the tables are filled with data?

[jmccourt]

When I link the tables by just dragging a line between the two of them in the builder, the results don't show any data.
Do I need to actually write the SQL code?
Are there any instructions on properly linking the tables?

[Hemoco]

I don't know the exact data you want but this is a good example on how to link the tables.

[jmccourt]

When I copy and paste the copy you've supplied and run the query, I get "no results displayed"

[jmccourt]

Can this be done on the builder tab so the SQL code with be system generated?

[Hemoco]

You need to link your table to table tblcomputer

SELECT     dbo.tblComputers.Computername, dbo.tblComputersystem.Manufacturer, dbo.tblComputersystem.Model, dbo.tblADComputers.Description
FROM         dbo.tblComputers INNER JOIN
                      dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername INNER JOIN
                      dbo.tblADComputers ON dbo.tblComputers.Computername = dbo.tblADComputers.Computername

[jmccourt]

I had a feeling that should work without a problem. I'm sure I'm doing something wrong, I'm also not too familiar with SQL code so all I've done is selected the two tables that have the info I want in them and then checked the boxes for the fields I want. Do I need to link the tables together or something?

The SQL code it generated is:
SELECT
tblComputersystem.Manufacturer,
tblComputersystem.Model,
tblADComputers.Description,
tblADComputers.Computername
FROM
tblADComputers,
tblComputersystem

Thanks for your help!

[Hemoco]

You should be able to do that without any problems, could you give the sql code to the query you are trying to accomplish please.