List PCs within a Security Group

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.SystemGroupName = “GARTEK\\Visio 2007 PC”

Leave a Reply

Your email address will not be published. Required fields are marked *