/build/static/layout/Breadcrumb_cap_w.png

Kace - Help with Warranty Report

Hello,

To preface, I'm brand new to KACE and brand new to using SQL to make reports.  I'm looking to create a report that displays only machines applied to a specific label.  In my case the label name is "WRK_ACTIVE".  My issue with the reports that exist, is that they all display multiple lines for each type of support/warranty that the machines have.  I did find the below code on this forum which does give me just one line of detail, but I can't seem to add the write code to make sure it only prints for the label I want.  Below is what I'm using (I've tried to add L.NAME = 'WRK_ACTIVE in the appropriate section but it doesn't work for me).  Any help or links to other reports would be appreciated.

SELECT DISTINCT M.NAME AS MACHINE_NAME,M.CS_MODEL AS MODEL, OS_NAME, DA.SERVICE_TAG, DA.SHIP_DATE,

M.USER_LOGGED AS LAST_LOGGED_IN_USER, DW.END_DATE AS EXPIRATION_DATE

FROM DELL_WARRANTY DW

LEFT JOIN DELL_ASSET DA ON (DW.SERVICE_TAG = DA.SERVICE_TAG)

LEFT JOIN MACHINE M ON (M.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG OR M.BIOS_SERIAL_NUMBER = DA.PARENT_SERVICE_TAG)

LEFT JOIN MACHINE_LABEL_JT ML ON (M.ID = ML.MACHINE_ID) 
LEFT JOIN LABEL L ON (ML.LABEL_ID = L.ID) 

WHERE M.CS_MANUFACTURER LIKE '%dell%' AND M.BIOS_SERIAL_NUMBER!='' AND DA.DISABLED != 1

AND DW.END_DATE = (SELECT MAX(END_DATE) FROM DELL_WARRANTY DW2

WHERE DW2.SERVICE_TAG=DW.SERVICE_TAG AND DW2.SERVICE_LEVEL_CODE=DW.SERVICE_LEVEL_CODE)
ORDER BY EXPIRATION_DATE, DW.SERVICE_LEVEL_DESCRIPTION

2 Comments   [ + ] Show comments
  • Sorry... I should have mentioned the report I'm looking to print just shows warranty information :-) - jdrouillard 9 years ago
  • Sorry, I should have mention this is for a Warranty Listing on specific machines. - jdrouillard 9 years ago

Answers (0)

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ