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)
