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

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.
    • 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.
  • 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!
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share