MYSQL Details Information

[Lhsachs]

Our goal is to collect all the printers listed in the computer details printer window. We know it is in MYSQL. Just need to know which table it is in. When exporting the jamfsoftware printers table from mysql, all we get are the printers that were added to Casper. (network printers)

The locally attached USB printers are in computer details with their serial numbers along with any network printers the user attaches to. Has any one been able to export this data? Which table is it in?

[Lhsachs · Accepted solution]

I have a solution - thanks to Tim at JAMF:
................................................................................
mysql -u root -p
(log in with password)

USE jamfsoftware;

select * from jamfsoftware.package_receipts where type="printer" into outfile '/tmp/inventoryprinters.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY ' ';
................................................................................
The will export a list of printers. You can extract the USB printers filtering in excel. The serial numbers of the USB printers are in the USB line.