locked
SCCM Reporting IE Versions RRS feed

  • Question

  • I have this report that gives me a list of all the IE versions:

    select distinct count(c.FileDescription +' '+left(c.fileversion,3)), c.FileDescription +' '+left(c.fileversion,3) 
    from v_r_system a inner join v_gs_Operating_system b on a.resourceid=b.resourceid 
    inner join v_GS_SoftwareFile c on a.resourceid=c.resourceid 
    where c.FileName = 'iexplore.exe' AND c.FilePath like 'C:\prog%internet%' 
    and (a.client0=1 and a.Obsolete0=0 and a.Active0=1) 
    Group By c.FileDescription +' '+left(c.fileversion,3) 
    with ROLLUP 

    I would like to link the report so management can see who has which versions on their own without me doing all the work. :)

    Tuesday, June 4, 2013 3:22 PM

Answers

  • you will have to create another report with list of computers ,prompting its IE version.So when you select the IE version,it should display all the computers who have it.

    once you are done with it,go to properties of this report and link the IE(what u have) report what u created-->go to links_>link type.The prompt for the above report would be output of IE version report.

    For more info how to create links follow Ex: Count of MS office  http://eskonr.com/2012/05/sccm-linked-report-ms-office-version-with-service-pack-installed-machines/

    For Percentage of IE Versions,

    Declare @countval float
    select @countval = COUNT(distinct Resourceid) from dbo.v_GS_SoftwareFile SF
    Where
    SF.FileName = 'iexplore.exe'
    and SF.FilePath like '%Internet Explorer%'

    select
    replace(left(SF.FileVersion,2), '.','') as 'IE Version',
     Count (Distinct SF.ResourceID) as 'Total', (Count (Distinct SF.ResourceID)/@countval) * 100 as Percentage
       From
    dbo.v_GS_SoftwareFile SF
    Where
    SF.FileName = 'iexplore.exe'
    and SF.FilePath like '%Internet Explorer%'
     Group by  replace(left(SF.FileVersion,2), '.','')


    Please click on "vote as Helpful" if you feel this post helpful to you.

    Eswar Koneti | Configmgr blog: www.eskonr.com | Linkedin: Eswar Koneti | Twitter: Eskonr


    Tuesday, June 4, 2013 6:33 PM
  • Hi,

    There is the similar thread, you may check if it helps:

    http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/97345610-5da6-4d8d-b3e8-f95563e5c250

    Regards,

    Sabrina 

    • Marked as answer by Sabrina Shen Friday, June 21, 2013 7:52 AM
    Thursday, June 6, 2013 6:35 AM

All replies

  • Add the management user ID in to SMS Reporting User Group and add them on report instance security rights as well.

    Then share the report link...

    Tuesday, June 4, 2013 5:41 PM
  • They have that, the problem is the report doesn't link to anything.

    For example, this Report lists the count of each version of IE.

    So there are 43 IE6 machines out there. they want to click the little arrow and see who the 43 computers are. That's the part I can't figure out. it's the drilling down in the report for more info on these results.

    Tuesday, June 4, 2013 5:44 PM
  • you will have to create another report with list of computers ,prompting its IE version.So when you select the IE version,it should display all the computers who have it.

    once you are done with it,go to properties of this report and link the IE(what u have) report what u created-->go to links_>link type.The prompt for the above report would be output of IE version report.

    For more info how to create links follow Ex: Count of MS office  http://eskonr.com/2012/05/sccm-linked-report-ms-office-version-with-service-pack-installed-machines/

    For Percentage of IE Versions,

    Declare @countval float
    select @countval = COUNT(distinct Resourceid) from dbo.v_GS_SoftwareFile SF
    Where
    SF.FileName = 'iexplore.exe'
    and SF.FilePath like '%Internet Explorer%'

    select
    replace(left(SF.FileVersion,2), '.','') as 'IE Version',
     Count (Distinct SF.ResourceID) as 'Total', (Count (Distinct SF.ResourceID)/@countval) * 100 as Percentage
       From
    dbo.v_GS_SoftwareFile SF
    Where
    SF.FileName = 'iexplore.exe'
    and SF.FilePath like '%Internet Explorer%'
     Group by  replace(left(SF.FileVersion,2), '.','')


    Please click on "vote as Helpful" if you feel this post helpful to you.

    Eswar Koneti | Configmgr blog: www.eskonr.com | Linkedin: Eswar Koneti | Twitter: Eskonr


    Tuesday, June 4, 2013 6:33 PM
  • Hi,

    There is the similar thread, you may check if it helps:

    http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/97345610-5da6-4d8d-b3e8-f95563e5c250

    Regards,

    Sabrina 

    • Marked as answer by Sabrina Shen Friday, June 21, 2013 7:52 AM
    Thursday, June 6, 2013 6:35 AM