→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎10-13-2011 02:37 PM
Solved! Go to Solution.
‎10-13-2011 05:34 PM
Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblOperatingsystem.Caption, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblComputers.Computer, tblSoftware.softwareName
‎10-18-2011 02:59 PM
Select Top 1000000 tblComputers.Computername, tblComputers.Domain,
tblComputers.Computer, tblComputerSystemProduct.Vendor,
web40ProcessorCapacity.NrOfProcessors, web40ProcessorCapacity.CPU,
tblOperatingsystem.Caption As OS, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Left Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername
Order By tblComputers.Computer, tblSoftware.softwareName
‎10-17-2011 08:33 PM
‎10-13-2011 06:44 PM
‎10-13-2011 05:34 PM
Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblOperatingsystem.Caption, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblComputers.Computer, tblSoftware.softwareName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now