/build/static/layout/Breadcrumb_cap_w.png
06/24/2019 160 views

Hi everyone.

I have to find all the PCs with a Firefox version later than the latest 67.0.4

I made a Software Smart Label like this:

SELECT DISPLAY_NAME,
         PUBLISHER,
         SOFTWARE.ID AS TOPIC_ID
FROM SOFTWARE
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')) 


How can i obtain a list with the PC names?? Later, i have to develop a massive upgrade job for upgrading all the Firefox to the 67.0.4


Thank you :)

Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

1

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')) 
Answered 06/24/2019 by: feeldamped
Second Degree Blue Belt

All Answers

0

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.

Answered 06/24/2019 by: sven.hain
Senior White Belt

  • Both the codes seems working well. Now i'm waiting some pc completes their inventory, but the code seems good :)

    Answer for your question: the patching management seems a better idea, but i've never used it and i don't know how to schedule a safe patch management for Firefox (is the standard version, not custom; many our pc has an older and insecure Firefox so i have to oupdate all of them to the latest 67.0.4, starting from the 64bit ones)
    • You can take a look into our administrator guide, how our patch management works and what you can do to use it. The patching is not only for firefox. You can use it for many other third party vendors, as well. It safes you a lot of time and your environment is more secure automatically.

      https://support.quest.com/technical-documents/kace-systems-management-appliance/9.1%20common%20documents/administrator-guide/169#TOPIC-1103911

      If you are not sure and you need help, please contact your sales person where you bought KACE. They can help you to get consultants for that.
      • Ok, thanks. I'll study the patching system.
        Thank you :)