‎06-09-2010 08:25 PM
‎06-09-2010 08:59 PM
‎06-09-2010 08:58 PM
Select '' As Location, TsysChassisTypes.ChassisName As Type,
tblcomputers.Computer As Name, tblComputerSystemProduct.Vendor As Vendor,
tblComputerSystemProduct.Name As Model,
tblComputerSystemProduct.IdentifyingNumber As SerialNumber,
tblcomputers.LastknownIP As IPAddress
From tblcomputers Inner Join
tblComputerSystemProduct On tblcomputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblSystemEnclosure On tblcomputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Where TsysChassisTypes.ChassisName <> 'Docking Station' And
tblComputerSystemProduct.Vendor <> 'Vmware, Inc.'
UNION
SELECT tblCustDevices.Location,
tsysDevicetypes.ItemTypename,
tblCustDevices.Displayname,
tblCustDevices.Vendor,
tblCustDevices.Description,
tblCustDevices.Serialnumber,
tblCustDevices.Ipaddress
FROM tblCustDevices, tsysDevicetypes
WHERE tblCustDevices.Devicetype = tsysDevicetypes.ItemType
ORDER BY LastknownIP
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now