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

Please log in to comment

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

Please log in to comment

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

Share