New to LAN Sweeper

[ITMonkey]

Hi

I need some assistance with generating a report for a series of server in a domain scan. Basically I need to know how to generate this report into an Excel sheet and only selecting the servers I need.

Any help would be appreciated.

Thanks
Paul

[Hemoco]

Can you post a screenshot of the active directory path and your exact query please.

[Hemoco]

You can start from this basic report and add the tables/fields you like.

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, tblADComputers.OU, tblComputers.LastknownIP
From tblComputers Inner Join
  tblADComputers On tblComputers.Computername = tblADComputers.Computername
Where tblADComputers.OU = 'your OU name'     

[ITMonkey]

Tried the code but get “<no data to display>” when clicking Result in the Report Builder

Tried with ‘name’, ‘OU=name’, ‘name, DC=dc, DC=com’, ‘OU=name, DC=dc, DC=com’

Still nothing.

[Hemoco]

Do the servers have a common criteria (same OU, ...)
If not you need to specify their name in the "where" clause.
... where computer = 'computer1' or computer = 'computer2' ...

[ITMonkey]

Lansweeper wrote:
Do the servers have a common criteria (same OU, ...)
If not you need to specify their name in the "where" clause.
... where computer = 'computer1' or computer = 'computer2' ...

The servers are in their own OU.

[Hemoco]

You won't be able to display this information in a tabular report because information like disks/software will contain multiple rows for each computer.

[ITMonkey]

Lansweeper wrote:
You won't be able to display this information in a tabular report because information like disks/software will contain multiple rows for each computer.

That's fine but can I dump to Excel? If so, how do I select multiples?

[Hemoco]

Could you give some more details, which fields needed, ...

[ITMonkey]

Lansweeper wrote:
Could you give some more details, which fields needed, ...

Hardware (cpu RAM etc..), disk space status, installed software (including OS and patch status)

Thanks
Paul