Configmgr 2012 SSRS Report count of IE Versions

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 ?

image

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 Responses to "Configmgr 2012 SSRS Report count of IE Versions"

  1. 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?

    Reply
    1. 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

      Reply
      1. 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.

        Reply
        1. 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

          Reply
          1. 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!!

            Reply
  2. 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.

    Reply

Leave a Reply to Ruben DeLaRosa Cancel reply