03/16/2018 428 views
With the help of IT Ninja, I have found the SQL to get Ship Date data for Dell products. Question: Is there a way to get this data with the wizard? I ask because I need a few more fields. This is the Ship Date SQL:
DA.SHIP_DATE AS "Ship Date"
LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG
My other report, created using the Wizard, shows:
SELECT USER_DOMAIN, USER_FULLNAME, USER_LOGGED, MACHINE.USER_NAME, BIOS_DESCRIPTION, BIOS_IDENTIFICATION_CODE, BIOS_MANUFACTURER, BIOS_NAME, BIOS_RELEASE_DATE, BIOS_SERIAL_NUMBER, BIOS_VERSION, CHASSIS_TYPE, CSP_ID_NUMBER, CS_MANUFACTURER, CS_MODEL, CS_DOMAIN, MACHINE.IP, MACHINE.NAME AS SYSTEM_NAME, LAST_SYNC FROM MACHINE ORDER BY USER_DOMAIN