Report to show major Internet Explorer version

Here is the query to show major Internet Explorer

select
    SF.FileName,
    OS.Caption0 as 'OS Version',
    replace(left(SF.FileVersion,2), '.','') as 'IE Version',
    Count (Distinct SF.ResourceID) as 'Total'
From
    dbo.v_GS_SoftwareFile SF
    JOIN v_FullCollectionMembership fcm on SF.ResourceID=fcm.ResourceID
    JOIN dbo.v_GS_OPERATING_SYSTEM OS ON SF.ResourceID = OS.ResourceID
    join dbo.v_GS_SYSTEM S on SF.ResourceID = S.ResourceID
Where
    SF.FileName = 'iexplore.exe'
    and SF.FilePath like '%Internet Explorer%'
    and S.SystemRole0 = 'Workstation'
Group by
    SF.FileName,
    OS.Caption0,
    replace(left(SF.FileVersion,2), '.','')
Order by OS.Caption0

But did you notice there is IE9 on Windows XP workstation, after checking on that workstation, found that the workstation running on dual OS( Win XP+Win 7 ) :