Systems Management

Can you try this? We don't have a lot of machines with FireFox so just check if this helps. Joined the machine table to the query.

SELECT DISPLAY_NAME,
         PUBLISHER,
         SOFTWARE.ID AS TOPIC_ID,
         MACHINE.NAME
FROM SOFTWARE
INNER JOIN MACHINE_SOFTWARE_JT ON SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
INNER JOIN MACHINE ON MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID	
WHERE ((DISPLAY_NAME LIKE '%Mozilla Firefox%')
        AND (DISPLAY_NAME LIKE '%x64%')
        AND (( EXISTS 
    (SELECT 1
    FROM MACHINE, MACHINE_SOFTWARE_JT
    WHERE SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
            AND MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID
            AND MACHINE.NAME > '0')) )
            AND (DISPLAY_VERSION < '67.0.4')) 

Hi,

maybe the following query helps you:

Select    MACHINE.NAME,    SOFTWARE.DISPLAY_NAME,    SOFTWARE.PUBLISHER,    SOFTWARE.ID As TOPIC_IDFrom    SOFTWARE Inner Join    MACHINE_SOFTWARE_JT On MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID Inner Join    MACHINE On MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.IDWhere    SOFTWARE.DISPLAY_NAME Like '%Mozilla Firefox%' And    SOFTWARE.DISPLAY_NAME Like '%x64%' And    Exists(Select         1     From         MACHINE,         MACHINE_SOFTWARE_JT     Where         MACHINE_SOFTWARE_JT.MACHINE_ID = MACHINE.ID And         SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID And         MACHINE.NAME > '0') And    SOFTWARE.DISPLAY_VERSION < '67.0.4'

But I have a question. Is it a default firefox package what you want to deploy or is it a custom package? Because if you already deploy a custom package in your managed installs, you can try it with the patch management of the SMA and then you do not need such a label.