Close Menu
    Facebook X (Twitter) Instagram
    Sunday, July 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»CM2012»Configmgr 2012 SSRS Report count of IE Versions

    Configmgr 2012 SSRS Report count of IE Versions

    Eswar KonetiBy Eswar KonetiFebruary 11, 1:34 pm1 Min Read CM2012 1,841 Views
    Share
    Facebook Twitter LinkedIn Reddit

    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.

    Count of IE Versions fileversion Internet Explorer report report SCCM 2012 SQL query
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    Identifying devices managed by Intune but not reporting to WUfB using KQL

    November 09, 10:28 am

    10 Comments

    1. carol on April 8, 2016 3:18 AM

      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
      • Eswar Koneti on April 8, 2016 8:18 AM

        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
        • Carol on April 8, 2016 8:27 AM

          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
          • Eswar Koneti on April 8, 2016 8:29 AM

            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
            • Carol on April 8, 2016 8:33 AM

              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
              • Eswar Koneti on April 8, 2016 2:09 PM

                no problem carol, have a check the link i sent earlier

    2. shahid on November 12, 2015 1:31 PM

      Can add a column as Percentage of this IE versions too ?

      Reply
      • Eswar Koneti on November 17, 2015 9:38 AM

        I have updated here ,try it https://social.technet.microsoft.com/Forums/systemcenter/en-US/20013ccf-b997-4218-8a85-df5b0d5af094/sccm-reporting-ie-versions

        Reply
    3. Ruben DeLaRosa on September 22, 2015 4:49 AM

      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
      • Eswar Koneti on September 22, 2015 7:56 AM

        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/

        Reply

    Leave a ReplyCancel reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.