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.
So, for example, here is the Dell warranty information under "WINPC266":
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?