/build/static/layout/Breadcrumb_cap_w.png

Smart label for Old Adobe Flash Player

I developed a smart label that automatically detects Windows machines with an old version of Adobe Flash Player installed. The nice thing about the label is that it performs a query for the highest version in the inventory instead of having a version hard coded. Because of this as soon as one computer in the inventory gets the latest version of Flash Player any machines without that version will get the label the next time the check in.

Here's the SQL query for the label:

SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, MACHINE.MAC, MACHINE.ID as TOPIC_ID 
FROM MACHINE
LEFT JOIN MACHINE_SOFTWARE_JT ON (MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID)
LEFT JOIN SOFTWARE ON (SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and SOFTWARE.DISPLAY_NAME like "Adobe Flash Player 11%")
WHERE
((SOFTWARE.DISPLAY_VERSION != (SELECT MAX(DISPLAY_VERSION) from SOFTWARE WHERE DISPLAY_NAME like "Adobe Flash Player 11%")))
GROUP BY MACHINE.ID

This is limited to Flash Player 11 so once version 12 is released down the road the smart label will need to be updated.

To get this label setup in your environment you'll need to first create a smart label and then edit it to change the SQL code. The wizard will not allow you to enter the query.


Comments

  • Chuck very cool! Then after a machine is labeled with an outdated version what action do you take next? - Jbr32 10 years ago
    • I have noticed that our patching subscription is rather far behind when it comes to Flash Player versions so we are preparing to move to managed installs in order to keep it up to date. This smart label will be used in conjunction with other labels to target machines for those managed installs. - chucksteel 10 years ago
This post is locked
 
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