KACE Reporting Wizard not reporting everything in Dell Warranty list
My end goal here is to create a report that will list every PC on our system that has any expired Dell warranty's; this list will then show every expired warranty for each PC, as well as warranties that will be expiring at the end of the year. For reasons unknown, I have been unable to achieve these results. Unfamiliar with SQL, I've been working with the KACE Reporting wizard. I will try to explain the troubles I am experiencing below.
Now, this is what I want to be pulled into my report.
When pulled into a report, I simply cannot get all 5 items to show up:
My report is filtered as follows:
I have tried all of the filters that to me seem like they should work.
I tried these filters as well:
But, no luck.
Using these filters give me these results:
I have noticed that sometimes the results of a report, when unchanged from before but run again, will be inconsistent with it's original results.
So, what gives? Any ideas?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
JasonEgg
6 years ago
I don't know why the wizard isn't working. Here's a quick-and-dirty SQL query to get all the details:
SELECT MACHINE.ID,
MACHINE.NAME,
DELL_WARRANTY.*
FROM MACHINE
JOIN DELL_WARRANTY ON MACHINE.BIOS_SERIAL_NUMBER = DELL_WARRANTY.SERVICE_TAG
