/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


KACE Reporting Wizard not reporting everything in Dell Warranty list

05/30/2018 1119 views
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ