SQL Report Based on Inventory with Shipdates Greater Than 3 Years (4272722)

The information in the script(s) provided is known to work successfully; however, they have not been officially tested by our Quality Control.

If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by our Support and Development.

Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.

For customization of the KACE Systems Management Appliance, please contact our Professional Services Organization.

SELECT
    MACHINE.NAME AS MACHINE_NAME,
    MACHINE.CS_MODEL AS MODEL,
    DELL_ASSET.SERVICE_TAG,
    DATE(DELL_ASSET.SHIP_DATE) AS 'SHIP DATE'
FROM
    DELL_ASSET
        LEFT JOIN
    MACHINE ON MACHINE.BIOS_SERIAL_NUMBER = DELL_ASSET.SERVICE_TAG
WHERE
    MACHINE.CS_MANUFACTURER LIKE '%dell%'
        AND (DELL_ASSET.SHIP_DATE < DATE_SUB(NOW(), INTERVAL 3 year))
ORDER BY DELL_ASSET.SHIP_DATE , MACHINE.NAME