‎08-06-2010 03:31 AM
‎08-06-2010 05:00 PM
Select top 1000000 tblCompCustom.Department, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name, Count(tblComputers.Computername) As Total
From tblComputers Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername
Group By tblCompCustom.Department, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name
Order By tblCompCustom.Department, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now