Microsoft

Microsoft Endpoint Manager Intune Feedback

Suggestion box powered by UserVoice

Christopher Kibble

My feedback

  1. 26 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google Microsoft Intune
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Ideas » Apps config and deployment  ·  Flag idea as inappropriate…  ·  Admin →
    Christopher Kibble commented  · 

    I know this doesn't fix your issue in the report, but you can use the Software Files query to get this data from SCCM (find iexplore.exe in :\Program Files%\Internet Explorer and get file version). If you want to do this in SQL instead of WQL, here is a query I wrote to do just that:

    use cm_cas;

    select distinct v_R_System.Name0
    , 'Internet Explorer' as BrowserTitle
    , v_GS_SoftwareFile.FileVersion as Version0
    , case when charindex('.',v_GS_SoftwareFile.FileVersion) > 0 then substring(v_GS_SoftwareFile.FileVersion, 1, charindex('.',v_GS_SoftwareFile.FileVersion)-1)
    else v_GS_SoftwareFile.FileVersion
    end as version_major
    , v_r_user.departmentnumber0
    , v_r_user.Full_User_Name0
    , v_r_user.Mail0
    , v_r_user.title0
    , v_r_user.company0
    , v_r_user.employeeID0
    from v_R_System
    join v_GS_SoftwareFile
    on v_GS_SoftwareFile.ResourceID = v_R_System.ResourceID
    join v_GS_OPERATING_SYSTEM
    on v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceID
    join v_GS_WORKSTATION_STATUS
    on v_GS_WORKSTATION_STATUS.ResourceID = v_R_System.ResourceID
    join v_biib_system_ou
    on v_R_System.Netbios_Name0 = v_biib_system_ou.Netbios_Name0
    left join v_GS_SYSTEM_CONSOLE_USAGE
    on v_r_system.resourceid = v_GS_SYSTEM_CONSOLE_USAGE.ResourceID
    left join v_R_User
    on v_r_user.Unique_User_Name0 = v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0
    where v_GS_SoftwareFile.FileName = 'iexplore.exe'
    and v_GS_SoftwareFile.FilePath like '%:\Program Files%\Internet Explorer%'

    I also have a query that will find and merge a bunch of browsers into one report (IE, Chrome Machine, Chrome User, Opera, Firefox, and Safari) here: http://ckib.me/82njS

    Good luck!

  2. 2 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google Microsoft Intune
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Ideas » Silverlight Admin Console  ·  Flag idea as inappropriate…  ·  Admin →
    Christopher Kibble shared this idea  · 

Feedback and Knowledge Base