/build/static/layout/Breadcrumb_cap_w.png

Software Deployment Question


Kace Report

03/08/2016 618 views

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:
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

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
Red Belt

 
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