/build/static/layout/Breadcrumb_cap_w.png

Zoom 9-month release window

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
FROM ORG1.SOFTWARE
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.


Posted 3 years ago 1323 views

Comments

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