TheWhiteDragon

the issue is that it doesnt show the current state. installed/uninstalled/upgraded etc. ie i install project 2013 to fix someones project file, i then uninstall it, the report still shows me as having 2013 installed.. even though i dont have it anymore.. this is the issue im facing as part of the version issue.

Hi All, i have recently built a script which reports total installs for project etc but i noticed that the data is showing Previous installs as well ?? ie user had 2007, upgraded to 2010, then upgraded to 2013 - this then shows its installed 3 times on the same machine ?? is there a way to limit it to ONLY showing the CURRENT installation ?? Current Code :- SELECT dbo.v_R_System.Netbios_Name0, dbo.v_R_System.User_Name0, dbo.v_GS_ADD_REMOVE_PROGRAMS.Publisher0, dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 FROM dbo.v_R_System INNER JOIN dbo.v_GS_ADD_REMOVE_PROGRAMS ON dbo.v_R_System.ResourceID = dbo.v_GS_ADD_REMOVE_PROGRAMS.ResourceID WHERE (dbo.v_GS_ADD_REMOVE_PROGRAMS.Publisher0 LIKE '%Microsoft%') AND (dbo.v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 LIKE '%Project%')