Smart Label for installed software
Is there a way that I can create a Smart Label for devices with a particular software installed on them?
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
StockTrader
8 years ago
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
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
Posted by:
rockhead44
8 years ago
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')) ))
Comments:
-
Is there a way to identify which systems have the 32-bit build and which have the 64-bit? - inds 8 years ago
-
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 - rockhead44 8 years ago
