/build/static/layout/Breadcrumb_cap_w.png

KACE 1000 - Report for software not installed on a machine

I am trying to write a report that would list machines that do not have our AV software installed. I do not have a lot of SQL experience, and this one is proving to be tougher than expected.


0 Comments   [ + ] Show comments

Answers (3)

Posted by: dugullett 11 years ago
Red Belt
0

I'm not a SQL person either, but I think it would be easier to create a smart label for "software titles > != > name of software"? To start you out.


Comments:
  • That's a good idea. Once you create the smart label you'll be able to copy the SQL code as a good place to start making the report. - chucksteel 11 years ago
Posted by: adilrathore 11 years ago
4th Degree Black Belt
0

You can also first list the workstations that have AV installed, and then use the not in function exclude these workstations from your overall managed workstations list in the database.

Posted by: merrymax 11 years ago
Senior Purple Belt
0

Please use the below SQL Statment to display machines which have specific software installed , you can change " NOT Like " in the below query to get the report of systems which does not have below application.

OR

Create a smart label for machine which does not have specific software installed and create the report on the basis of this label.

 

 

 

select LABEL.NAME as LABEL_NAME,
MACHINE.NAME as MACHINE_NAME, IP, CLIENT_VERSION, MAC, REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as USER_LOGGED, 
SOFTWARE.DISPLAY_NAME as SOFTWARE_NAME
from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE,
MACHINE_LABEL_JT, LABEL)
where
MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID AND
MACHINE_LABEL_JT.LABEL_ID = LABEL.ID
AND
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID and
SOFTWARE.DISPLAY_NAME like
'KBOX Agent' and LABEL.TYPE !='hidden' order by LABEL_NAME

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