Is the problem developing a report or the installations still showing "premium" in program & features (add/remove pgms)?
Here is my query for visio via installed products STAN% or PRO% or PREM201% x86 select distinct SMS_R_System.Name, SMS_R_System.LastLogonUserName, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version, SMS_R_System.OperatingSystemNameandVersion 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 "Microsoft Visio%Stan%201%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Visio%Pro%201%" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Microsoft Visio%Prem%201%" From: [email protected] [mailto:[email protected]] On Behalf Of Aday, Karalene B (RCIS) Sent: Friday, October 30, 2015 10:34 AM To: [email protected] Subject: [mssms] RE: Report Question **WARNING** This message originated outside of NPPD. DO NOT click on any links or attachments unless you have confirmed that it is from a trusted sender. ________________________________ I have 3 separate installs for each edition that I built using the Office Customization wizard and each install has a separate xml file that is configured with the correct license code for the version requested. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Chramosta, Steven C. Sent: Friday, October 30, 2015 10:27 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Report Question Ultimately, in order to get add/remove programs to register correctly, we were forced to do an uninstall/reinstall of the Visio with the correct key in our .xml file. I tried to use license activation scripts and while they changed the license from premium to standard, they didn't change the registration in add/remove programs. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Aday, Karalene B (RCIS) Sent: Friday, October 30, 2015 10:11 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] Report Question **WARNING** This message originated outside of NPPD. DO NOT click on any links or attachments unless you have confirmed that it is from a trusted sender. ________________________________ I have a question regarding a report for Microsoft Visio 2010, In add/remove programs it Shows Microsoft Visio Premium. The edition is changed by the product key entered. So, if you have Standard in Add/Remove programs it shows as Premium. I can only find information on what edition is installed in the HKey_current_user registry hive. I can find how to change the mof file to inventory the Hkey_local_machine but not for the Hkey_current_user hive. Is the possible or does anyone have a different way to get the edition of Visio 2010 installed through a report or a query. Thank you!
