KACE Product Support Question
Kace Report to Order PCs by Ship date
02/07/2017 1830 views
I have the following script to show all the PCs in Kace ordered by ship date.
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"
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?
Answer Chosen by the Author
Please log in to 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!
Answered 02/07/2017 by: seanboy