I went to document how many Internet Explorer installs we had for version 8. Ran the standard report on Add/Remove and the numbers were way off, like 40% off!
After a bunch of mapping into machines found that IE was not installing into Add/Remove at all. Especially IE 9 - by default it was being installed as a "UPDATE" !! not as add/remove. Its a Windows feature
So I created the following report to show all installs along with location by IP, user information, hardware information and file install information. Plus used my last primary user to get accurate user information
select distinct case when vc.[ip address] like '10.10.%' then 'San Fran' when vc.[ip address] like '10.12.%' then 'New York' when vc.[ip address] is null then 'No IP' when vc.[ip address] = ' ' then 'No IP' else 'Location by IP unknown' end as [Location], ac.name, ac.[client date], ac.[OS Name] AS 'OS Name', Prime.[primary user], T10.[Given Name] as 'First Name', T10.[Surname]AS 'Last Name', T10.[office telephone], t10.Department , t10.Company, filen.ProductName,left(filen.ProductVersion,1)as 'Version', filen.Manufacturer, filen.[Description], vasset.[status], vasset.[asset type], vasset.[Model], vasset.Manufacturer, vasset.[Serial Number] FROM dbo.Inv_AeX_AC_Identification ac INNER JOIN dbo.Inv_Installed_File_Details prog ON ac._ResourceGuid = prog._ResourceGuid inner join dbo.Inv_Windows_File filen on filen._ResourceGuid = prog.FileResourceGuid left join vAsset on vasset._ResourceGuid = ac._ResourceGuid left join vComputer vc on vc.Guid =ac._ResourceGuid left join (SELECT _ResourceGuid, MAX([user]) AS [primary user] FROM dbo.Inv_AeX_AC_Primary_User WHERE ([User] IS NOT NULL) AND ([User] <> '') GROUP BY _ResourceGuid ) Prime on ac._resourceguid = Prime._ResourceGuid LEFT JOIN dbo.Inv_Global_Windows_Users T20 ON Prime.[primary user] = t20.[USERID] LEFT OUTER JOIN dbo.Inv_Global_User_General_Details T10 ON t20._ResourceGuid = T10._ResourceGuid WHERE filen.[Description] ='Internet Explorer'