/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Exporting Barcode Data

07/15/2020 118 views

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

Comments

  • 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.


Community Chosen Answer

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.



Answered 07/15/2020 by: KevinG
5th Degree Black Belt

All Answers

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)



Answered 07/15/2020 by: Hobbsy
Red Belt

  • Figured it would be some custom SQL report but don't know SQL so guess it will be a manual process

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