I am after a query that will show me whether workstation have a professional or standard version of an office product like visio 2010.
I have the following which I have found on here, but can not tweak it to show that, not very good with queries in SCCM at the moment.
select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visio Standard%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visio Professional%" order by SMS_R_System.Name
Updated the query and got it working how I like now. Run this against all active computers and it will return what version they have Professional or Standard.