KACE Reporting - How to Filter by Label using Wizard
Greetings everyone! I'm on K1000 version 5.4.76847.
I'm trying to pull a report using the Report Wizard that will show me all systems that are still WinXP, have less than 2 GB of RAM, and are part of a particular smart label.
The problem comes when I try to set my filters. I can't find the way to filter by label. I get the XP part by choosing OS Name Contains XP, the memory with Total RAM < 2048. No worries there. I don't see a selection in the drop-down for labels, smart labels, machine labels... anything.
Please assist and thank you!
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
dugullett
10 years ago
Not sure about the wizard. I rarely use it. This should get you what you need though.
SELECT M.NAME, IP, USER_LOGGED, RAM_TOTAL FROM ORG1.MACHINE M LEFT JOIN MACHINE_LABEL_JT MLJT ON MLJT.MACHINE_ID=M.ID LEFT JOIN LABEL L ON L.ID = MLJT.LABEL_ID WHERE OS_NAME LIKE '%XP%' AND RAM_TOTAL < 2048 AND L.NAME LIKE '%<LABEL_NAME>%' ORDER BY M.NAME
Comments:
-
Thanks Dugullett! Is there somewhere I can go to see a layout of the table structure in order to be able to hone my reports on most matters? - MarcusTinBR 10 years ago
-
Download the MySQL tools. Let me know if you have questions.
http://dev.mysql.com/downloads/tools/workbench/
How to setup:
http://www.kace.com/support/resources/kb/article/can-i-access-the-k1000-appliance-database-using - dugullett 10 years ago
