09-24-2012 11:09 PM
09-25-2012 12:40 PM
Select Top 1000000 Web40OSName.Compimage As icon, tblComputers.Computername, tblComputers.Computer, tblComputers.Domain, tblComputers.Description, TsysChassisTypes.ChassisName, Web40OSName.OSname, Web40OSName.SP, tblComputers.LastknownIP, tblComputers.Lastseen From tblComputers Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblSystemEnclosure On tblComputers.Computername = tblSystemEnclosure.Computername Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes Where tblSystemEnclosure.ChassisTypes = 8 Or tblSystemEnclosure.ChassisTypes = 9 Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now