*********************************************************
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 where
(SMS_R_System.SystemOUName like "AD.YOURDOMAIN.COM/OU"
or SMS_R_System.ResourceDomainORWorkgroup like "DOMAIN1" or
SMS_R_System.ResourceDomainORWorkgroup like "DOMAIN2")and SMS_R_System.OperatingSystemNameandVersion
like "Microsoft Windows NT Workstation 6.1"
No comments:
Post a Comment