/build/static/layout/Breadcrumb_cap_w.png

SQL Report for User and Warranty Info

I have tried this in SQL and with the wizard with middling results. I am trying to make a report that has user name, full name, asset tag, service tag, last inventory, Window Release version, and dell warranty expiration with days left. I cannot seem to get all these categories to play together. Any help is appreciated.


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 weeks ago
Red Belt
0

There is still some data you need to let us know to try and sort this, first you cant use the User as the initial field, as the user may have multiple devices, so I think it makes more sense to use the Device as the key field. We also need to know what you mean by Asset Tag, and where it is actually stored, as it can be in the Machine table, in the asset table or in the Barcode table. I have put together the following SQL that references the Asset Tag stored in the Barcode table.

SELECT MACHINE.NAME,

       MACHINE.USER_FULLNAME,

       MACHINE.LAST_INVENTORY,

       MACHINE.BIOS_SERIAL_NUMBER,

       MACHINE.OS_VERSION,

       DELL_WARRANTY.END_DATE,

       BARCODE.BARCODE_DATA,

       BARCODE.BARCODE_NAME

FROM (((ASSET    ASSET

        INNER JOIN ASSET_BARCODE_JT ASSET_BARCODE_JT

           ON (ASSET.ID = ASSET_BARCODE_JT.ASSET_ID))

       INNER JOIN MACHINE MACHINE ON (MACHINE.ID = ASSET.MAPPED_ID))

      INNER JOIN DELL_WARRANTY DELL_WARRANTY

         ON (MACHINE.BIOS_SERIAL_NUMBER = DELL_WARRANTY.SERVICE_TAG))

     INNER JOIN BARCODE BARCODE

        ON (ASSET_BARCODE_JT.BARCODE_ID = BARCODE.ID)

WHERE (BARCODE.BARCODE_NAME = 'Asset Tag')

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