Currently we have the Audit Settings set to Daily scan, but what all does this scan? Just workstations, or Workstations and printers?etc
Also, We added additional fields in the Asset - Additional Fields, called Product Model (Pick list) and Product Location (single-line). These are primarily regarding to Printers
How can we include those fields into a query that can display the % supplies remaining for each printer listed by Product Location?
Currently for the Query we have:
select p.name'Printer Name',pm.MARKERSUPPDESC'Marker Supply Description',pm.MARKERSUPPMAXCAPACITY'Max Level',pm.MARKERSUPPLEVEL'Current Level',(pm.MARKERSUPPLEVEL) * 100/pm.MARKERSUPPMAXCAPACITY'% Remaining' from printer p left join printermarkersuppsubunits pm on p.resourceid=pm.resourceid order by 1
But we would like to list the information from the new fields that we just added.