/build/static/layout/Breadcrumb_cap_w.png

Help needed for a K1000 SQL Query

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 :)


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
Posted by: feeldamped 4 years ago
Third Degree Blue Belt
1

Top Answer

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')) 
Posted by: sven.hain 4 years ago
Green Belt
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.


Comments:
  • 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) - c.castellari 4 years ago
    • 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. - sven.hain 4 years ago
      • Ok, thanks. I'll study the patching system.
        Thank you :) - c.castellari 4 years ago
 
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