/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Smart Label for installed software

02/10/2016 2278 views
Is there a way that I can create a Smart Label for devices with a particular software installed on them? 
0 Comments   [ + ] Show comments

Comments



Community Chosen Answer

1
Yes! it is really straightforward.
Something like that:



If you need to target more than one software you can use "Matches Regex" instead of "contains" and separate the names of the software with the | character.

Kind regards,
Marco - StockTrader
 

Answered 02/10/2016 by: StockTrader
Red Belt

All Answers

0
Very easy

Here's what I did to see my desktops with Adobe Reader XI (11.0.14)

Devices-->Smart Label

Criteria:
Chassis Type = desktop
Software Titles begins with Adobe Reader XI
Software Version = 11.0.14

Here's the SQL code:

SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID FROM MACHINE  WHERE ((CHASSIS_TYPE = 'desktop') AND (( 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 'Adobe Reader XI%')) ) AND (( 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_VERSION = '11.0.14')) ))  

Answered 02/10/2016 by: rockhead44
Red Belt

  • Is there a way to identify which systems have the 32-bit build and which have the 64-bit?
    • This content is currently hidden from public view.
      Reason: Removed by member request For more information, visit our FAQ's.
    • Search for the specific name in Software to find the 64-bit version; From there plug that into your Smart Label as Software Title. Do the same for the 32-bit version

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