This is updated post for long ago blogged post http://eskonr.com/2010/04/sccm-reportcollection-for-computers-with-internet-explorer-with-different-versions/.
are you in search of getting summary of IE Versions ,so that you can plan for the migration of Old IE Versions to current version ?
Below is the SSRS/SQL report which will help you to get count of IE Versions and total.
SQL Query used in Report(if you are still running on SCCM 2007):
select
replace(left(SF.FileVersion,2), '.','') as 'IE Version',
Count (Distinct SF.ResourceID) as 'Total'
From
dbo.v_GS_SoftwareFile SF
Where
SF.FileName = 'iexplore.exe'
and SF.FilePath like '%Internet Explorer%'
Group by
replace(left(SF.FileVersion,2), '.','')
Order by
2 desc
Note:Replace the quotes with original.
SSRS Report attached here. Download the rdl file and upload to your SSRS report folder.
10 Comments
Hi, I really appreciate your site and your reports! My only thought would be to allow the report to be run against SCCM collections. For instance, I want to run a separate report for workstations than for servers. Basically, the report is the same but provides totals based on the collection (workstations/servers) and not all operating systems grouped together. I have been able to populate the collections but am having difficulty with the count.
Any thoughts on how I can do this?
Hi Carol,
if i understood your question correctly, you want to have same results against specific collection? if so, you can simply inner join full collection membership, but again, are you using this report in cm07 or cm12? if cm12 and above versions, there is delay in software inventory to process/software inventory is very slow and not recommended to use, instead you can use configuration item to query Internet Explorer versions. pls refer this blog post how this to be done http://mnscug.org/blogs/sherry-kissinger/374-using-configuration-items-instead-of-software-inventory
Hi, wow quick response! Yes you are right, our admins have created multiple collections so I need the ability to run against different collections. I have been racking my brain very unsuccessfully.
Hi Carol,
it is possible to do it but, are you using this report in cm07 or cm12? if cm12 and above versions, there is delay in software inventory to process/software inventory is very slow and not recommended to use, instead you can use configuration item to query Internet Explorer versions. pls refer this blog post how this to be done http://mnscug.org/blogs/sherry-kissinger/374-using-configuration-items-instead-of-software-inventory
Thank you, it is 2012 and I did not realize it was not recommended. I will check out the link asap. I really appreciate your help!!
no problem carol, have a check the link i sent earlier
Can add a column as Percentage of this IE versions too ?
I have updated here ,try it https://social.technet.microsoft.com/Forums/systemcenter/en-US/20013ccf-b997-4218-8a85-df5b0d5af094/sccm-reporting-ie-versions
Does anyone know that only to get the base version but the patch version which states what the latest patch installed on internet exlorer, I have no I idea what table this is in.
try this how to get internet explorer information via hardware inventory in better way http://myitforum.com/myitforumwp/2014/05/19/internet-explorer-version-information-via-hardware-inventory/