Help with WQL to show version from Add/Remove programs and Add/Remove Programs x64

• Tuesday, March 20, 2012 4:02 PM

   

   
  

  0

  I have a query that shows me software display name like  "Global%" from Add Remove programs and add remove programs x64 and its working fine and it displays the system resource id computer name, However I'm having trouble adding to this query to also show the Version# and Version name. Everything I have tried displays way more information that i need. Can someone helpe me figure this out so that the query will 1)Look in Add Remove program and Add Remove programs x64 and 2)Show me the Computer Name, The Version of software, and the Version software name?

  Here is my base query that works fine until I try to display more fields.

  select distinct SMS_R_System.Name from  SMS_R_System where SMS_R_System.ResourceId in (select SMS_R_System.ResourceID  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 "Global%") or SMS_R_System.ResourceId in (select SMS_R_System.ResourceID from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where  SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName LIKE "Global%")

  • Moved by Moiz Rassiwala[MSFT]Microsoft Employee Wednesday, March 21, 2012 7:27 PM (From:Configuration Manager General)
  •  
  • Reply
  • Quote