Hi,
I am trying to create a subselect query for test purpose.
select distinct SMS_R_System.Name 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 not in (select SMS_R_System.Name 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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName = "Software_x" and SMS_G_System_OPERATING_SYSTEM.Caption = "Microsoft Windows 8.1 Entreprise") order by SMS_R_System.Name
My problem is that query did not excluse computers who already have Software_x.
I create a query with computers who have Software_x and they are appearing correctly but the second query who don't have software_x is not excluding these computers.
Any idea?
Thanks,