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.
Answers (1)
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')
