‎12-29-2011 06:14 PM
Solved! Go to Solution.
‎12-29-2011 07:44 PM
Select Top 1000000 tblCustDevices.Displayname As [Device Name], tblCustDevices.Ipaddress, tblCustDevices.Model, tblstate.Statename, tblCustDevices.LastSeen, tblCustDevices.DeviceKey From tblCustDevices Inner Join tblstate On tblCustDevices.State = tblstate.State Inner Join tsysDevicetypes On tsysDevicetypes.ItemType = tblCustDevices.Devicetype Inner Join web40AllIPLocationsDev On tblCustDevices.DeviceKey = web40AllIPLocationsDev.DeviceKey Where tblstate.Statename = 'active' And tblCustDevices.DeviceKey Like '%.%' And tblCustDevices.Devicetype = 16 Order By tblCustDevices.Displayname
‎07-13-2012 04:43 PM
‎07-13-2012 11:45 AM
Select Top 1000000 tblComputers.Computername, tblComputers.Computer, tblComputerSystemProduct.IdentifyingNumber, tblCompCustom.Custom1 As AssignedTo, tblComputerSystemProduct1.Name, tblComputerSystemProduct1.Vendor, tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate, WarrantyStatus = Case When tblCompCustom.PurchaseDate + 1095 <= GetDate() + 90 And tblCompCustom.PurchaseDate + 1095 > GetDate() Then 'Needs Replacing Soon' When tblCompCustom.PurchaseDate + 1095 <= GetDate() Then 'Needs Replacing' End, web40AllIPLocations.IPLocation From tblComputers Left Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Left Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Inner Join tblComputerSystemProduct tblComputerSystemProduct1 On tblComputers.Computername = tblComputerSystemProduct1.Computername Inner Join web40AllIPLocations On web40AllIPLocations.Computername = tblComputers.Computername Where Case When tblCompCustom.PurchaseDate + 1095 <= GetDate() + 90 And tblCompCustom.PurchaseDate + 1095 > GetDate() Then 'Needs Replacing Soon' When tblCompCustom.PurchaseDate + 1095 <= GetDate() Then 'Needs Replacing' End Is Not Null
‎07-13-2012 01:49 AM
‎12-29-2011 08:13 PM
‎12-29-2011 07:44 PM
Select Top 1000000 tblCustDevices.Displayname As [Device Name], tblCustDevices.Ipaddress, tblCustDevices.Model, tblstate.Statename, tblCustDevices.LastSeen, tblCustDevices.DeviceKey From tblCustDevices Inner Join tblstate On tblCustDevices.State = tblstate.State Inner Join tsysDevicetypes On tsysDevicetypes.ItemType = tblCustDevices.Devicetype Inner Join web40AllIPLocationsDev On tblCustDevices.DeviceKey = web40AllIPLocationsDev.DeviceKey Where tblstate.Statename = 'active' And tblCustDevices.DeviceKey Like '%.%' And tblCustDevices.Devicetype = 16 Order By tblCustDevices.Displayname
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now