Kace 1000 version 8 displays IE version under the OS section. Can I get a report on this finally?
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
Answers (2)
Please log in to answer
Posted by:
five.
6 years ago
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
Posted by:
Channeler
6 years ago
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
(like, Label - IE 10, will list all devices with IE10).
http://www.itninja.com/blog/view/kace-custom-inventory-rules-101
