Clients in Collection Active, Software inv. on, but only fraction report IE

[thekurgan1536]

Hi guys.

 

Running sccm 2012, version 5.00.8239.1000, build number 8239. Due to our environment and severally behind code from our internal coders, we have to use an older version of IE for many of our custom apps. We're trying to get a count of each IE version running in the environment across the country. Specifically our desktops (servers don't matter for this). I'm using the All Desktop Clients collections which has 5407 clients in it. Majority of the clients (like 98%) report in active. Because I don't trust my query building skills, I found Anoop's sql one. https://www.anoopcnair.com/2015/10/19/sccm-configmgr-2012-sql-query-to-find-out-ie-version-with-os-details-of-workstations/. His query searches all systems I believe, but it can be used to filter out servers afterwards. I only come up with about 431 clients after running it roughly. It's about 471 clients if I don't modify his query. Software inventory for all exe's has been enabled for years. So it's not that.

 

Does anyone have any steps to take to identify the issue?

 

 

Thanks,

 

 

[GarthMJ]

First off, I would never inventory all EXEs. This will have problems and give you unreliable results.

Secondly, use HW inventory to collect this data. https://www.mnscug.org/blogs/sherry-kissinger/330-internet-explorer-version-information-via-hardware-inventory

 

[thekurgan1536]

Thanks Garth. I've inherited an existing system and that's how it was configured. I'll take a look at your link and try to go from there.