12-18-2012 11:38 PM
Solved! Go to Solution.
12-19-2012 08:37 PM
Select Top 1000000 DERIVEDTBL.icon, DERIVEDTBL.Name As Sysname, DERIVEDTBL.IP, DERIVEDTBL.IPLocation, DERIVEDTBL.Type, DERIVEDTBL.Domain, DERIVEDTBL.Lastseen, DERIVEDTBL.computername, DERIVEDTBL.PurchaseDate, DERIVEDTBL.Warrantydate From (Select Web40OSName.Compimage As icon, tblComputers.LastknownIP As IP, web40AllIPLocations.IPLocation As IPLocation, tblComputers.Computer As Name, Web40OSName.OSname As Type, tblComputers.Lastseen, tblComputers.IPNumeric, Cast(tblComputers.Computername As varchar) As computername, tblComputers.Domain, tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate From tblComputers Inner Join web40AllIPLocations On tblComputers.Computername = web40AllIPLocations.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On tblComputers.Computername = Web40OSName.Computername Left Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Union Select tsysDevicetypes.ItemTypeIcon10 As icon, tblCustDevices.Ipaddress As IP, web40AllIPLocationsDev.IPLocation As IPLocation, tblCustDevices.Displayname As Name, tsysDevicetypes.ItemTypename As Type, tblCustDevices.LastSeen, tblCustDevices.IPNumeric, tblCustDevices.DeviceKey As computername, '' As domain, tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate From tsysDevicetypes Inner Join tblCustDevices On tsysDevicetypes.ItemType = tblCustDevices.Devicetype Inner Join web40AllIPLocationsDev On tblCustDevices.DeviceKey = web40AllIPLocationsDev.DeviceKey Where tblCustDevices.State = 1) DERIVEDTBL Order By DERIVEDTBL.IPNumeric
12-19-2012 08:37 PM
Select Top 1000000 DERIVEDTBL.icon, DERIVEDTBL.Name As Sysname, DERIVEDTBL.IP, DERIVEDTBL.IPLocation, DERIVEDTBL.Type, DERIVEDTBL.Domain, DERIVEDTBL.Lastseen, DERIVEDTBL.computername, DERIVEDTBL.PurchaseDate, DERIVEDTBL.Warrantydate From (Select Web40OSName.Compimage As icon, tblComputers.LastknownIP As IP, web40AllIPLocations.IPLocation As IPLocation, tblComputers.Computer As Name, Web40OSName.OSname As Type, tblComputers.Lastseen, tblComputers.IPNumeric, Cast(tblComputers.Computername As varchar) As computername, tblComputers.Domain, tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate From tblComputers Inner Join web40AllIPLocations On tblComputers.Computername = web40AllIPLocations.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On tblComputers.Computername = Web40OSName.Computername Left Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Union Select tsysDevicetypes.ItemTypeIcon10 As icon, tblCustDevices.Ipaddress As IP, web40AllIPLocationsDev.IPLocation As IPLocation, tblCustDevices.Displayname As Name, tsysDevicetypes.ItemTypename As Type, tblCustDevices.LastSeen, tblCustDevices.IPNumeric, tblCustDevices.DeviceKey As computername, '' As domain, tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate From tsysDevicetypes Inner Join tblCustDevices On tsysDevicetypes.ItemType = tblCustDevices.Devicetype Inner Join web40AllIPLocationsDev On tblCustDevices.DeviceKey = web40AllIPLocationsDev.DeviceKey Where tblCustDevices.State = 1) DERIVEDTBL Order By DERIVEDTBL.IPNumeric
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now