Wednesday, 10 November 2021

WQL quality to create collection with IP range

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 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 "10.%" or

SMS G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress like "172.%"
Share:

0 $type={blogger}:

Post a Comment