Tuesday, March 20, 2012 4:02 PM
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)
Tuesday, March 20, 2012 4:19 PM
To make the query happy and more efficienty I always make two queries. One for 32bit and one for x64. Create a new query that is just one and add the version information and see if it works out.
the other method would be to use Asset Intelligence (Installed Software)