Portable Computer Report

[tdecenso]

What is the best way to create a report for all laptop computers in the domain.

I know there is one pre-configured on the web site, but it doesn't have all the information I need, and in the Report Builder I cannot find that report.

Thank you,

Tim

[tdecenso]

tdecenso wrote:
What is the best way to create a report for all laptop computers in the domain.

I know there is one pre-configured on the web site, but it doesn't have all the information I need, and in the Report Builder I cannot find that report.

Thank you,

Tim

Figured it out

SELECT DISTINCT TOP 100 PERCENT a.ComputerUnique as [Computer Name], a.Username as [User Name], c.Firstname as [First Name], 
c.Lastname as [Last Name], b.Manufacturer, b.Model, a.LastknownIP
FROM lansweeperdb.dbo.tblComputers a
  LEFT OUTER JOIN lansweeperdb.dbo.tblComputerSystem b ON b.Computername = a.Computername
  FULL JOIN lansweeperdb.dbo.tblADusers c ON c.Username = a.Username
  INNER JOIN lansweeperdb.dbo.tblADComputers d ON d.Computername = a.Computername
Where a.Computername In (Select lansweeperdb.dbo.tblportablebattery.Computername
  From lansweeperdb.dbo.tblportablebattery)