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?
Thank you in advance!
| SELECT MACHINE.NAME AS SYSTEM_NAME, SYSTEM_DESCRIPTION, MACHINE.IP, LAST_SYNC, IE_VERSION FROM MACHINE ORDER BY SYSTEM_NAME |
2 Comments
[ + ] Show comments
Answers (0)
Please log in to answer
Be the first to answer this question
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 8 years ago
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 8 years ago
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 8 years ago