Reporting...
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
6 years ago
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
