Report Requests
Warranty and specific label
Has anyone been able to create a warranty expiration report which contains computers in a particular label? For example, I want the warranty expiration information for all of my Dell computers and I want the report to only include computers in my label Engineering Department. That or if I can have the warranty report include IP addresses, it would work, as well.
If you have and you can share, I'd greatly appreciate it. Thanks!
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
dugullett
12 years ago
From http://www.itninja.com/question/kace-create-dell-warranty-report
For Label:
SELECT DISTINCT M.NAME AS MACHINE_NAME, M.CS_MODEL AS MODEL, DA.SERVICE_TAG, DW.SERVICE_LEVEL_DESCRIPTION, DW.SERVICE_PROVIDER, DW.END_DATE AS EXPIRATION_DATE FROM KBSYS.DELL_WARRANTY DW JOIN KBSYS.DELL_ASSET DA ON (DW.SERVICE_TAG = DA.SERVICE_TAG) JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG OR M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG) JOIN MACHINE_LABEL_JT ML ON (M.ID = ML.MACHINE_ID) JOIN LABEL L ON (ML.LABEL_ID = L.ID) WHERE M.CS_MANUFACTURER LIKE '%dell%' AND M.BIOS_SERIAL_NUMBER!='' AND DA.DISABLED != 1 #ADD LABEL AT THIS LINE AND L.NAME LIKE 'Engineering Department%' ORDER BY MACHINE_NAME, EXPIRATION_DATE DESC, DW.SERVICE_LEVEL_DESCRIPTION
For IP Address:
SELECT DISTINCT M.NAME AS MACHINE_NAME, M.CS_MODEL AS MODEL, DA.SERVICE_TAG, DW.SERVICE_LEVEL_DESCRIPTION, DW.SERVICE_PROVIDER, DW.END_DATE AS EXPIRATION_DATE FROM KBSYS.DELL_WARRANTY DW JOIN KBSYS.DELL_ASSET DA ON (DW.SERVICE_TAG = DA.SERVICE_TAG) JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG OR M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG) JOIN MACHINE_LABEL_JT ML ON (M.ID = ML.MACHINE_ID) JOIN LABEL L ON (ML.LABEL_ID = L.ID) WHERE M.CS_MANUFACTURER LIKE '%dell%' AND M.BIOS_SERIAL_NUMBER!='' AND DA.DISABLED != 1 #ADD IP AT THIS LINE AND M.IP LIKE '10.0.0.1%' ORDER BY MACHINE_NAME, EXPIRATION_DATE DESC, DW.SERVICE_LEVEL_DESCRIPTION
