/build/static/layout/Breadcrumb_cap_w.png
03/16/2018 402 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:

SELECT MACHINE.NAME, 
MACHINE.OS_NAME, 
MACHINE.CS_MODEL, 
MACHINE.CS_MANUFACTURER, 
DA.SHIP_DATE AS "Ship Date"
FROM MACHINE
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


0 Comments   [ + ] Show comments

Comments


All Answers

0
Since all of the fields in the wizard report are from the MACHINE table it is easy to combine them with the Ship Date Report:
SELECT MACHINE.NAME, 
MACHINE.OS_NAME, 
MACHINE.CS_MODEL, 
MACHINE.CS_MANUFACTURER, 
DA.SHIP_DATE AS "Ship Date",
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
LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG


Answered 03/19/2018 by: chucksteel
Red Belt