/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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":
5YwbAr.png
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:
MEhw3j.png
My report is filtered as follows:
5hPXQC.png

I have tried all of the filters that to me seem like they should work.

I tried these filters as well:
ubS05d.png
But, no luck.

Using these filters give me these results:
rAmXhI.png

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

Comments


All Answers

1
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
Answered 06/14/2018 by: JasonEgg
Red Belt