KACE Product Support

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 remoteconfig@quest.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

SELECT ASSET.NAME,

       BARCODE.BARCODE_DATA,

       BARCODE.BARCODE_NAME,

       USER.USER_NAME

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)