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:
Please log in to answer
Posted by:
seanboy
7 years ago
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!