Thursday, April 3, 2014

how to create collection For Unhealthy Clients

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 )

No comments:

Post a Comment