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!

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0

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
Answered 08/19/2013 by: dugullett
Red Belt

  • 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?
    • 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
Please log in to comment
Answer this question or Comment on this question for clarity