Symantec Management Platform (Notification Server)

Hi, I'm looking for a report that will show every version of an installed application on all machines. In this case I want to find out which versions of Internet explorer we are running across our fleet. Any advice appreciated.

Thanks, Cat

Try this report out.

SELECT T1.[Name] AS 'Name', T0.[Name] AS 'Product Name', T0.[Version] AS 'Version', T1.[_ResourceGuid]

FROM [Inv_AeX_OS_Add_Remove_Programs] T0
INNER JOIN [Inv_AeX_AC_Identification] T1 ON T0.[_ResourceGuid] = T1.[_ResourceGuid]

WHERE T0.[Name] LIKE 'windows internet explorer%'

I'd suggest (after making sure this meets your needs) creating a copy of this report and using a report "parameter" in the section where it says 'windows internet explorer%'  If you change that to a parameter like %_product% and then add a prompt before running the report you'll be able to use this one report for any application in Add/remove programs.

Thanks for this report it is very useful, I've played around with parameters to get what I need as at first it would only show IE versions 7 and above, but it will be very useful for other products.