Hello,

 I would like to run a kace report that tells me which computers do not have a certain agent installed. Any help would be a great help.


Thanks,

Tim

Answer Summary:
Cancel
2 Comments   [ + ] Show Comments

Comments

  • Do you mean which computers don't have a specific version of the KACE agent?
    • No which computers don't have the bit9 agent installed. Thanks
    • No which computers don't have the bit9 agent installed. Thanks
  • rockhead this tell me which computer have the agent installed. I need a quary that tells me which computers do not have the agent installed.

    Thanks for your help.
    Tim
    • Sorry about that...Replace X with your software title.Let me know if this works for you and I'll edit my "answer" below

      SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE (((not exists (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like '%X%')) ))
      • This seemed to work I have to do some looking into of what it found. Thx for your help.
      • Glad that worked for you
Please log in to comment

Answer Chosen by the Author

0
SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE WHERE (((not exists (select 1 from SOFTWARE, MACHINE_SOFTWARE_JT where MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like '%X%')) ))
===============================================
Replace  'X' in:  WHERE DISPLAY_NAME = 'X' with your software name


That's a template I use

Answered 03/08/2016 by: rockhead44
Tenth Degree Black Belt

Please log in to comment

Answers

Answer this question or Comment on this question for clarity