select distinct
SMS_G_System_SYSTEM.Name
from
SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId
where
SMS_R_System.ResourceId not in (select distinct
SMS_G_System_COMPUTER_SYSTEM.ResourceID
from
SMS_G_System_COMPUTER_SYSTEM inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_G_System_COMPUTER_SYSTEM.ResourceId
where
SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “%.NET Framework 2.0%”)
order by
SMS_G_System_SYSTEM.Name
Recent Comments