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
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%")
((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.