Exporting Barcode Data
I am trying to export barcode data to excel as I need to do an overhaul on our inventory. Is this possible to do?
Use the reporting module. Select create a new SQL report.
Here is SQL to copy/paste.
Select A.NAME as 'Asset Name', B.*
from ASSET A
join ASSET_BARCODE_JT ABJT on ABJT.ASSET_ID = A.ID
join BARCODE B on B.ID = ABJT.BARCODE_ID
This SQL should get you started. It can be modify to meet your needs.
KACE has a fee based Professional Services group that can write reports, Ticket Rules.
Other services are also available.
Email email@example.com for a quote or more information about the services they provide.
You are probably best to do that using a report and running it as a CSV or XLS format.
The barcode data sits within a single table BARCODE and joins to the Asset table using ASSET_BARCODE_JT, so if you also need to get things like Asset name you will need to write a custom SQL report to capture the fields that you will need
Try this code
FROM ((ASSET ASSET
INNER JOIN USER USER ON (ASSET.OWNER_ID = USER.ID))
INNER JOIN ASSET_BARCODE_JT ASSET_BARCODE_JT
ON (ASSET_BARCODE_JT.ASSET_ID = ASSET.ID))
INNER JOIN BARCODE BARCODE
ON (BARCODE.ID = ASSET_BARCODE_JT.BARCODE_ID)