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?
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity