/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Custom Warranty Report

11/13/2015 1628 views
Hi,

First time submitter, hoping to get a little help on a custom SQL report.  Here is what I have so far:

SELECT CS_MANUFACTURER AS MANUFACTURER,CS_MODEL AS MODEL,(SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE
FROM MACHINE_CUSTOM_INVENTORY
WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=142801) AS Lenovo_Models,
CHASSIS_TYPE AS FORM_FACTOR, COUNT(CS_MODEL) AS COUNT
FROM MACHINE
GROUP BY CS_MODEL
ORDER BY COUNT DESC

Right now it does a count on all models, but I'd like it to dive down into each model and report back the user as well as the warranty end date for anything ending in x days.  I've tried to combine information from other reports, but not having a lot of luck.  Thanks in advance for any assistance.  
2 Comments   [ + ] Show comments

Comments

  • Does the custom software title 142801 contain the warranty data for your computers?
  • I have that so it pulls the actual model name, versus what KACE sees as a long numerical value. It doesn't have the warranty data. I do have the warranty data in the asset type though that I import that I would like to pull from.
    • You will need to link to the tables containing the warranty data for this report. Do you have a tool like MySQL Workbench setup so you can look at the database?

Be the first to answer this question

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