/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Kace 1000 version 8 displays IE version under the OS section. Can I get a report on this finally?

12/08/2017 718 views
Going through the report wizard I'm not seeing how to do this, and there's no canned reports.

During a scan from a 3rd party I was told we have 9 PCs that haven't upgraded to IE11 yet.   Using Kace I can easily see what version someone is on by going to their inventory item and look under the OS section, but I don't really want to do that 283 times. :)

Thanks!
0 Comments   [ + ] Show comments

Comments


All Answers

0
In the sql code, that is simply referred to as IE_VERSION. In a saved sql query I have, I just added that and it worked fine, so try this. This can be customized to your hearts content. It's just something I have saved for lists I was generating along the way. The lines that start with # are commented out, just uncomment if you want to see that field. And there are plenty of other fields that you can grab, that I didn't include:
SELECT 
UPPER(NAME) as NAME,
BIOS_SERIAL_NUMBER as ASSET_TAG,
#SYSTEM_DESCRIPTION,
OS_NAME,
OS_BUILD,
IP,
IE_VERSION,
LAST_INVENTORY,
#MAC,
CS_DOMAIN,
REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as USER_LOGGED,
#SERVICE_PACK,
#SYSTEM_DIRECTORY,
#RAM_TOTAL,
#CS_MANUFACTURER,
CS_MODEL,
BIOS_NAME,
BIOS_VERSION
FROM ORG1.MACHINE
GROUP BY NAME

Answered 12/08/2017 by: five.
Second Degree Green Belt

0
You could aslo create a custom inventory rule to bring those IE version values, and then build a smart label out of this.
(like, Label - IE 10, will list all devices with IE10).

http://www.itninja.com/blog/view/kace-custom-inventory-rules-101
Answered 12/08/2017 by: Channeler
Red Belt

 
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