Query Help
Hello All, I have an application with different versions installed in my environment. I have to create a query to list out different versions of the application along with their uninstall string. Is there a query available in order to extract that information.
February 15th, 2010 12:34pm

Hi,You can use this to get you started:select distinct SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.ProdID, SMS_G_System_ADD_REMOVE_PROGRAMS.Version 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 ##PRM:SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName##When you run the query you can use qild cards eg. Microsoft Office% to display all Office 2007 installations. The uninstall command is the product code with a /X to uninstall.Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products
Free Windows Admin Tool Kit Click here and download it now
February 15th, 2010 1:48pm

Hi Kent,I tried using the Query, but it is not returning any results
February 15th, 2010 3:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics