I'm in the process of installing IE8 on a mixed environment of Windows XP/SP3 and very few Windows 7. I have a query that works when Add/Remove programs has Windows Internet Explorer 8, but this is not the case in all computers. As we refresh them to Windows 7 the count drops lower and lower. Looking for an alternate query that will show me ALL machines that have IE8 installed, whether it shows in Add/Remove programs or not. Thanks.

Hi, You can use the built-in AI report. Report Name: Software 02C - Software by Category and Family Category: Asset Intelligence Kent Agerlund | http://scug.dk/ | The Danish community for System Center products

Hi Using this query: SELECT DISTINCT a.Name0 AS [Machine Name], b.SiteCode,c.FileVersion AS [IE Version], d.Operating_System_Name_and0, c.FilePath FROM v_GS_SoftwareFile c INNER JOIN v_GS_SYSTEM a ON c.ResourceID = a.ResourceID INNER JOIN v_R_System d ON a.ResourceID = d.ResourceID INNER JOIN v_FullCollectionMembership b ON a.ResourceID = b.ResourceID WHERE (c.FileName = ‘iexplore.exe’) AND (c.FileVersion like ’8.0%’ ) ORDER BY a.Name0Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.