/build/static/layout/Breadcrumb_cap_w.png

Reporting customization in K1000

I'm just wondering if it's possible for Kace to generate a report showing total number of computers in each lab, together with computer warranty information.

Hope someone can help me.

2 Comments   [ + ] Show comments
  • How would you determine which lab a computer is in? Labels, naming convention, etc.?

    Also, if you are reporting the count of computers in a lab, a list of all of the warranty information will have to be in one column, which will be pretty messy. You could report on the minimum warranty date and maximum warranty date in each group, however. - chucksteel 7 years ago
  • Thanks for your reply. I have created a label for each lab. We name lab computers like 301-01, 403-03, etc. Computers in each lab have the same warranty end date. I don't think Kace count the number of computers in each room. Do you have any suggestion? - kzhangmit 7 years ago

Answers (1)

Posted by: chucksteel 7 years ago
Red Belt
0
I recommend placing your lab labels in a group, e.g. "Computer Labs". This report will then return what you requested:
SELECT LABEL.NAME as "Lab", COUNT(MACHINE.NAME) as Count, 
MAX(DW.END_DATE) AS "Warranty End Date"
FROM MACHINE
LEFT JOIN DELL_ASSET DA on MACHINE.BIOS_SERIAL_NUMBER = DA.SERVICE_TAG
LEFT JOIN DELL_WARRANTY DW on MACHINE.BIOS_SERIAL_NUMBER = DW.SERVICE_TAG
JOIN MACHINE_LABEL_JT on MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID
JOIN LABEL on LABEL.ID = MACHINE_LABEL_JT.LABEL_ID
JOIN LABEL_LABEL_JT on LABEL.ID = LABEL_LABEL_JT.CHILD_LABEL_ID
JOIN LABEL PARENT on PARENT.ID = LABEL_LABEL_JT.LABEL_ID
WHERE MACHINE.CS_MANUFACTURER like 'Dell%'
and PARENT.NAME = "Computer Labs"
GROUP BY LABEL.NAME
ORDER BY LABEL.NAME
If you use a different name for the label group, replace "Computer Labs" with "Your Label". The advantage to this method is that you can modify and add labels without needing to update the report. You can also create label groups for other groups. e.g. departments, locations, etc. And create reports for those groups, as well.

Comments:
  • Thank you so much for sharing the code with me. I will give it a try and let you know. - kzhangmit 7 years ago

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