‎10-07-2011 01:46 AM
‎10-11-2011 09:38 PM
‎10-07-2011 12:25 PM
Select Top 1000000 tsysDevicetypes.ItemTypeIcon10 As icon,
tblCustDevices.Displayname As [Device name], tblCustDevices.Model As
[Device model], tblCustDevices.DeviceKey,
Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
100) As [Remaining %], tblCustDevPrinter.Tonername,
tblCustDevPrinter.Lastchanged
From tblCustDevices Inner Join
tsysDevicetypes On tsysDevicetypes.ItemType = tblCustDevices.Devicetype
Inner Join
tblCustDevPrinter On tblCustDevPrinter.DeviceKey = tblCustDevices.DeviceKey
Where tblCustDevices.Displayname <> 'YourCopier' And
Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum *
100) <= 10 And tblCustDevices.State = 1 And tblCustDevPrinter.TonerMaximum > 0
Order By Floor(tblCustDevPrinter.TonerRemaining / tblCustDevPrinter.TonerMaximum
* 100)
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now