‎01-09-2012 11:53 AM
Select Top 100000 tblcomputers.Computername, tblcomputers.ComputerUnique As [Computer Name], tblcomputers.Username As Username, tblComputerSystemProduct.Vendor As [Computer Manufacturer], tblComputerSystemProduct.Name As [Computer Model], tblComputerSystemProduct.IdentifyingNumber As [Service Tag], tblCompCustom.PurchaseDate As [Purchase Date], tblCompCustom.Warrantydate As [Warranty Expiration], tblSoftware.softwareName, tblcomputers.LastknownIP As [Last Known IP Address] From tblSoftware Inner Join tblcomputers On tblcomputers.Computername = tblSoftware.ComputerName Inner Join tblComputerSystemProduct On tblcomputers.Computername = tblComputerSystemProduct.Computername Inner Join tblCompCustom On tblcomputers.Computername = tblCompCustom.Computername Where tblSoftware.softwareName Like '%Microsoft Office%' Or tblSoftware.softwareName Like '%Visio%' Or tblSoftware.softwareName Like '%Project%' Order By tblcomputers.ComputerUnique
Solved! Go to Solution.
‎01-10-2012 04:28 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique As
[Computer Name], tblComputers.Username As Username,
tblComputerSystemProduct.Vendor As [Computer Manufacturer],
tblComputerSystemProduct.Name As [Computer Model],
tblComputerSystemProduct.IdentifyingNumber As [Service Tag],
tblCompCustom.PurchaseDate As [Purchase Date], tblCompCustom.Warrantydate As
[Warranty Expiration], office.softwareName, tblComputers.LastknownIP
As [Last Known IP Address]
From tblComputers Left Join
(Select tblSoftware.softwareName, tblSoftware.ComputerName
From tblSoftware
Where (tblSoftware.softwareName Like '%Microsoft Office%') Or
(tblSoftware.softwareName Like '%Visio%') Or
(tblSoftware.softwareName Like '%Project%')) office On office.ComputerName
= tblComputers.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Order By tblComputers.ComputerUnique
‎01-10-2012 04:28 PM
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique As
[Computer Name], tblComputers.Username As Username,
tblComputerSystemProduct.Vendor As [Computer Manufacturer],
tblComputerSystemProduct.Name As [Computer Model],
tblComputerSystemProduct.IdentifyingNumber As [Service Tag],
tblCompCustom.PurchaseDate As [Purchase Date], tblCompCustom.Warrantydate As
[Warranty Expiration], office.softwareName, tblComputers.LastknownIP
As [Last Known IP Address]
From tblComputers Left Join
(Select tblSoftware.softwareName, tblSoftware.ComputerName
From tblSoftware
Where (tblSoftware.softwareName Like '%Microsoft Office%') Or
(tblSoftware.softwareName Like '%Visio%') Or
(tblSoftware.softwareName Like '%Project%')) office On office.ComputerName
= tblComputers.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Order By tblComputers.ComputerUnique
‎01-09-2012 04:37 PM
‎01-09-2012 01:59 PM
Select Top 100000 tblComputers.Computername, tblComputers.ComputerUnique As
[Computer Name], tblComputers.Username As Username,
tblComputerSystemProduct.Vendor As [Computer
Manufacturer],
tblComputerSystemProduct.Name As [Computer Model],
tblComputerSystemProduct.IdentifyingNumber As [Service Tag],
tblCompCustom.PurchaseDate As [Purchase Date], tblCompCustom.Warrantydate As
[Warranty Expiration], tblSoftware.softwareName, tblComputers.LastknownIP As
[Last Known IP Address]
From tblSoftware Right Join
tblComputers On tblComputers.Computername = tblSoftware.ComputerName Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Where (tblSoftware.softwareName Like '%Microsoft Office%') Or
(tblSoftware.softwareName Like '%Visio%') Or
(tblSoftware.softwareName Like '%Project%')
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now