/build/static/layout/Breadcrumb_cap_w.png

SQL query to get ship date on Dell machines

I created a simple query to get Dell machines' ship date. Hope you guys like it :)

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

This post is locked
 
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