/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Custom Warranty Report

11/13/2015 1556 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