Dynamic Subnet Collection

Dynamic Subnet Collection

select
    * 
from 
    SMS_R_System
    inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceId = SMS_R_System.ResourceId
where
    SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like “192.168.1.%”

Published
Jul 16 2010, 11:02 AM
by
Garth

Filed under: SMS, Code, WQL, SCCM, vNext

Leave a Reply

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