‎01-18-2013 05:56 PM
Select Top 1000000 upgrade_tblComputers.Computername,
upgrade_tblComputers.ComputerUnique,
upgrade_Web40OSName.Compimage As icon,
upgrade_Web40OSName.OSname,
upgrade_tblComputers.SP As [Service Pack],
upgrade_tblCompCustom.Location,
upgrade_tblCompCustom.Department As [Research Unit],
upgrade_tblCompCustom.Custom1 As [User Name],
TsysChassisTypes.ChassisName As Type,
upgrade_tblCompCustom.BarCode As [Inventory Number],
upgrade_tblBIOS.ReleaseDate,
upgrade_tblSystemEnclosure.SerialNumber,
upgrade_tblCompCustom.State
From upgrade_tblComputers
Left Outer Join upgrade_web40ProcessorCapacity
On upgrade_tblComputers.Computername =
upgrade_web40ProcessorCapacity.Computername
Inner Join upgrade_web40ActiveComputers On upgrade_tblComputers.Computername =
upgrade_web40ActiveComputers.Computername
Left Join upgrade_web40CorrectMemory
On upgrade_web40CorrectMemory.Computername =
upgrade_tblComputers.Computername
Left Join upgrade_Web40OSName On upgrade_Web40OSName.Computername =
upgrade_tblComputers.Computername
Left Join upgrade_tblComputerSystemProduct
On upgrade_tblComputers.Computername =
upgrade_tblComputerSystemProduct.Computername
Left Join upgrade_tblCompCustom On upgrade_tblComputers.Computername =
upgrade_tblCompCustom.Computername
Left Join upgrade_tblBIOS On upgrade_tblComputers.Computername =
upgrade_tblBIOS.Computername
Left Join upgrade_tblSystemEnclosure On upgrade_tblComputers.Computername =
upgrade_tblSystemEnclosure.Computername
Left Join TsysChassisTypes On TsysChassisTypes.Chassistype =
upgrade_tblSystemEnclosure.ChassisTypes
Where upgrade_tblCompCustom.State Like '%'
Order By upgrade_tblComputers.Computername
Solved! Go to Solution.
‎01-18-2013 09:14 PM
‎01-28-2013 07:02 PM
‎01-18-2013 09:43 PM
Select Top 1000000 upgrade_tblComputers.Computername,
upgrade_tblComputers.ComputerUnique,
upgrade_Web40OSName.Compimage As icon,
upgrade_Web40OSName.OSname,
upgrade_tblComputers.SP As [Service Pack],
upgrade_tblCompCustom.Location,
upgrade_tblCompCustom.Department As [Research Unit],
upgrade_tblCompCustom.Custom1 As [User Name],
TsysChassisTypes.ChassisName As Type,
upgrade_tblCompCustom.BarCode As [Inventory Number],
upgrade_tblBIOS.ReleaseDate,
upgrade_tblCompCustom.State,
tblAssetCustom.Serialnumber,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
From upgrade_tblComputers
Left Outer Join upgrade_web40ProcessorCapacity
On upgrade_tblComputers.Computername =
upgrade_web40ProcessorCapacity.Computername
Inner Join upgrade_web40ActiveComputers On upgrade_tblComputers.Computername =
upgrade_web40ActiveComputers.Computername
Left Join upgrade_web40CorrectMemory
On upgrade_web40CorrectMemory.Computername =
upgrade_tblComputers.Computername
Left Join upgrade_Web40OSName On upgrade_Web40OSName.Computername =
upgrade_tblComputers.Computername
Left Join upgrade_tblComputerSystemProduct
On upgrade_tblComputers.Computername =
upgrade_tblComputerSystemProduct.Computername
Left Join upgrade_tblCompCustom On upgrade_tblComputers.Computername =
upgrade_tblCompCustom.Computername
Left Join upgrade_tblBIOS On upgrade_tblComputers.Computername =
upgrade_tblBIOS.Computername
Left Join upgrade_tblSystemEnclosure On upgrade_tblComputers.Computername =
upgrade_tblSystemEnclosure.Computername
Left Join TsysChassisTypes On TsysChassisTypes.Chassistype =
upgrade_tblSystemEnclosure.ChassisTypes
Inner Join tblAssetCustom On tblAssetCustom.CustID =
upgrade_tblCompCustom.CustID
Order By upgrade_tblComputers.Computername
‎01-25-2013 11:19 PM
Inner Join upgrade_web40ActiveComputers On upgrade_tblComputers.Computername =
upgrade_web40ActiveComputers.Computername
‎01-18-2013 09:14 PM
‎01-18-2013 06:24 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now