Hello. I am looking for a query that will pull the following. 1. Application A installed AND Application 2 or Application 3 Installed Basically the Query needs to pull a machine that has A with one of the other apps (2 or 3) --- Here is the Query that I have used but noticed one machine that had Application 3 did not register in it: --- select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 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.Publisher = "iAnywhere Solutions, Inc." and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "TellerInsight" or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "BankerInsight" --- Thanks for your help. JJCV

Only one machine is not getting fetched to the collection rest everything is working as expected? If yes, try to check whether the hardware inventory intiated recently from that system. Also, check the resource explorer of that system to get more details.Anoop C Nair - This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Change your WHERE clause to WHERE ARP.Publisher = 'A' AND (ARP.DisplayName='B' OR ARP.DisplayName='C') The only concern I have is that your logic here is returning all computers that have an application from a publisher called A, and the application is either B or C. Not exactly what you said in your message. Telmo SampaioTelmo Sampaio

So is it possible the SCCM client on that machine is not up to par which is causing it not to report? That's werid because I had a different query to check ONLY for Application A and it registered there. Only this query didnt bring it along. I checked resource explorer and do see Application 3 (TellerInsight) installed there - JJCV

Telmo you are right. Bare with me I am not too Query savy, I used it from an existing one. So basically just specify Publishes for App A and 2/3? or Both Publisher AND Add/Remove Programs info?JJCV