/build/static/layout/Breadcrumb_cap_w.png

Is there a way to query KACE to get it to show devices with its Internet Explorer version along with the version of Google Chrome and Firefox?

ITNinja @rock_star was kind enough to give us a query which shows the Internet Explorer version installed on a device. Is there a way to modify this query to get the version of Google Chrome and Firefox, if also installed on the device?

SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, LAST_SYNC, IE_VERSION FROM MACHINE ORDER BY SYSTEM_NAME
Thank you in advance!





2 Comments   [ + ] Show comments
  • If you are SQL Savvy you can join the necessary software tables with your machine table to generate your results. May I ask what end result you're trying to get?
    Reason I ask is that I would do something like this to standardize versions. If that's the goal, you can use the built in tools to do that. - Soloman007 7 years ago
    • Thanks Soloman007, Unfortunately, I am not SQL savvy. I would like a report which shows the version of IE, and if it has Chrome or Firefox installed, the versions of those.

      I hope it would look something like the following (the underscores are for formatting purposes) :

      SystemName______IE_Version_____Chrome Version______Firefox Version
      ComputerA________11.0.xxxxxxxx_____________________45.xxxxxxxx
      ComputerB________ 9.0.xxxxxxxx___52.0
      ComputerC________10.0.xxxxxxx
      ComputerD________11.0.xxxxxxxx___52.xxxxxx__________47.xxxxxxx

      If there is something built-in, I would gladly run that. Thank you very much for your time, Soloman007. It is appreciated. - eschmidt2050 7 years ago
  • You can try this:
    1. Use the report wizard and create a new report
    2. Chose first topic Software second topic Device
    a. Check the box that says: "Only show rows..."
    3. From Fields to Display Select the following:
    a. Software - Display Name, Display Version
    b. Device - System Name
    4. Column Order
    a. Software Display Name then Version Name
    5. Sort and Breaks
    a. Order by Display Name Asc then Ver Asc
    6. Filters - Software
    a. Change to "Match any of the following"
    b. Display Name = Google Chrome
    c. Display Name Begins with Mozilla Firefox
    7. Save and run HTML format

    This won't give you the list you are looking for, but it will give you every version that has at least 1 PC using it, and list all the PCs using that version. (kind of a reverse lookup) Not as pretty but built in and easy to do.

    Hope this helps! - Soloman007 7 years ago

Answers (0)

Be the first to answer this question

 
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