Software Installed based on AD Security Group??

[ibrafe]

Hello

 

We have users in AD group that we would like to write a query that will return a specific software installed on their PCs. The query I have below seems to return blank result. Any help will be highly appriciatted.

 

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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.UserName in (select UniqueUserName from SMS_R_User where UserOUName = "Domain/SMS Security/DEPT/Java Users") and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "Java%"

 

 

Thanks