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

Comments

Please log in to comment

Answers

4

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
Answered 10/03/2012 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share