how to create collection For Unhealthy Clients:
WQL Query :
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.Obsolete = 0 or SMS_R_System.Obsolete is null ) and SMS_R_System.SMSAssignedSites is not null and (SMS_R_System.Client = 0 or SMS_R_System.Client is null )
WQL Query :
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.Obsolete = 0 or SMS_R_System.Obsolete is null ) and SMS_R_System.SMSAssignedSites is not null and (SMS_R_System.Client = 0 or SMS_R_System.Client is null )
No comments:
Post a Comment