IP address range boundary - query and build collection

Tutte le risposte

• lunedì 11 giugno 2012 11:22

  Moderatore

   

   
  

  0

  Just to be clear, you can't create a collection based on boundaries.  What you can do is create a collection using similar information that a client uses; when a client locally just-so-happens to query Active Directory, and makes decisions based on boundaries, and the decision it is making depends upon it's enabled ipaddress.

  Something like this:

  select SMS_R_SYSTEM.ResourceID
  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 "1.1.1.%" and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPEnabled = 1

  ---

  Standardize. Simplify. Automate.

  • Contrassegnato come risposta Yoshikazuko lunedì 11 giugno 2012 14:18
  •  
  • Risposta
  • Citazione

   
• lunedì 11 giugno 2012 12:02

   

   
  

  0

  Hi,

  Try this one:

  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.IPAddresses like "192.168.1%"

  regards,
  Jörgen

  ---

  -- My System Center blog ccmexec.com -- Twitter @ccmexec

  • Contrassegnato come risposta Yoshikazuko lunedì 11 giugno 2012 14:18
  •  
  • Risposta
  • Citazione

   
• lunedì 11 giugno 2012 14:19

   

   
  

  0

  Hi Sherry, Hi Jörgen exactly what i needed, thank you very much !

  • Risposta
  • Citazione