Zoom has announced a nine month release window for supported versions that will go into effect on November 1st. Rather than create a smart label based on explicit version numbers that will need to be updated frequently, I decided to use the created date in the software inventory to find versions that are more than 9 months old.SELECT SOFTWARE.ID, SOFTWARE.MODIFIED, SOFTWARE.CREATED, SOFTWARE.DISPLAY_NAME, SOFTWARE.DISPLAY_VERSION,
MACHINE.NAME AS SYSTEM_NAME, MACHINE.SYSTEM_DESCRIPTION, MACHINE.IP,
MACHINE.MAC, MACHINE.ID as TOPIC_ID
JOIN MACHINE_SOFTWARE_JT MSJT on MSJT.SOFTWARE_ID = SOFTWARE.ID
JOIN MACHINE on MACHINE.ID = MSJT.MACHINE_ID
WHERE SOFTWARE.DISPLAY_NAME = "Zoom"
and SOFTWARE.CREATED < date_sub(now(), INTERVAL 9 MONTH)This label will apply to computers that have an unsupported version of Zoom and can be tied to a managed install that will install an updated version. That managed install will need to be updated regularly.