Custom Warranty Report
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
-
Does the custom software title 142801 contain the warranty data for your computers? - chucksteel 9 years ago
-
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. - NSI_SJ 9 years ago
-
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? - chucksteel 9 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
