/build/static/layout/Breadcrumb_cap_w.png

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?


1 Comment   [ + ] Show comment
  • Hi Joshua, I'm an SE with the KACE team, when you have an opportunity, email me at Jillian.Salamon@quest.com. I wanted to pick your brain on assets/barcode. - Jillsy 3 years ago

Answers (3)

Posted by: KevinG 3 years ago
Red Belt
1

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.



Posted by: Hobbsy 3 years ago
Red Belt
0

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)




Comments:
  • Figured it would be some custom SQL report but don't know SQL so guess it will be a manual process - joshua.velez 3 years ago
Posted by: jallen98405 1 year ago
White Belt
0
Tagging an old post, but worth a try. How do we add the Asset Status field with the SQL shown above?

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ