SQL query to get ship date on Dell machines
SELECT
DELL_ASSET.Service_TAG as 'Service Tag',
DELL_ASSET.SHIP_DATE as 'Ship Date',
DELL_ASSET.MACHINE_DESCRIPTION as 'Machine Description',
MACHINE.IP as 'IP',
MACHINE.NAME as 'System Name'
FROM
DELL_ASSET
JOIN MACHINE
ON SERVICE_TAG = BIOS_SERIAL_NUMBER
WHERE SHIP_DATE > '2015'
Order by Ship_Date;
Please just remember to modify the SHIP_DATE.
Comments