/build/static/layout/Breadcrumb_cap_w.png

Kace Report to Order PCs by Ship date

Hi all,

I have the following script to show all the PCs in Kace ordered by ship date.

SELECT DISTINCT(MACHINE.NAME), 
CS_MODEL, BIOS_SERIAL_NUMBER, USER_FULLNAME, USER_LOGGED,  MACHINE.OS_NAME, 
DA.SHIP_DATE AS "Ship Date",
MAX(DW.END_DATE) AS "Warranty End Date",
DW.SERVICE_LEVEL_DESCRIPTION as "Service Level"
FROM MACHINE
LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG
LEFT JOIN DELL_WARRANTY DW on MACHINE.BIOS_SERIAL_NUMBER = DW.SERVICE_TAG
WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
GROUP BY MACHINE.NAME
ORDER BY DA.SHIP_DATE, MACHINE.NAME

While it does work, it seems that there are 13 Dell PCs listed in the results that have no ship date, warranty end date or service level listed for them - those columns are just blank. Does anyone know of any reason that certain PCs would not have this data in Kace? And if not, any idea how I could enter it manually so that the results are properly populated?

Thanks!

1 Comment   [ + ] Show comment
  • I can plug this in and it works perfectly. However, it only shows Windows 7 OS. I know I have Windows 8 and 10, but this SQL code only shows Windows 7. I don't see anything in the code that chooses only windows 7; does anybody know why this isn't showing all OS? - jlackman 7 years ago

Answers (1)

Answer Summary:
Posted by: seanboy 7 years ago
Orange Belt
0

Top Answer

Never mind, I think I figured it out! I had to open the Device details page for each of the PCs (the ones with no shipping date etc) in the inventory. There, under 'Hardware > Device Service information' it said "There is no warranty information available for this device. Please hit 'Refresh' button to try again". I just clicked the Refresh button and it updated the Dell service info. After that, those PCs returned the correct information in my report. Thanks!

Comments:
  • Do you know when it changed/broke for those 13 Dells? Do they have any similarities (like model)? - JasonEgg 7 years ago
    • Nope! All different models and Operating Systems from what I could tell! - seanboy 7 years ago

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